Vacancy expired!
Job Description
Role: Senior Data Warehouse Architect (Data & Analytics Organization) Location: Fully Remote (Somerville, MA) Duration: Fulltime Permanent MUST HAVES: 8 years of deep dimensional modeling experience Leadership skills Good understanding of overall data architecture Experience in SQL Programming Strong Communication skills Self Motivated Team Player As a Senior Data Architect, you are a critical member of the Digital Analytics, Enterprise Data Warehouse Data Architecture team. The Data Architecture team works together with other Digital teams to design, develop, validate, maintain, and support the EDW platform and many different analytic data assets and products. The EDW team is in process of migrating to a Cloud Data platform and looking for a Cloud enthusiast as we move to Azure Cloud. The ideal candidate will have a strong data architecture pedigree, enjoys working with new data technologies and excellent communication and leadership skills. If you are seeking a new challenge and are motivated by transformations we encourage you to apply. Principal Duties and Responsibilities Design, develops and revises conceptual, logical, and physical data models that conform to Data Architecture standards for Digital (i.e., Digital Data Architecture) Builds and maintains a deep understanding of the data and analytic landscape at including data sources, data and analytic assets and products, analytic tools and software, and master data Acts as Technical Lead on data projects and guide and mentor other Data Architects and Data Engineers Determines database structural requirements by analyzing business operations, applications, and programming; reviewing objectives with business partners; evaluating current systems. Applies expertise and best practices to the development and revision of data architecture standards and conventions Partners with security architects to ensure compliance with data security and privacy policies and procedures Participates in Architectural strategies on the EDW migration to Cloud platform e.g., integration with Data Lake and other Azure services Interviews business users to obtain requirements for enhancements and/or new analytic assets Understands how data is used to support analytical and/or operational reporting including architectural dependencies, high-volume processing, and enterprise-level integration Works with teams to integrate data across clinical, administrative, and financial source systems including the management of critical master data Follows standards for technology and technical processes Presents technical solutions to stakeholders and end users Use/s the values to govern decisions, actions, and behaviors. These values guide how we get our work done: Patients, Affordability, Accountability & Service Commitment, Decisiveness, Innovation & Thoughtful Risk; and how we treat each other: Diversity & Inclusion, Integrity & Respect, Learning, Continuous Improvement & Personal Growth, Teamwork & Collaboration Other duties and responsibilities as assigned Qualifications: Minimum of 8 years of relevant experience including continuing to innovate data architecture design and deployment, and data modelling especially dimensional data modeling (OLAP), and database development Experience with Cloud Data Warehouse platforms e.g., Snowflake, Azure Experience with the Azure stack (Azure Data Factory, ADLS, Azure Databricks, Azure Client, and Azure SQL) to help build a modern platform for data that will be sourced from a variety of analytic and operational application Must possess strong data modeling skills Must possess experience using Erwin or similar tools for developing and maintaining data models Must possess strong data analysis skills into source systems to profile source system data Must have strong experience with SQL Experience with SQL Server platform is preferred Healthcare industry experience and Epic data experience is preferred Experience with Tableau reporting tools a plus but not required Experience in agile development data projects a plus but not required Skills/Abilities/Competencies Must have excellent verbal and written communication skills Understands how data is used to support analytical and/or operational reporting Excellent consultative skills, understanding business needs and translating those needs to technical requirements and solutions. Strong creative problem solving with ability to craft solutions to meet the wide range of business needs across the organization Adept at establishing trusted relationships at all levels across the organization and collaborating across multi- functional teams Relational and dimensional data modeling and database design skills Knowledge of data warehousing architectural approaches Understanding of SQL and relational and multidimensional designs Ability to construct queries using a supported query tool Understands BI tool architecture, functions, features Flexibility, diplomacy, and problem-solving Ability to communicate effectively with all levels of the organization including senior business and clinical leaders and executives Leadership and fiscal responsibilities #LI-FRESH- ID: #48602939
- State: Massachusetts Somerville 02143 Somerville USA
- City: Somerville
- Salary: USD TBD TBD
- Job type: Contract
- Showed: 2023-01-16
- Deadline: 2023-03-16
- Category: Et cetera