Health Actuarial Data Analyst: Insights & Modeling

Lockton; Plano (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

Lockton in Plano, TX is seeking an Actuarial/Data Analyst to develop models and analyze health care data, focusing on cost transparency, utilization, and population health trends. The role builds expertise in data sources, methodologies, and tools, translating findings into actionable insights for actuarial consultants and client teams.

You will extract and manage large datasets, collaborate with actuaries and vendor partners, and translate results for internal stakeholders and external clients.

Qualifications

• Bachelor’s degree in a quantitative field such as Actuarial Science, Mathematics, Statistics, Data Science, or Health Informatics.
• Minimum of three years of data analytics experience in the health insurance industry.
• Advanced knowledge of Microsoft Office applications, particularly Excel, Word, and PowerPoint.
• Proficiency in SQL for data extraction and manipulation; experience with statistical software or programming languages such as R or Python is preferred.
• Experience with data visualization tools such as Power BI or Tableau.

Responsibilities

• Data Extraction and Management: Extract, validate, and manage large, complex datasets from internal and external sources for use in analyses.
• Health Care Cost Transparency: Analyze health care cost transparency data and support related tools; develop expertise in the data and methodologies.
• Book-of-Business Analysis: Analyze health plan performance across the book of business, identifying trends in costs and utilization.
• Analytical Insights: Interpret data and model results to identify meaningful patterns and develop actionable insights.
• Stakeholder Collaboration: Partner with actuarial consultants and client-facing teams to understand needs and communicate findings.
• Analytical Communication: Summarize methodologies, findings, and implications through reports and dashboards.
• Quality Assurance: Ensure the accuracy, validity, and integrity of data outputs.
• Process Improvement: Identify opportunities to automate reporting and improve data processes.
• Predictive Modeling: Develop models for emerging business needs and client-specific applications.

Skills

Data analytics

SQL proficiency

Analytical skills

Communication

Collaboration

Initiative

Decision-making

Education

Bachelor’s degree

Tools

Power BI

Tableau

Python

R

Job description

Lockton in Plano, TX is seeking an Actuarial/Data Analyst to develop models and analyze health care data, focusing on cost transparency, utilization, and population health trends. The role builds expertise in data sources, methodologies, and tools, translating findings into actionable insights for actuarial consultants and client teams.

You will extract and manage large datasets, collaborate with actuaries and vendor partners, and translate results for internal stakeholders and external clients.