Data Engineer

Mass General Brigham•Somerville, MA

3d•Hybrid

About The Position

Mass General Brigham relies on a wide range of professionals, including doctors, nurses, business people, tech experts, researchers, and systems analysts to advance our mission. As a not-for-profit, we support patient care, research, teaching, and community service, striving to provide exceptional care. We believe that high-performing teams drive groundbreaking medical discoveries and invite all applicants to join us and experience what it means to be part of Mass General Brigham. Mass General Brigham Digital, in partnership with the Office of the Chief Medical Officer (OCMO), is seeking an experienced Data Engineer who has a passion for healthcare data and will thrive as a member of an experienced, high performing and highly motivated team. This person will have a desire to learn and a flexibility to adjust to the fast-changing analytic and reporting demands of our system. The best candidate has solid analytical and communication skills, and experience working with health care data. Job Summary Reporting to the Data Engineering Manager, the Data Engineer will be a member of a cross-functional team responsible for developing new clinical data products. The areas of focus include Quality, Safety, Health Equity, Community Health, Patient Experience, Provider Wellbeing, Credentialing, and Pharmacy and Formulary. The ideal candidate will collaborate with a multidisciplinary team to define and achieve strategic objectives. They will be responsible for developing the Quality Data Hub within our cloud-based data warehouse. They will collaborate closely with solutions architects, analytics engineers, and visualization developers to understand requirements, establish robust change management practices, and implement rigorous quality assurance measures. Additionally, the role involves proactive performance monitoring, troubleshooting data issues, and adhering to MGB Digital’s standards and practices.

Requirements

Bachelor’s or master’s degree in computer science, informatics, statistics, or related field and an interest in healthcare and the use of technology to support clinical care.
1-3 years of experience as an Analytics Engineer, Data Engineer, or similar role.
1-3 years of experience in business intelligence/analytics, preferably working with healthcare data.
Proficiency in querying complex data structures using SQL is required.
Experience with transforming and modeling workflow tools, such as DBT or Informatica.
Experience working with cloud data platforms such as Snowflake, Azure Synapse, Amazon Redshift, etc.
Experience with general source control principles and implementing CI/CD pipelines.
Experience with implementing scalable ETL/ELT pipelines.
Working knowledge of traditional data warehousing and cloud data warehousing concepts.
Strong programming skills and proficient in other programming languages (e.g., SAS, R, and Python)
Ability to function effectively and independently in a fast-paced environment, organize and prioritize work independently, and meet tight deadlines.
Ability to manage multiple projects simultaneously, set priorities, and collaborate with team members and others throughout the organization.
Possess strong interpersonal skills to effectively communicate with cross functional teams including staff at all levels of the organization.
Willing to contribute to and foster a team player culture where all are encouraged and willing to share information accurately.
Practical problem-solving abilities, i.e. the ability to formulate hypotheses, test options and move forward in a fast-paced environment.
Excellent interpersonal skills, including strong customer service orientation and the ability to translate complex technical concepts to non-technical audiences.
Advanced SQL DML skills required, with comparable experience in writing data functions (e.g. TSQL procs, Snowflake UDFs, etc.).

Nice To Haves

Able and motivated to mentor/train junior staff members.
Knowledge of agile principles and experience working within an agile team is preferred.
Experience developing/configuring agentic AI a plus.
Working knowledge of data visualization (Tableau) software a plus.
Proficiency or Certification in Epic Clarity / Caboodle data model a plus.

Responsibilities

Design, build, test and maintain data models within the ‘Quality Data Hub’ of our cloud-based enterprise data warehouse.
Partners with solutions architects, analytics engineers, and data visualization developers to fully understand our data transformation needs and final model design to competently implement said design.
In collaboration with analytic staff, performs thorough quality assurance, testing and peer review procedures to ensure the accuracy, reliability, and validity of end products.
Adheres to the processes and tooling through which our enterprise curated data models are built and maintained. Participates in related process improvement efforts.
Adheres to established change management and versioning processes for code promotion. Participates in related process improvement efforts as well.
Collaborates on ingestion design for OCMO related data and handle related monitoring and support duties.
Accrues advanced knowledge of the OCMO product domains and can quickly apply development strategies to meet the stakeholder requirements for the data products.
Helps identify potential bottlenecks within the development lifecycle and propose high-level strategies to overcome them.
Triage, troubleshoot and resolve data issues from end users and internal team members.
Follows MGB Digital guidelines and standard practices to leverage existing tools and methods to efficiently develop modeling solutions, ensure that work is not duplicated, and is appropriately transitioned between teams.
Uses 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.