Systems Analyst Advisor - Commercial Reinsurance

About the role

The System Analyst Advisor is responsible for leading the end-to-end Commercial Reinsurance data and CMS submission process for Elevance Health. This 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.

Responsibilities

• Lead the end-to-end Commercial Reinsurance data and CMS submission process, ensuring timely, accurate, and compliant submissions.
• Evaluate and redesign 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.
• Analyze business and system changes, assess impacts to the Reinsurance process, and implement effective technical 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.
• Migrate 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.

Requirements

• Requires a BA/BS degree in Information Technology, Computer Science or related field of study 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, which would provide an equivalent background.
• Claims processing, claims data analysis, or healthcare claims experience is highly preferred.
• Experience supporting Commercial Reinsurance or CMS Reinsurance programs.
• 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.

Preferred Skills, Capabilities, And Experiences

• 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.

Benefits

For candidates working in person or virtually in the below locations, the salary* range for this specific position is $101,120 to $151,680. Location(s): Richmond, Roanoke, VA. In addition to your salary, Elevance Health offers a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements).