Medical Cost Projection Analyst

Responsibilities

• Responsible for lifetime medical cost planning for injured workers on an accurate and timely basis.
• Participate in the improvement of the process surrounding the estimation of lifetime medical costs.
• Support the actuarial function with regards to data analysis of medical claims using database in programming tools.
• Create visually appealing and accurate deliverables, including self-service capabilities.
• Collaborate with key stakeholders to identify and develop business questions for analytic investigation and modeling.
• Utilize applicable data/analytical tools to extract and analyze data (e.g., R, SQL, Excel, Power BI).

Qualifications

• Proficiency and experience designing and running complex data programs, (e.g., extract and analyze data via R, SAS,SQL, Python, VBA).
• Experience with Microsoft Suite including Excel, Power BI or similar.
• 5+ years of experience in workers’ compensation.
• 5+ years of experience with health care claims data and analyses.
• Experience collaborating with cross functional teams.

Benefits

• Health and wellness– PPO, HDHP, and HMO health insurance options with Cigna and Kaiser (CA employees only).
• Financial incentives – Competitive salaries, 401(k) matching contributions, employer-paid life and disability insurance, flexible spending and commuter accounts, and employer-matched HSA contributions.
• Vacation – Paid time off and personal holiday programs.
• Volunteer time – One paid day per calendar year.
• Learning and development: LEAP program.

About the Role

We are seeking a full-time, remote Medical Cost Projection Analyst to support the Sr. Director of Risk Actuarial Services. This position is crucial for ensuring product profitability through the analysis of claims data and historical contract performance, and for supporting the creation of processes and tools utilized in these activities.