Data Warehouse Architect

Overview

On Site
Full Time

Skills

Network
Teaching
Biomedicine
Research
Personal development
Software design
Use cases
IT management
Coaching
Mentorship
Data dictionary
Governance
Regulatory Compliance
Data security
Privacy
Policies and procedures
Migration
Data Lake
Training
Documentation
Finance
Management
Master data management
Extraction
Transformation
Extract
transform
load
ELT
Informatica
Accountability
Innovation
Continuous improvement
Teamwork
Collaboration
Data architecture
Design
Software deployment
Cloud computing
Snow flake schema
Databricks
Machine Learning (ML)
Microsoft Azure
SQL Azure
Analytical skill
ERwin
Data Analysis
SQL
Health care
Epic
Tableau
Reporting
Agile
Data
Data modeling
Communication
Creative problem solving
Dimensional modeling
Database design
Data warehouse
Business intelligence
Problem solving
MASS
Leadership
Military
Law

Job Details

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. .

Principal Duties and Responsibilities

Creates end to end solution design of cloud data solutions within the MGB cloud data platform including data ingestion patterns/solutions, curated data models, and business use case driven data products.

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.

Provide 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 e.g., integration with Data Lake and other Azure services.

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 including the management of critical master data.

Develops and tests extraction, transformation, and load (ETL) processes. Hands-on development experience with ETL/ELT tools, such as DBT or Informatica.

Follows standards for technology and technical processes.

Presents technical solutions to stakeholders and end users.

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.

Other duties and responsibilities as assigned.

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) 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

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

Must possess strong data modeling skills

Must possess 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 and collaborating across multi-functional teams

Relational and dimensional data modeling and database design skills

Knowledge of data warehousing architectural approaches

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

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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.