Job description

Preferred Employers Insurance, A Berkley Company specializes in providing workers’ compensation insurance to California business owners. The company serves three major Product/Client Segments: Small Business, Mid-Larger Businesses and Group Association Members (Programs). The company’s distribution partners (agents & brokers) number just under 400 locations throughout the state. Preferred serves thousands of policyholders and provides medical claims handling and claims management as needed to care for injured workers. The company is rated A+ Superior by industry-rating organization, AM Best & Company. Company URL: peiwc.com The company is an equal opportunity employer. Preferred Employers Insurance 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 well-governed data and analytical solutions while supporting advanced analytics and predictive modeling initiatives. Key functions include but are not limited to: • Own, maintain, and enhance the actuarial sandbox datamart, including data architecture, permissions, documentation, and integration of new data sources. • Serve as the Actuarial department’s primary 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 that support 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. This role is based in our San Diego, CA office and offers a hybrid work environment. • Bachelor’s degree in data science, computer science, statistics, mathematics, actuarial science, engineering, or a related quantitative field. • 3–5 years of relevant experience in analytics engineering, data engineering, business intelligence, or advanced analytics. • Property and casualty insurance or workers’ compensation experience is preferred. • Advanced proficiency in SQL and working proficiency in Python or R. • Experience building and maintaining automated data pipelines, analytical datasets, and reporting solutions. • Experience with Power BI, semantic models, dashboard development, and business intelligence solutions. • Demonstrated ability to lead analytics, reporting, automation, or data engineering projects. • Understanding of data quality, reconciliation, testing, and documentation practices. • Strong written and verbal communication skills with technical and non-technical audiences. • Ability to collaborate across departments and translate business needs into scalable data and analytical solutions. • Experience coordinating contractors, vendors, or technical workstreams is preferred. • Experience with Databricks, cloud data platforms, or comparable data environments. We do not accept any unsolicited resumes from external recruiting agencies or firms. The company offers a competitive compensation plan and robust benefits package for full time regular employees which for this role include: • Base Salary Range: $117,000 – $139,000 annually • Benefits: Health, Dental, Vision, Life, Disability, Wellness, Paid Time Off, 401(k) and Profit-Sharing plans. The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. Sponsorship not Offered for this Role Not ready to apply? Connect with us for general consideration.

Requirements

Must-haves

The company is an equal opportunity employer.
Key functions include but are not limited to:
Own, maintain, and enhance the actuarial sandbox datamart, including data architecture, permissions, documentation, and integration of new data sources.
Serve as the Actuarial department’s primary 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 that support 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.
Bachelor’s degree in data science, computer science, statistics, mathematics, actuarial science, engineering, or a related quantitative field.
3–5 years of relevant experience in analytics engineering, data engineering, business intelligence, or advanced analytics.
Advanced proficiency in SQL and working proficiency in Python or R.
Experience building and maintaining automated data pipelines, analytical datasets, and reporting solutions.
Experience with Power BI, semantic models, dashboard development, and business intelligence solutions.
Demonstrated ability to lead analytics, reporting, automation, or data engineering projects.
Understanding of data quality, reconciliation, testing, and documentation practices.
Strong written and verbal communication skills with technical and non-technical audiences.

Nice-to-haves

Property and casualty insurance or workers’ compensation experience is preferred.
Experience coordinating contractors, vendors, or technical workstreams is preferred.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpython

Platform: icims
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Paid Time Off

Wellness