Mass General Brigham is looking for a Senior Data Engineer to design, develop, and maintain our data architecture and infrastructure. You will play a crucial role in managing large-scale data systems and ensuring the efficient flow, storage, and accessibility of data for various stakeholders.

What You'll Do

Design, develop, and implement data pipelines and ETL/ELT code to support business requirements.
Work on cross-functional teams delivering enterprise solutions for internal and external clients.
Assume ownership for delivering code revisions and enhancements from design through development and production installation.
Maintain and optimize various components of the data pipeline architecture.
Become subject matter expert for internal and external data products.
Ensure design solutions can scale and meet technical standards and performance benchmarks.
Identify inefficient processes and develop recommendations and design solutions.
Lead code review sessions to validate technical solutions and facilitate knowledge sharing.
Work with cross-functional teams to understand functional product requirements and deliver on strategic data and analytics initiatives.
Design, build, test and maintain architectures within the ‘Quality Data Hub’ of our cloud-based enterprise data warehouse.
Build ETL/ELT ingestions for OCMO related data and handle related monitoring and support duties.
Define and implement the processes and tooling through which enterprise curated data models are built and maintained.
Partner with solutions architects, analytics engineers, and data visualization developers to understand data extraction and transformation needs and builds a platform and related processes suited to them.
Develop and enforce change management and versioning processes for code promotion.
In collaboration with lead analytic staff, architect and enforce thorough quality assurance, testing and peer review procedures to ensure the accuracy, reliability, and validity of end products.
Help 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.
Build and foster relationships with senior leadership/physicians and key program stakeholders to understand multifaceted business problems and develop analytical solutions to complex issues.
Support other team members with promotion to production, ensures a consistent process across the team; informs other data engineers and domain team leads of new changes to promotion process.
Guide and train data engineers by familiarizing them with the data products they will use and providing them with relevant information about OCMO domains.
Follow 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.
Perform other duties and responsibilities as assigned.

What We're Looking For

Bachelor's Degree in a Related Field of Study required (or equivalent experience).
5+ years’ experience with data modelling, ETL/ELT development, or similar role working with complex SQL queries and data extraction/transformation.
A strong background in data warehousing projects.
Ability to identify, triage, and resolve or dispatch issues.
Strong data analysis skills and ability to perform data analysis using SQL, SAS, or similar query languages.
Strong oral and written communication skills.
Capable of working independently with limited to no supervision.
Willing to contribute to and foster a team player culture where all are encouraged and willing to share information accurately.
Advanced SQL DML skills required, with comparable experience in writing data functions (e.g. TSQL procs, Snowflake UDFs, etc.).
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.
Strong interpersonal skills to effectively communicate with cross functional teams including staff at all levels of the organization.
Able and motivated to mentor/train junior staff members.
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.

Nice to Have

Prior experience working with healthcare data is strongly preferred.
Prior experience working with dbt is strongly preferred.
Knowledge of agile principles and experience working within an agile team is preferred.
Experience with cloud data warehousing environments such as Microsoft Azure and Snowflake are a plus.
Experience with ETL/data modelling tools such as dbt, Informatica, and Ab Initio are a plus.
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.

Technical Stack

SQL
ETL/ELT
dbt
Microsoft Azure
Snowflake
Informatica
Ab Initio
SAS

Team & Environment

You will work with cross-functional teams, partnering with solutions architects, analytics engineers, and data visualization developers.

Benefits & Compensation

Compensation: $92,102.40 - $134,056.00/Annual

Work Mode

This is a hybrid role based at 399 Revolution Drive.

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.