Senior Business Technical Analyst

Centene Corporation • Remote-MO, NV

3d • $87,700 - $157,800

About The Position

Provides in-depth business knowledge and advanced technical support to one or more business areas through developed and ad hoc analysis and reporting, and by designing and programming complex processes and reports. Acts as a subject matter expert for department or business unit business systems and applications. The role translates Medicare Advantage and Medicaid Risk Adjustment business requirements into production-ready technical solutions, including support for Encounter Risk Adjustment Prioritization and Encounter Risk Adjustment Chart Process workflows. It analyzes company functions and processes to improve computer-based business applications and performs application and system design and implementation. The analyst documents development requirements and works with end users to test and debug applications. The ideal candidate brings advanced SQL, Snowflake, and Databricks knowledge, healthcare data integration experience, data quality and regulatory compliance experience, and the ability to create reusable documentation.

The position supports current SAS solutions and future Snowflake capabilities. It integrates complex healthcare datasets, modernizes legacy SAS ETL workflows, establishes validation and reconciliation frameworks, and creates reusable data assets and technical documentation. The role may also monitor departmental project status, address issues that could affect project goals, resolve complex technical issues, and guide and train staff. The position reports to no specified role in the posting.

Requirements

• Bachelor's degree in a related field, or equivalent work experience in technical data analysis, conducting system analysis meetings, developing system design documents, developing project plans with achievable milestones and deadlines, and mediating departmental demands to obtain approval of system scope and design.
• At least 4 years of experience in SQL.
• At least 4 years of experience in Snowflake.
• Knowledge of Databricks.
• Knowledge of SAS.

Nice To Haves

• Master's degree in a related field, such as Mathematics or Computer Science; may be considered in lieu of some required experience, not to exceed 2 years.
• At least 1 year of experience in healthcare.
• Experience modernizing SAS ETL workflows into Snowflake using Snowflake SQL, Snowpark Python, and automated pipeline orchestration.
• Experience with Medicare Advantage, Medicaid, Risk Adjustment, encounter submissions, claims, enrollment, provider, pharmacy, clinical, and vendor chart data.
• SnowPro Certification.
• SAS Certification.

Responsibilities

• Develop ad hoc reports to conduct data analysis and validation.
• Partner with business analysts, Risk Adjustment stakeholders, IT, and vendor teams to understand Medicare Advantage and Medicaid requirements, translate them into technical specifications, and support process improvements using SAS and future Snowflake capabilities.
• Conduct business analysis and recommend technical alternatives to management that best meet organizational goals.
• Analyze requirements, procedures, and data needs to automate processing, improve business systems, and support production-ready SAS code for Encounter Risk Adjustment Prioritization and Encounter Risk Adjustment Chart Process workflows, including future Snowflake migration support.
• Create robust, multi-user, real-time database solutions by integrating healthcare data such as claims, enrollment, provider, pharmacy, clinical records, and vendor chart data.
• Translate business requirements into system analysis, technical design, advanced SAS/SQL programming, Snowflake modernization, and application or system documentation.
• Modernize legacy SAS ETL workflows into scalable Snowflake architecture using Snowflake SQL, Snowpark Python, and pipeline orchestration concepts such as Tasks and Streams.
• Implement validation, reconciliation, and data quality frameworks that support CMS audit standards, state Medicaid requirements, and compliant Risk Adjustment encounter submissions.
• Build reusable SAS, SQL, and Snowflake data assets, modular code libraries, and technical documentation to reduce development time and support knowledge transfer across data and actuarial teams.
• Research and assess the financial impact of issues identified in data and processes.
• Analyze requirements, procedures, and problems to automate processing or improve existing business systems.
• Monitor and report departmental project status as assigned; anticipate and identify issues that could inhibit project goals and implement corrective actions and mitigation strategies.
• Provide oversight and resolve complex issues, optimize performance, resolve problems, and follow up on identified issues in a timely manner.
• Provide staff with guidance and training on processes, procedures, and issue resolution.
• Perform other duties as assigned and comply with all policies and standards.

Benefits

• Competitive pay
• Health insurance
• 401K plan
• Stock purchase plans
• Tuition reimbursement
• Paid time off
• Paid holidays
• Flexible approach to work with remote, hybrid, field, or office work schedules
• Additional forms of incentives may be included in total compensation, subject to applicable factors and eligibility.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior