Principal Actuarial Data Systems Analyst

Blue Cross and Blue Shield of North Carolina•Remote Flex - North Carolina, IN

4d•$118,691 - $189,906•Hybrid

About The Position

The Principal Actuarial Data Systems Analyst delivers technical data support and innovative solutions for actuarial financial data systems and data marts. The role partners with actuaries, finance, medical economics, and data teams to analyze claims experience, medical cost trends, utilization patterns, IBNR reserving inputs, and predictive models that support business and actuarial decision-making. The analyst leads and coordinates development work and owns the full development lifecycle for complex decision-support data solutions, extracts, reports, data marts, and analyses. Working closely with healthcare actuarial reserving teams, the role develops insights across the claims lifecycle and maintains datasets for IBNR calculations, completion factors, lag analyses, actuarial modeling, reserve analyses, financial forecasts, and experience studies. The role also maintains and optimizes actuarial systems data marts; assesses and reconciles data quality across claims, membership, financial, and other systems; and supports monthly and quarterly reporting, forecasts, audits, and corporate projects. As a lead for multiple application areas, the analyst provides expertise on data definitions, file and technical structures, code, business rules, and system requirements. The position independently analyzes business challenges, develops and implements recommendations, communicates outcomes and business impacts, and provides direction, assistance, and training to peers and junior staff. Detailed configuration expertise and communication with customers and business partners, including presentations when needed, are also part of the role.

Requirements

Bachelor's degree or advanced degree where required; in lieu of a degree, 10+ years of experience in a related field.
8+ years of experience in related fields.
Employment authorization sponsorship is not available for this position.

Nice To Haves

5+ years of SQL development or analysis experience (highly preferred).
5+ years of healthcare analytics, actuarial analytics, payer analytics, or strong medical claims data functional or lifecycle knowledge (highly preferred).
Facets experience.
Experience supporting actuarial trend analysis.
Experience with Snowflake and AWS cloud environments.

Responsibilities

Lead and coordinate development work to deliver solutions that support business functions and accurate financial data implementation.
Develop complex decision-support data solutions, extracts, reports, data marts, and analyses, and manage the entire development lifecycle.
Partner with actuarial reserving teams to develop insights across the claims lifecycle, from service occurrence and claim submission through adjudication, payment, runout, and reserve development.
Develop and maintain datasets supporting IBNR reserve calculations, completion factors, lag analyses, and actuarial modeling.
Support monthly and quarterly reserve analyses, financial forecasts, and experience studies with healthcare actuarial reserving teams.
Perform data quality assessments and reconcile claims, membership, and financial data across multiple systems.
Analyze medical and pharmacy claims data to identify utilization trends, cost drivers, emerging risks, and opportunities for operational improvement.
Perform monthly data refreshes, validations, automations, and quality assurance checks for executive financial reporting.
Maintain and optimize actuarial systems data marts.
Lead multiple application areas, including their data definitions, usage, file structures, technical code structures, business rules, and requirements governing system functionality.
Independently analyze business challenges or opportunities, develop and implement recommendations and solutions, and communicate actions, business impacts, and results.
Ensure granular financial data is auditable, snapshotted, and stored for quarterly and year-end audits.
Provide analytical support for departmental, divisional, and corporate projects to help meet business goals and needs.
Coordinate work and provide direction, assistance, and training to peers and junior staff members.
Provide detailed configuration expertise to customers and business partners through verbal, written, and electronic communication, including presentations when needed.