Actuarial Data & Analytics Analyst III

Imperial Health Plan of California, Inc.; Pasadena (CA); On-site; USD 95,000 - 135,000; Full time

Job summary

Imperial Health Plan of California, Inc. is hiring an Actuarial Analyst III to work with the lead actuary on data-driven tasks and reporting projects.

The role focuses on relational databases, process automation, and timely delivery of analyses for the actuarial and finance teams. The candidate will automate processes using SQL, Power BI and Excel, maintain data accuracy, and document methodologies while collaborating with management and external vendors.

Qualifications

• Bachelor's degree in actuarial science or related field.
• Experience with SQL, Power BI and Excel required.
• Actively pursuing SOA exams; at least four exams completed or in progress.

Responsibilities

• Support analysis for the actuarial department and finance teams.
• Engage with outside vendors for pricing, risk score initiatives, and quality measures.
• Produce periodic utilization and cost reporting.
• Support revenue cycle activities.
• Create dashboards and consolidate data management.
• Automate processes using SQL, Power BI and Excel.
• Ensure data accuracy, documentation of methodologies, and project communications.

Skills

SQL

Power BI

Excel

Data analysis

Process automation

Documentation

Communication

Confidentiality

Education

Bachelor’s degree in Actuarial Science, Mathematics, Statistics, Economics, or related field

Actively pursuing SOA exams

4+ actuarial exams completed/ongoing

Tools

SQL

Power BI

Excel

Job description

Imperial Health Plan of California, Inc. is hiring an Actuarial Analyst III to work with the lead actuary on data-driven tasks and reporting projects.

The role focuses on relational databases, process automation, and timely delivery of analyses for the actuarial and finance teams. The candidate will automate processes using SQL, Power BI and Excel, maintain data accuracy, and document methodologies while collaborating with management and external vendors.