Data Engineer

Site: Mass General Brigham Incorporated

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

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.

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.

Qualifications

Principal Duties and 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.

Additional Job Details (if applicable)

Qualifications

• 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.
• Proficiency in transforming and modeling workflow tools, using tools such as dbt/Informatica/SSIS. Candidates with dbt experience highly preferred.
• 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)
• 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.

Skills/Abilities/Competencies

• 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.
• Able and motivated to mentor/train junior staff members.
• Knowledge of agile principles and experience working within an agile team is preferred.
• 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.).

Working Conditions

• Hybrid with onsite work required in office, candidate must be flexible for weekly or monthly business needs
• M-F Eastern business hours required
• On remote workdays, employees must use a stable, secure, and compliant workstation in a quiet environment. Teams video is required and must be accessed using MGB-provided equipment

Remote Type

Hybrid

Work Location

399 Revolution Drive

Scheduled Weekly Hours

40

Employee Type

Regular

Work Shift

Day (United States of America)

Pay Range

$75,275.20 - $109,553.60/Annual

Grade

6

At Mass General Brigham, we believe in recognizing and rewarding the unique value each team member brings to our organization. Our approach to determining base pay is comprehensive, and any offer extended will take into account your skills, relevant experience if applicable, education, certifications and other essential factors. The base pay information provided offers an estimate based on the minimum job qualifications; however, it does not encompass all elements contributing to your total compensation package. In addition to competitive base pay, we offer comprehensive benefits, career advancement opportunities, differentials, premiums and bonuses as applicable and recognition programs designed to celebrate your contributions and support your professional growth. We invite you to apply, and our Talent Acquisition team will provide an overview of your potential compensation and benefits package.

EEO Statement:

0100 Mass General Brigham Incorporated is an Equal Opportunity Employer. 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 law. We will ensure that all individuals with a disability are provided a reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. To ensure reasonable accommodation for individuals protected by Section 503 of the Rehabilitation Act of 1973, the Vietnam Veteran's Readjustment Act of 1974, and Title I of the Americans with Disabilities Act of 1990, applicants who require accommodation in the job application process may contact Human Resources at (857)-282-7642.

Mass General Brigham Competency Framework

At Mass General Brigham, our competency framework defines what effective leadership "looks like" by specifying which behaviors are most critical for successful performance at each job level. The framework is comprised of ten competencies (half People-Focused, half Performance-Focused) and are defined by observable and measurable skills and behaviors that contribute to workplace effectiveness and career success. These competencies are used to evaluate performance, make hiring decisions, identify development needs, mobilize employees across our system, and establish a strong talent pipeline.