Fallon Technology Jobs

mobile fallon logo

Job Information

Fallon Health ETL Developer II in Worcester, Massachusetts


About Fallon Health

Founded in 1977, Fallon Health is a leading health care services organization that supports the diverse and changing needs of those we serve. In addition to offering innovative health insurance solutions and a variety of Medicaid and Medicare products, we excel in creating unique health care programs and services that provide coordinated, integrated care for seniors and individuals with complex health needs. Fallon has consistently ranked among the nation’s top health plans, and is accredited by the National Committee for Quality Assurance for its HMO, Medicare Advantage and Medicaid products. For more information, visit fallonhealth.org.

Brief summary of purpose:

Responsible for designing, developing, testing, delivering and maintaining data warehouse and ETL solutions based on business requirements, making use of existing technical capabilities and services in the organization. Align new solutions to the current architectural principles regarding standards and integration in the organization. Work collaboratively within and across development and project teams in a fast-paced environment.

Specialty area:

  • Build and maintain modular ETL applications which enables the flow of data between data sources

  • Develop database schemas, database procedures and functions, ETL, data loads and data extracts



  • Participates in activities of development lifecycle including estimation, coding, unit testing, deployment and maintenance.

  • Design and develop applications to established practice, standards and specifications.

  • Works collaboratively with a level III developer to design, develop and deliver an entire application (i.e. interface, ETL, extract, web site, service, console app, BI app).

  • Works more or less independently.

  • Participates in estimation


  • Defines and executes manual test cases which test all aspects of the component under development

  • Increases use of automating testing, developing automated tests for components of an application

  • Analyzes specifications and designs, develops, and tests high quality solutions in support of defined business objectives.

Issue Resolution/ Business Process Improvement:

  • Ensures accuracy and integrity of data and applications through analysis, coding, profiling and problem resolution

  • Troubleshoots application programs and provides timely response; performance-tunes these applications as necessary

  • Identifies problems and seeks assistance with solution implementation


  • Provides technical knowledge and subject matter expertise as required

  • Adheres to detailed deployment plans, schedules, timelines and milestones



  • Bachelor’s degree in Computer Science or equivalent

License/Certification : N/A


  • 3+ years data warehouse development

  • 3+ years SQL/T-SQL

  • 2+ years SSIS

  • Payer/ health care experience required

  • Hands on experience with Azure DevOps preferred.

  • Knowledge and experience with Healthcare technology like FHIR, API is a plus.


Location US-MA-Worcester

Posted Date 3 weeks ago (11/12/2021 5:19 PM)

Job ID 6605

# Positions 1

Category Information Technology