Data Warehouse Architect Jobs

Data Warehouse Architect

- (3253660)

About Us

As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Women’s Hospital and Massachusetts General Hospital, Mass General Brigham supports a complete continuum of care including community and specialty hospitals, a managed care organization, a physician network, community health centers, home care, and other health-related entities. Several of our hospitals are teaching affiliates of Harvard Medical School, and our system is a national leader in biomedical research.

We’re focused on a people-first culture for our system’s patients and our professional family. That’s why we provide our employees with more ways to achieve their potential. Mass General Brigham is committed to aligning our employees’ personal aspirations with projects that match their capabilities and creating a culture that empowers our managers to become trusted mentors. We support each member of our team to own their personal development—and we recognize success at every step.

Our employees use the Mass General Brigham 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.

General Summary

The Data Warehouse Architect is a key role responsible for designing, developing, and maintaining the data architecture for the Digital Data Architecture at Mass General Brigham. This involves creating and refining conceptual, logical, and physical data models that align with current standards and conventions. The Data Warehouse Architect plays a crucial role in understanding the organization's data and analytic landscape, including data sources, assets, tools, and master data.

Principal Duties and Responsibilities

• Develops and revises conceptual, logical, and physical data models for Digital (i.e., Digital Data Architecture).
• Builds and maintains a deep understanding of the data and analytic landscape at Mass General Brigham including data sources, data and analytic assets and products, analytic tools and software, and master data.
• Develops and revises data dictionary definitions, governance practices, and standards.
• Creates data models that conform to current standards and conventions.
• Use/s the Mass General Brigham 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.
• 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.
• Presents technical solutions to stakeholders and end users.
• Follows standards for technology and technical processes.
• Assists in the Development of data asset training and documentation.
• Other duties and responsibilities as assigned.
• Interviews business users to obtain requirements for enhancements and/or new analytic assets
• Partners with security architects to ensure compliance with data security and privacy policies and procedures.
• Develops and tests extraction, transformation, and load (ETL) processes. Hands-on development experience with ETL/ELT tools, such as DBT or Informatica.
• Maps source system data to data warehouse models.
• Participates in Architectural strategies on the EDW migration to Cloud platform e.g., integration with Data Lake and other Azure services.
• Works with teams to integrate data across clinical, administrative, and financial source systems including the management of critical master data.

Qualifications

• Minimum of 5 years of relevant experience including continuing to innovate data architecture design and deployment, and data modelling especially dimensional data modeling (OLAP)

• Experience with Cloud Data Warehouse platforms e.g., Snowflake, Azure Synapse

• Experience with the Azure stack (Azure Data Factory, ADLS, Azure Databricks, Azure ML, Azure Synapse, 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 and Competencies

• Relational and dimensional data modeling and database design skills
• Understands how data is used to support analytical and/or operational reporting
• Understanding of SQL and relational and multidimensional designs
• Flexibility, diplomacy, and problem-solving
• Knowledge of data warehousing architectural approaches
• Excellent consultative skills, understanding business needs and translating those needs to technical requirements and solutions.
• Ability to communicate effectively with all levels of the organization including senior business and clinical leaders and executives
• Strong creative problem solving with ability to craft solutions to meet the wide range of business needs across the organization
• Understands BI tool architecture, functions, features
• Must have strong data modeling skills
• Adept at establishing trusted relationships at all levels across the organization and collaborating across multi-functional teams
• Must have excellent verbal and written communication skills
• Ability to construct queries using a supported query tool

Other:

• Demonstrates fiscal responsibility by effectively using Mass General Brigham resources.
• No direct reports; may provide guidance to less seasoned and new staff.

Diversity Statement

As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community. We place great value on being a diverse, equitable and inclusive organization as we aim to reflect the diversity of the patients we serve. At Mass General Brigham, we believe in equal access to quality care, employment and advancement opportunities encompassing the full spectrum of human diversity: race, gender, sexual orientation, ability, religion, ethnicity, national origin and all the other forms of human presence and expression that make us better able to provide innovative and cutting-edge healthcare and research.

EEO Statement

Mass General Brigham is an Equal Opportunity Employer. By embracing diverse skills, perspectives, and ideas, we choose to lead. All qualified applicants will receive consideration for employment without regard to race, color, religious creed, national origin, sex, age, gender identity, disability, sexual orientation, military service, genetic information, and/or other status protected under the law. We will ensure that all individuals with a disability are provided a reasonable accommodation to participate in the job application or interview process, perform essential job functions, and receive other benefits and privileges of employment.

Primary Location MA-Somerville-MGB Assembly Row

Other Locations MA-Boston-MGB Remote See Posting for Details

Work Locations MGB Assembly Row 399 Revolution Drive Somerville 02145

Job Business Intelligence/Data Warehousing

Organization Mass General Brigham

Schedule Full-time

Standard Hours 40

Shift Day Job

Posted Shift Description Remote role Eastern hours.

Employee Status Regular

Recruiting Department MGB Digital

Job Posting Aug 1, 2023