Position Purpose: Designs, develops, and implements complex enterprise software solutions. Collaborates closely with technical and non-technical roles such as data modelers, architects, business analysts, data stewards, and subject matter experts (SMEs) to provide design, technical analysis, development/configuration, testing, implementation, and support expertise representing the interest of the business across the enterprise.
- Create, optimize, and re-engineer Microsoft SQL Server (T-SQL) stored procedures, functions, views, and tables that stage and transform claim, authorization, member, and provider data for correspondence.
- Own, maintain, and enhance the in-house letter application, which stages data in SQL Server, uses C# to produce Word documents, and uses a third-party component within SSIS to convert Word documents to PDF.
- Develop and support SSIS packages for ETL, file processing, and document conversion workflows.
- Schedule, monitor, and troubleshoot jobs using ActiveBatch. Perform data analysis, testing, and production support; research and resolve data, performance, and letter-generation issues.
- Create and maintain technical documentation, including designs, data flows, and support procedures.
- Clearly articulate issues to business and technical stakeholders and design/model solutions.
- Contribute as needed to data mart development, EDI X12 processes, Enterprise Data Warehouse (EDW) feeds, and report development.
- Performs other duties as assigned
- Complies with all policies and standards
Education/Experience: A Bachelor's degree in a quantitative or business field (e.g., statistics, mathematics, engineering, computer science) and Requires 4 - 6 years of related experience.
Or equivalent experience acquired through accomplishments of applicable knowledge, duties, scope and skill reflective of the level of this position.
Technical Skills:One or more of the following skills are desired.
- Requires 4 - 6 years of Microsoft SQL Server development (T-SQL, stored procedures, query optimization, index creation, performance tuning, etc.)
- Requires 3+ years of C# development
- Requires 3+ years of SSIS development
- Experience with EDI preferred
- Experience with Healthcare/Managed Care Data is preferred
License/Certification:- Scaled Agile Framework (SAFe) preferred
Pay Range: $87,000.00 - $161,300.00 per year
At Centene, we connect people to the care they need to live healthier lives - and the work you do here makes that impact real every day. You'll take on meaningful challenges that directly support individuals, families, and communities, building your skills while making healthcare more accessible and effective. It's work with a purpose you can see, backed by a team committed to improving lives well beyond the workday.
Centene offers a comprehensive benefits package including: competitive pay, health insurance, 401K and stock purchase plans, tuition reimbursement, paid time off plus holidays, and a flexible approach to work with remote, hybrid, field or office work schedules. Actual pay will be adjusted based on an individual's skills, experience, education, and other job-related factors permitted by law, including full-time or part-time status. Total compensation may also include additional forms of incentives. Benefits may be subject to program eligibility.
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.
Qualified applicants with arrest or conviction records will be considered in accordance with the LA County Ordinance and the California Fair Chance Act
