Actuarial Data Analytics Engineer

W. R. Berkley; San Diego (CA); On-site; USD 117,000 - 139,000; Full time

Benefits offered by this job

Health insurance

Dental

Vision

Life insurance

Disability insurance

Wellness program

Paid time off

401(k)

Profit sharing

Job summary

Preferred Employers Insurance, a Berkley Company, is seeking a Data Analytics Engineer to support the Actuarial department's data, reporting, and analytical infrastructure. This role will own and enhance the actuarial sandbox datamart, data quality processes, reporting platforms, and analytical datasets that support actuarial, underwriting, claims, finance, and executive decision-making.

The Data Analytics Engineer will partner with business and technical teams to deliver scalable, reliable, and

Qualifications

• 3–5 years of experience in analytics engineering, data engineering, or BI.
• Experience with Power BI and semantic models.
• Experience building automated data pipelines.
• Knowledge of data quality, reconciliation, testing, and documentation.
• Strong communication across technical and non-technical audiences.

Responsibilities

• Own and enhance the actuarial sandbox datamart, including data architecture, permissions, documentation, and integration of new data sources.
• Serve as Actuarial department’s liaison for enterprise data platform initiatives, including requirements gathering, testing, issue resolution, implementation, and adoption.
• Lead data stewardship activities, including data validation, reconciliation, QA/QC, auditing, root-cause analysis, and remediation of data integrity issues.
• Automate data pipelines, reporting workflows, and repeatable analytical processes using SQL, Python, R, Power BI, Databricks, or comparable tools.
• Perform business analytics supporting underwriting, claims, finance, distribution, and product decisions.
• Partner with actuarial staff on predictive modeling, segmentation, KPI development, model monitoring, and implementation of analytical solutions.
• Translate business questions into clear data requirements, analytical approaches, and practical recommendations for technical and non-technical audiences.
• Coordinate day-to-day work and knowledge transfer from the department’s data engineering contractor, including documentation of systems and processes.
• Establish scalable standards for data development, version control, testing, documentation, deployment, and ongoing maintenance.
• Manage multiple recurring and ad hoc priorities while communicating status, risks, dependencies, and recommended actions.
• Proactively identify opportunities to improve data quality, reporting efficiency, analytical capability, and business decision support.
• Design, develop, and maintain curated analytical datasets, Power BI semantic models, dashboards, recurring reports, and monitoring tools that serve as trusted sources for operational, actuarial, and executive reporting.

Skills

SQL

Python

R

Power BI

Data pipelines

Analytics

Communication

Education

Bachelor’s degree

Quantitative field

Tools

Databricks

Job description

Preferred Employers Insurance, a Berkley Company, is seeking a Data Analytics Engineer to support the Actuarial department's data, reporting, and analytical infrastructure. This role will own and enhance the actuarial sandbox datamart, data quality processes, reporting platforms, and analytical datasets that support actuarial, underwriting, claims, finance, and executive decision-making.

The Data Analytics Engineer will partner with business and technical teams to deliver scalable, reliable, and