Overview
Remote
On Site
Full Time
Skills
Teaching
AIM
Research
Health Care
Analytical Skill
Backbone.js
Content Management
Pharmacy
Quality Control
Program Development
Analytics
Data Integration
Scrum
Data Architecture
Management
Storage
Accessibility
Code Review
Knowledge Sharing
Data Engineering
FOCUS
Data Warehouse
Reporting
Snow Flake Schema
Streaming
Extract
Transform
Load
ELT
Agile
Amazon Web Services
Google Cloud Platform
Google Cloud
Microsoft Azure
Database
Cloud Computing
Audio Engineering
Assembly
Military
Law
MASS
Leadership
Recruiting
Job Details
Site: Mass General Brigham Incorporated
At Mass General Brigham, we know it takes a surprising range of talented professionals to advance our mission-from doctors, nurses, business people and tech experts, to dedicated researchers and systems analysts. As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community. We place great value on being a diverse, equitable and inclusive organization as we aim to reflect the diversity of the patients we serve.
At Mass General Brigham, we believe a diverse set of backgrounds and lived experiences makes us stronger by challenging our assumptions with new perspectives that can drive revolutionary discoveries in medical innovations in research and patient care. Therefore, we invite and welcome applicants from traditionally underrepresented groups in healthcare - people of color, people with disabilities, LGBTQ community, and/or gender expansive, first and second-generation immigrants, veterans, and people from different socioeconomic backgrounds - to apply.
The Senior Data Engineer will help MGB Digital establish a data foundation for a suite of new analytic products that will be used across all PHSO domains. A solid data foundation will provide the backbone to enable data consistency and growth potential for these new products. This senior data engineer will help achieve this objective by delivering the underlying data assets and pipelines for the data foundation.
Job Summary
The Opportunity
The Payer Data Integration team performs data and content management for the Payer source mart within the Enterprise Data Warehouse (EDW). The primary content in the Payer source mart is information about Mass General Brigham (MGB) patients that have primary care relationship with an MGB Provider. Health plans deliver monthly updates containing changes in patient demographics, enrollment status in the health plan's products, and associated medical and pharmacy claims.
The Payer Data Integration team executes a suite of ETL/ELT jobs to perform data ingestion and staging data in the EDW.
The team then executes extensive QC activities to evaluate and certify incoming data before promoting updates to Production. The Population Health Service Organization (PHSO) is the primary stakeholder for the Payer source mart and provides direction and prioritization for new and revised functionality. The Payer source mart is a critical data source for other EDW databases, enterprise reporting, program development, and general analytics performed by PHSO and other business organizations across MGB. The Payer Data Integration team employs high standards and best practices to deliver timely, quality content updates to support the needs of these consumers.
The Payer Data Integration team leverages an Agile development methodology and is composed of two scrum teams. PHSO Team 1 supports the development and implementation of major PHSO business initiatives. The team develops and revises new EDW data assets and works with PHSO Team 2 for product installation and support. PHSO Team 2 is responsible for the monthly operation and general maintenance of the Payer source mart and other PHSO data assets and products.
The Senior Data Engineer is 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.
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
Knowledge, Skills and Abilities
- Working knowledge of cloud computing platforms such as AWS, Google Cloud Platform, or Azure.
- Experience with enterprise database solutions in cloud or on-premise environments Adherence to sound engineering principles and practices when designing technical solutions.
Additional Job Details (if applicable)
Remote Type
Remote
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. By embracing diverse skills, perspectives and ideas, we choose to lead. 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.
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.
At Mass General Brigham, we know it takes a surprising range of talented professionals to advance our mission-from doctors, nurses, business people and tech experts, to dedicated researchers and systems analysts. As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community. We place great value on being a diverse, equitable and inclusive organization as we aim to reflect the diversity of the patients we serve.
At Mass General Brigham, we believe a diverse set of backgrounds and lived experiences makes us stronger by challenging our assumptions with new perspectives that can drive revolutionary discoveries in medical innovations in research and patient care. Therefore, we invite and welcome applicants from traditionally underrepresented groups in healthcare - people of color, people with disabilities, LGBTQ community, and/or gender expansive, first and second-generation immigrants, veterans, and people from different socioeconomic backgrounds - to apply.
The Senior Data Engineer will help MGB Digital establish a data foundation for a suite of new analytic products that will be used across all PHSO domains. A solid data foundation will provide the backbone to enable data consistency and growth potential for these new products. This senior data engineer will help achieve this objective by delivering the underlying data assets and pipelines for the data foundation.
Job Summary
The Opportunity
The Payer Data Integration team performs data and content management for the Payer source mart within the Enterprise Data Warehouse (EDW). The primary content in the Payer source mart is information about Mass General Brigham (MGB) patients that have primary care relationship with an MGB Provider. Health plans deliver monthly updates containing changes in patient demographics, enrollment status in the health plan's products, and associated medical and pharmacy claims.
The Payer Data Integration team executes a suite of ETL/ELT jobs to perform data ingestion and staging data in the EDW.
The team then executes extensive QC activities to evaluate and certify incoming data before promoting updates to Production. The Population Health Service Organization (PHSO) is the primary stakeholder for the Payer source mart and provides direction and prioritization for new and revised functionality. The Payer source mart is a critical data source for other EDW databases, enterprise reporting, program development, and general analytics performed by PHSO and other business organizations across MGB. The Payer Data Integration team employs high standards and best practices to deliver timely, quality content updates to support the needs of these consumers.
The Payer Data Integration team leverages an Agile development methodology and is composed of two scrum teams. PHSO Team 1 supports the development and implementation of major PHSO business initiatives. The team develops and revises new EDW data assets and works with PHSO Team 2 for product installation and support. PHSO Team 2 is responsible for the monthly operation and general maintenance of the Payer source mart and other PHSO data assets and products.
The Senior Data Engineer is 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.
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
- Bachelor's Degree Related Field of Study required
- We can consider and review experience in lieu of a degree
- Experience in data engineering, with a focus on building and maintaining data infrastructure and pipelines
- 5-7 years required and Data warehousing development in large reporting environments
- 3-5 years required and Experience working with developing data pipelines using on Snowflake features ( Snowpipe, SnowSQL, Snow Sight, Data Streams ) required and Hands-on development experience with ETL/ELT tools, such as dbt, Fivetran, or Informatic required and Experience working in Agile software development environment required
Knowledge, Skills and Abilities
- Working knowledge of cloud computing platforms such as AWS, Google Cloud Platform, or Azure.
- Experience with enterprise database solutions in cloud or on-premise environments Adherence to sound engineering principles and practices when designing technical solutions.
Additional Job Details (if applicable)
- M-F Eastern Business hours required Hybrid Onsite Flexible working model required for weekly onsite work at Assembly Row/ Local MGB sites
- Business needs and team needs determine in office work
- Remote working days require stable, secure, quiet, compliant work area
Remote Type
Remote
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. By embracing diverse skills, perspectives and ideas, we choose to lead. 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.
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.