Centene Corporation Project Lead ETL Developer in St. Louis, Missouri


This position is responsible for the design, build, development and testing of the ETL for the compliance reporting solutions. The Project Lead Application Software Engineer - ETL - Compliance Reporting will lead the ETL development activities of the compliance reporting team. The IT compliance reporting team is responsible for the delivery of Medicaid, Medicare, MMP and Marketplace specific federal and state CMS compliance reports and data extracts. Strong partnership skills are critical in this role as the delivery of these reports is done in partnership with other business and application teams. These reports are requested by compliance leaders at health plans, corporate compliance, and regulatory operations and are required for submission to state & federal CMS agencies. The compliance reporting suite encompasses reports across Claims, Prior Authorizations, Provider, Member, Appeals & Grievances (A&G), Cost Avoidance & Recovery, Call Center & Medical Management, Coverage determination A&G, Organization determinations A&G & Special needs Plan – Model of care.

Key Functions and Responsibilities:

  • Responsible for the entire implementation process and drive definition of business needs

  • Lead cross functional teams through the entire implementation process

  • Responsible for overall solution design including building and testing

  • Conduct root cause analysis and advanced performance tuning for complex business processes and functionality

  • Identify, define and implement needed enhancements in the methods, standards and processes to better enable teams and constructive enterprise applications

Education/Experience: Bachelor's Degree in Public Health, Computer Science, MIS Medical Informatics, Business, Finance or related field or equivalent experience. 5+ years of related experience. Business solutions experience with high complexity, multiple large application business processes. Experience in project management and partnering with technology development staff.

Preferred Experience:

  • Expert Level skills in SQL, Informatica (Power Exchange and/or Power Center, BDM) or similar ETL tools, Teradata or other relational database systems (RDBMS) & Unix.

  • Experience/exposure developing ETL workflows for Health care solutions like Claims, Prior Authorizations, Provider, Member, Appeals & Grievances, Cost Avoidance & Recovery, Call Center & Medical Management, Coverage determination A&G, Organization determinations A&G, Special needs Plan – Model of care

  • Experience/exposure to facilitating business process design as it relates to State or Federal CMS reporting

  • Ability to present project solutions to clients, manage client expectations, and work with implementation team to deliver solutions

  • Heavy Project Management experience

  • Background in SDLC

  • Experienced working with AGILE methodologies, utilizing JIRA

  • World class interpersonal verbal & written communication skills

  • Strong background in a customer interfacing role

  • Ability to work collaboratively with both internal and partners in defining sustainable customer solutions

  • High standard for solution and process quality

Centene is an equal opportunity employer that is committed to diversity, and values the ways in which we are different. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or other characteristic protected by applicable law.

TITLE: Project Lead ETL Developer

LOCATION: St. Louis, Missouri

REQNUMBER: 1102725

COMPANY: Information Technology

POSITION TYPE: Professional