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.
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
COMPANY: Information Technology
POSITION TYPE: Professional