Data Engineer Senior

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

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.

Does this position require Patient Care?
No

Essential Functions
-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.

 

Qualifications

Education
Bachelor's Degree Related Field of Study required

Can this role accept experience in lieu of a degree?
Yes

Principal Responsibilities

• 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.

Knowledge, Skills and Abilities

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

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.
• 5+ years’ experience with data modelling, ETL/ELT development, or similar role working with complex SQL queries and data extraction/transformation.
• 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.
• 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.

Hybrid position:

• Onsite Flexible Hybrid working model requires weekly office working days, 1-3 days per week onsite
• M-F Eastern Business hours required
• Remote working days require stable, secure, quiet, compliant working station

 

Additional Job Details (if applicable)

 

Remote Type

Hybrid

 

Work Location

399 Revolution Drive

 

Scheduled Weekly Hours

40

 

Employee Type

Regular

 

Work Shift

Day (United States of America)

 

EEO Statement:

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.