Systems Analyst Advisor - Commercial Reinsurance

Position Title

Systems Analyst Advisor - Commercial Reinsurance

Hybrid:
Requires in-office 1–2 days per week. Alternate locations may be considered. Candidates not within a reasonable commuting distance will not be considered unless an accommodation is granted as required by law.

The System Analyst Advisor is responsible for leading the end‑to‑end Commercial Reinsurance data and CMS submission process for Elevance Health. The role oversees the analysis, design, implementation, and continuous improvement of the Reinsurance reporting workflow—from identifying eligible claims through final CMS submissions and audit support. The successful candidate will evaluate and redesign existing business processes, develop automated end‑to‑end solutions, and improve the efficiency, accuracy, and scalability of the Reinsurance program.

This position also supports the migration of legacy SQL and SAS processes to Snowflake and other cloud‑based technologies.

• Lead the end‑to‑end Commercial Reinsurance data and CMS submission process, ensuring timely, accurate, and compliant submissions.
• Evaluate, redesign, and optimize existing Reinsurance workflows to improve efficiency, scalability, automation, and data quality.
• Design and implement automated end‑to‑end processes that reduce manual effort and improve operational performance.
• Identify claims eligible for Commercial Reinsurance by analyzing claims, membership, and other enterprise data sources.
• Work across multiple data sources—including claims systems, operational applications, enterprise databases, and data warehouses—to support business and regulatory requirements.
• Develop, maintain, and optimize complex SQL and SAS programs for data extraction, validation, reconciliation, and regulatory reporting.
• Perform deep‑dive analysis to investigate data discrepancies, identify root causes, and recommend sustainable solutions.
• Support CMS submissions, CMS inquiries, and federal audits through comprehensive data analysis and documentation.
• Support User Acceptance Testing (UAT) for enhancements, production releases, and projects impacting Reinsurance submissions.
• Analyze business and system changes, assess impacts to the Reinsurance process, and implement effective technical solutions.
• Support migration of legacy SQL and SAS processes to Snowflake and other modern cloud‑based technologies.
• Collaborate with business partners, IT, and external stakeholders while independently leading analytical efforts and recommending technical solutions.
• Continuously identify opportunities to automate, modernize, and improve business processes and data workflows.
• Document business processes, technical designs, data flows, and operational procedures.

• BA/BS degree in Information Technology, Computer Science, or related field and a minimum of 6 years experience in a variety of technologies, documenting requirements and/or building test cases; or any combination of education and experience that provides equivalent background.

• Experience supporting Commercial Reinsurance or CMS Reinsurance programs.
• Claims processing, claims data analysis, or healthcare claims experience is highly preferred.
• Experience identifying claims eligible for CMS regulatory programs.
• Experience supporting CMS submissions, CMS inquiries, and federal audits.
• Experience with Snowflake and cloud‑based data warehouse technologies.
• Experience migrating SQL, SAS, or ETL processes to Snowflake, Python, Spark/Snowpark, or similar cloud platforms.
• Experience with Microsoft SQL Server.
• Experience with enterprise data warehouses, ETL processes, data governance, and data quality best practices.
• Experience leading process improvement, workflow redesign, and automation initiatives.

For candidates working in person or virtually in the below locations, the salary range for this position is $101,120 to $151,680.

Richmond, Roanok