Mercury Insurance Services, LLC

Lead Data Analytics Engineer

Mercury Insurance Services, LLC
Apply
3 days ago
USA (city not specified)Staff+

Base Salary

$119k - $231k/yr

Responsibilities

  • Build and launch scalable production data pipelines, data models, enterprise metrics, and visualizations for use across departments and products.
  • Perform complex analytics and data preparation in collaboration with data science teams.
  • Solve data integration challenges using ETL patterns, frameworks, query techniques, and structured and unstructured data sources.
  • Own and optimize production processes and complex code using advanced algorithmic concepts.
  • Extract and manipulate data across Mercury’s data lakes, warehouses, cubes, and other sources.
  • Perform data housekeeping, cleansing, normalization, hashing, and required data model changes.
  • Analyze data to identify anomalies, trends, gaps, inconsistencies, and correlations.
  • Collaborate with analysts and data scientists to address complex data problems and identify opportunities for business growth.
  • Design, develop, and implement natural language processing software modules.
  • Communicate data plans and data models to internal clients and influence stakeholders across the organization.

Requirements

  • Bachelor’s degree in Computer Engineering, Computer Science, Mathematics, Electrical Engineering, Information Systems, or a related field, or an equivalent combination of education and experience.
  • At least 5 years of experience in data analytics, analytics engineering, data engineering, and/or data science.
  • At least 3 years of P&C insurance experience is preferred but not required.
  • Experience using SQL and Python to build data pipelines and perform analyses.
  • Experience with AWS, including S3 and EC2, and Unix/Shell scripting.
  • Experience with ETL/ELT tools such as dbt, Informatica, or Fivetran.
  • Experience with relational and non-relational databases and structured and unstructured data sources.
  • Preferred experience with enterprise metrics stores, semantic layers, governed KPI frameworks, dbt, prompt engineering, LLM-powered assistants, P&C insurance data, and orchestration tools such as Airflow, Dagster, Prefect, or dbt Cloud.
  • Expertise in data mining, data analytics, data modeling, large-scale data environments, and analytics engineering best practices.
  • Ability to work conceptually, analytically, and creatively; communicate effectively with senior management and internal clients; and solve complex problems.

Benefits

  • Competitive compensation, bonus potential, and incentive bonus programs.
  • Flexibility to work from anywhere in the United States for most positions.
  • Paid time off including vacation, sick time, nine company holidays, and volunteer hours.
  • Medical, dental, vision, life, and pet insurance.
  • 401(k) retirement savings plan with company match.
  • Education assistance and professional and personal development opportunities.
  • Promotional opportunities, an engaging work environment, and a company recognition program.
  • Health and wellbeing resources including free mental wellbeing therapy or coaching sessions and child and eldercare resources.

Tech Stack

Apache AirflowAWSdbtInformaticaPythonSQL

Categories

Data Engineering
Mercury Insurance Services, LLC

About Mercury Insurance Services, LLC

1,001-5,000 employees

Mercury Insurance Services, LLC sells personal auto, homeowners, renters, and related coverage (umbrella, condo, business auto, and mechanical breakdown) to consumers, primarily through independent agents. The company generates revenue from underwriting and premiums on property-and-casualty policies and is publicly traded on the NYSE (ticker: MCY). Founded in 1962 and headquartered in Brea, California, it is a major writer of auto insurance in California and operates in multiple U.S. states.

Contact me