Data Warehouse Architect

Mass General Brigham - Somerville, MA

Full-time - Mid Level

Somerville, MA

Ambulatory Health Care Services

About the position

The Data Warehouse Architect at Mass General Brigham is responsible for designing and implementing cloud data solutions within the organization's data platform. This role involves creating data models, providing technical leadership, and ensuring compliance with data security policies. The architect will work closely with various teams to integrate data across clinical, administrative, and financial systems, while also mentoring other technical team members and mapping source system data to data warehouse models.

Responsibilities

• Creates end to end solution design of cloud data solutions within the MGB cloud data platform.
• Builds and maintains a deep understanding of the data and analytic landscape at Mass General Brigham.
• Provides technical leadership to development teams including guiding, coaching, and mentoring other technical team members.
• Develops and revises conceptual, logical, and physical data models that conform to current standards and conventions.
• Applies expertise and best practices to the development and revision of data architecture standards and conventions.
• Develops and revises data dictionary definitions, governance practices, and standards.
• 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.
• Interviews business users to obtain requirements for enhancements and/or new analytic assets.
• Maps source system data to data warehouse models.
• Assists in the Development of data asset training and documentation.
• Works with teams to integrate data across clinical, administrative, and financial source systems.
• Develops and tests extraction, transformation, and load (ETL) processes.
• Follows standards for technology and technical processes.
• Presents technical solutions to stakeholders and end users.

Requirements

• Minimum of 5 years of relevant experience including continuing to innovate data architecture design and deployment, and data modelling.
• 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).
• Strong data modeling skills.
• Experience using Erwin or similar tools for developing and maintaining data models.
• Strong data analysis skills into source systems to profile source system data.
• Strong experience with SQL.
• 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.
• Excellent oral and written communication skills.
• 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.

Nice-to-haves

• Experience with Tableau reporting tools a plus but not required.
• Healthcare industry experience and Epic data experience is preferred.

Benefits

• Comprehensive health insurance coverage.
• 401k retirement savings plan with matching contributions.
• Paid time off and holidays.
• Professional development opportunities.
• Flexible scheduling options.