Data Engineer Senior

Mass General Brigham•Somerville, MA

1d•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. Job Summary Summary Responsible for designing, developing, and maintaining the data architecture and infrastructure within an organization. This position plays a crucial role in managing large-scale data systems and ensuring the efficient flow, storage, and accessibility of data for various stakeholders, such as data analysts, data scientists, and business users.

Requirements

Bachelor's Degree Related Field of Study required
5+ years’ experience with data modelling, ETL/ELT development, or similar role working with complex SQL queries and data extraction/transformation.
Must possess a strong background in data warehousing projects.
Must be able to identify, triage, and resolve or dispatch issues.
Must possess strong data analysis skills and be able to perform data analysis using SQL, SAS, or similar query languages.
Must possess strong oral and written communication skills.
Must be capable of working independently with limited to no supervision.
Must be 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.
Possess strong interpersonal skills to effectively communicate with cross functional teams including staff at all levels of the organization.

Nice To Haves

Prior experience working with healthcare data is strongly preferred.
Prior experience working with dbt is strongly 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.
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.
Experience 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.

Responsibilities

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.
Works 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.
Accrues advanced knowledge of the OCMO product domains and can quickly apply development strategies to meet the stakeholder requirements for the data products.
Define and implement the processes and tooling through which enterprise curated data models are built and maintained.
Partners 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.
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.
Build and foster relationships with senior leadership/physicians and key program stakeholders to understand multifaceted business problems and develop analytical solutions to complex issues to satisfy reporting and analytical needs.
Supports 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.
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.