Senior ETL Developer
Mass General Brigham, Somerville, MA, United States
Job Summary
Mass General Brigham Health Plan is an exciting place to be within the healthcare industry. As a member of Mass General Brigham, we are at the forefront of transformation with one of the world’s leading integrated healthcare systems. Together, we are providing our members with innovative solutions centered on their health needs to expand access to seamless and affordable care and coverage. Our work centers on creating an exceptional member experience – a commitment that starts with our employees. Working with some of the most accomplished professionals in healthcare today, our employees have opportunities to learn and contribute expertise within a welcoming and supportive environment that embraces their unique and varied backgrounds, experiences, and skills. We are pleased to offer competitive salaries and a benefits package with flexible work options, career growth opportunities, and much more.
Primary Responsibilities
The ETL Developer must have software development experience and should be able to follow design principles and coding/best practices for development. Should be able to work in cross functional project teams and follow SDLC processes. A good hands on experience with development tools such as Visual Studio, C#.NET, Microsoft SQL Server 2008R2, T‑SQL and SSIS are essential for this role. Primary Responsibilities include writing T‑SQL in SQL Server and SSIS packages, which support the Vendor Interfaces. Analyze business and system requirements, including impact analysis on existing systems, to develop systems specifications. In partnership with the business units, design, prepare and execute unit test plans for application upgrades and enhancements. Perform analysis on systems and processes to become a subject matter expert, in order to help and support the business units. Data analysis entails understanding the flow of data and its interdependency among QNXT core modules such as Member – Enrollment and Services, Claims Processing, Provider Relations, Clinical Systems and Finance.
Essential Functions
Lead the design, deployment, and optimization of enterprise platforms and services.
Define and implement advanced automation and orchestration solutions.
Design and manage complex platforms in hybrid and multi‑cloud environments.
Perform advanced troubleshooting and root cause analysis for critical platform issues.
Design and implement system monitoring and observability solutions.
Lead platform performance tuning and capacity planning efforts.
Develop technical standards, operational procedures, and leading practices.
Mentor junior engineers and provide technical guidance to project teams.
Qualifications
Education
Bachelor's Degree required; experience can be considered in lieu of a degree.
Experience
At least 5‑7 years of experience as a systems engineer or related position required.
Knowledge, Skills, And Abilities
Deep expertise in enterprise platform design, implementation, and optimization.
Advanced automation and orchestration capabilities using tools like Ansible, Terraform, or similar.
Proficient knowledge of cloud‑native architectures and services.
Ability to conduct root cause analysis and performance tuning at the system and application levels.
Proficient in designing and implementing high‑availability and disaster recovery solutions.
Familiarity with observability frameworks and modern monitoring/alerting platforms.
Proven experience in developing system architecture documentation and operational runbooks.
Ability to mentor junior engineers and lead cross‑functional technical initiatives.
Additional Job Details
Working Conditions
While this position is designated as remote, all employees, including those classified as remote, may be required to attend meetings, trainings, or other necessary functions onsite at a Mass General Brigham location on an as‑needed basis. Reasonable notice will be provided for any required in‑person attendance.
M‑F Eastern Business Hours required.
Flexibility for business needs to be onsite needed.
Remote work requires stable, secure, quiet, and compliant workspace.
Remote Type
Hybrid
Work Location
399 Revolution Drive
Scheduled Weekly Hours
40
Employee Type
Regular
Work Shift
Day (United States of America)
Pay Range
$93,953.60 - $136,739.20/Annual
Grade
7
EEO Statement
8925 Mass General Brigham Health Plan Holding Company, Inc. 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.
#J-18808-Ljbffr
Mass General Brigham Health Plan is an exciting place to be within the healthcare industry. As a member of Mass General Brigham, we are at the forefront of transformation with one of the world’s leading integrated healthcare systems. Together, we are providing our members with innovative solutions centered on their health needs to expand access to seamless and affordable care and coverage. Our work centers on creating an exceptional member experience – a commitment that starts with our employees. Working with some of the most accomplished professionals in healthcare today, our employees have opportunities to learn and contribute expertise within a welcoming and supportive environment that embraces their unique and varied backgrounds, experiences, and skills. We are pleased to offer competitive salaries and a benefits package with flexible work options, career growth opportunities, and much more.
Primary Responsibilities
The ETL Developer must have software development experience and should be able to follow design principles and coding/best practices for development. Should be able to work in cross functional project teams and follow SDLC processes. A good hands on experience with development tools such as Visual Studio, C#.NET, Microsoft SQL Server 2008R2, T‑SQL and SSIS are essential for this role. Primary Responsibilities include writing T‑SQL in SQL Server and SSIS packages, which support the Vendor Interfaces. Analyze business and system requirements, including impact analysis on existing systems, to develop systems specifications. In partnership with the business units, design, prepare and execute unit test plans for application upgrades and enhancements. Perform analysis on systems and processes to become a subject matter expert, in order to help and support the business units. Data analysis entails understanding the flow of data and its interdependency among QNXT core modules such as Member – Enrollment and Services, Claims Processing, Provider Relations, Clinical Systems and Finance.
Essential Functions
Lead the design, deployment, and optimization of enterprise platforms and services.
Define and implement advanced automation and orchestration solutions.
Design and manage complex platforms in hybrid and multi‑cloud environments.
Perform advanced troubleshooting and root cause analysis for critical platform issues.
Design and implement system monitoring and observability solutions.
Lead platform performance tuning and capacity planning efforts.
Develop technical standards, operational procedures, and leading practices.
Mentor junior engineers and provide technical guidance to project teams.
Qualifications
Education
Bachelor's Degree required; experience can be considered in lieu of a degree.
Experience
At least 5‑7 years of experience as a systems engineer or related position required.
Knowledge, Skills, And Abilities
Deep expertise in enterprise platform design, implementation, and optimization.
Advanced automation and orchestration capabilities using tools like Ansible, Terraform, or similar.
Proficient knowledge of cloud‑native architectures and services.
Ability to conduct root cause analysis and performance tuning at the system and application levels.
Proficient in designing and implementing high‑availability and disaster recovery solutions.
Familiarity with observability frameworks and modern monitoring/alerting platforms.
Proven experience in developing system architecture documentation and operational runbooks.
Ability to mentor junior engineers and lead cross‑functional technical initiatives.
Additional Job Details
Working Conditions
While this position is designated as remote, all employees, including those classified as remote, may be required to attend meetings, trainings, or other necessary functions onsite at a Mass General Brigham location on an as‑needed basis. Reasonable notice will be provided for any required in‑person attendance.
M‑F Eastern Business Hours required.
Flexibility for business needs to be onsite needed.
Remote work requires stable, secure, quiet, and compliant workspace.
Remote Type
Hybrid
Work Location
399 Revolution Drive
Scheduled Weekly Hours
40
Employee Type
Regular
Work Shift
Day (United States of America)
Pay Range
$93,953.60 - $136,739.20/Annual
Grade
7
EEO Statement
8925 Mass General Brigham Health Plan Holding Company, Inc. 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.
#J-18808-Ljbffr