Benefit Administrative Systems, LLC
  • Mokena, IL, USA
  • Salary
  • Full Time

Medical, Dental, Vision, 401(k), Life, Optional Life, AD &D, STD, LTC, LTD, Wellness, Vacation, PTO, Holiday,

HealthComp is one of the top 5 national independent third party administrators (TPAs) in the country. Serving over 360,000 members, we are private-equity backed, investing heavily in the business and growing much faster than the industry. Benefit Administrative Systems (BAS) is an operating division within HealthComp Holdings. Along with medical, dental, vision, COBRA and HIPAA administration, we also provide integrated solutions for flexible benefit plans and health and wellness management. We have a proven track record managing health care costs and delivering an unparalleled member experience. In addition, our in-house operations provide superior flexibility, customization and data access.

We are expanding our team and seek a SQL/ETL Developer. The position this position will responsible for writing and editing complex data extracts while ensuring their stability, reliability, and performance. Reporting to the Data Team Manager and working with the data team to accomplish business needs relating to all aspects of data availability/delivery. Working with both internal business users and external vendors the SQL/ETL Developer will manage multiple projects while communicating expectations with all stakeholders.

  • Develop and code SQL stored procedures and SSISETL packages utilizing our onsite data warehouse and other appropriate data sources that meet provided specifications
  • Meet with internal and external users as a SME for data related projects and requests
  • Collaborate with technical and business users to develop and maintain enterprise wide solutions and standards
  • Provide business users the data required for metrics and analysis
  • Work with members of the reporting team to provide required access/structure to data
  • Troubleshoot existing complex SSIS packages when failures occur
  • Maintain and enhance the existing data warehouse and extracts
  • Perform quality checks on reports and extracts to ensure exceptional quality
  • Build relationships with business intelligence partners to understand data needs in order to execute with excellence on documented user requirements
  • Educate and advise internal customers on how to leverage available data for consumption
  • Create and maintain documentation for all projects



Bachelor's Degree in Computer Science

5 years of experience in SQL development


10 years of experience developing in dynamic SQL databases with 5 years of health insurance/dataset experience


Benefit Administrative Systems, LLC
  • Apply Now

    with our quick 3 minute Application!

  • * Fields Are Required

    What is your full name?

    How can we contact you?

  • Sign Up For Job Alerts!

  • Share This Page
  • Facebook Twitter LinkedIn Email
News Company Profile About Us Contact Us Portal Login FB Twitter Linkedin Logo Home Members Employers Producers Providers Services