Senior ETL Developer Job at Mass General Brigham, Somerville, NJ

cU92aWJKaVJaK0d6bDk3NzdKTHhYYm5hL3c9PQ==
  • Mass General Brigham
  • Somerville, NJ

Job Description

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.

Qualifications

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

Additional Job Details (if applicable)

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

Remote Type

Hybrid

Work Location

399 Revolution Drive

Scheduled Weekly Hours

40

Employee Type

Regular

Work Shift

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.

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

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.

Required Experience:

Senior IC

Job Tags

Full time, Work at office, Remote work, Flexible hours, Shift work

Similar Jobs

CITY & COUNTY CREDIT UNION

Consumer Loan Processor Job at CITY & COUNTY CREDIT UNION

 ...The Consumer Loan Processor is primarily responsible for processing a high volume of consumer loans, including home equity loans and...  ...completeness prior to sending documents to members or the branch for signing, processing, and funding the loan. Analyze consumer loan... 

Burk Agency

Licensed Insurance Agent - Work From Home Opportunity Job at Burk Agency

 ...We are expanding our agency and hiring licensed life insurance agents for a remote sales...  ...activity. Jan Burkhalter Insurance Broker National Recruiter No agents...  ...system, and the insurance needs of the customers in the geographic areas in which you choose... 

Hasbro

Senior UX/Product Designer (Contract/Temporary) - D&D Beyond Job at Hasbro

 ...traditional product design and UX for the games or entertainment industry. Additional Details: Please note that this is a temporary assignment providing services to Wizards through an external staffing agency. If you are selected for this assignment, you will be... 

My Simple Protection - AIL

Licensed Health Insurance Agent Job at My Simple Protection - AIL

 ...This is a 100% commission position. State of the Art training and customer-requested leads provided. Globe Life American Income...  ...subsidiary,Globe Life National Income Division ( in New York. Our licensed agents enjoy the benefit of working from home! Sales... 

Carter Lumber

Truss Designer Job at Carter Lumber

 ...A Carter Lumber Truss Designer is responsible for designing plans for the production of trusses and/or wall panels. Ensures drawings are produced accurately and timely based off of blueprints provided by customers. Requires the knowledge of commonly used concepts and...