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.

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…