Senior ETL Developer

Site: Mass General Brigham Health Plan Holding Company Inc.

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

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

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

Education

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

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 require stable secure quiet and compliant workspace

Hybrid

399 Revolution Drive

40

Regular

Day (United States of America)

Pay Range

$93953.60 - $136739.20/Annual

Grade

7

At Mass General Brigham we believe in recognizing and rewarding the unique value each team member brings to our organization. Our approach to determining base pay is comprehensive and any offer extended will take into account your skills relevant experience if applicable education certifications and other essential factors. The base pay information provided offers an estimate based on the minimum job qualifications; however it does not encompass all elements contributing to your total compensation addition to competitive base pay we offer comprehensive benefits career advancement opportunities differentials premiums and bonuses as applicable and recognition programs designed to celebrate your contributions and support your professional growth. We invite you to apply and our Talent Acquisition team will provide an overview of your potential compensation and benefits package.

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

Mass General Brigham Competency Framework