Lead Data Analytics Engineer

Mercury Insurance Services, LLC•, CA
•$97,089 - $230,619

About The Position

The Lead Analytics Engineer will help shape Mercury’s governed, AI-ready analytics ecosystem by building enterprise metrics and enabling trusted insights across underwriting, sales, product, claims, and customer experience. The role creates scalable, production data pipelines for analytics and data science teams and performs ad hoc analyses for colleagues in less technical functions. It also designs, evaluates, and tests data infrastructures and serves as a subject matter expert on data across the organization. The position works closely with data scientists and analysts to prepare data, build models and visualizations, solve complex data integration challenges, and support production processes. The engineer leverages Mercury’s data infrastructure and expertise in its data lakes, warehouses, and cubes to deliver trusted data and insights across departments, products, and states. The role also identifies data opportunities and pain points, maintains and improves data models, and develops natural language processing software modules.

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/or experience.
  • Five or more years of experience in data analytics, analytics engineering, data engineering, and/or data science.
  • Experience using SQL and Python to build data pipelines and perform analyses.
  • Experience with AWS, including S3 and EC2, and Unix/Shell scripting.
  • ETL/ELT experience, such as dbt, Informatica, or Fivetran.
  • Experience with a variety of relational and non-relational databases and data sources.
  • Expertise working with large structured and unstructured data sources and cloud-based advanced data and analytics environments.
  • Familiarity with CI/CD best practices.
  • Ability to analyze data and identify gaps and inconsistencies, with demonstrated skills in data mining and data analytics.
  • Ability to think conceptually, analytically, and creatively and work comfortably with ambiguity.
  • Experience managing and communicating data plans and data models to internal clients.
  • Strong understanding of and interest in data and analytics engineering best practices.
  • Strong problem-solving, analytical, and critical-thinking skills.
  • Excellent written and verbal communication skills.
  • Ability to regularly interact and work with senior management.
  • Demonstrate the Company’s Core Values.

Nice To Haves

  • Three or more years of experience in property and casualty (P&C) insurance; preferred but not required.
  • Experience building enterprise metrics stores, semantic layers, or governed KPI frameworks, including metric definitions, relationships, hierarchies, and lineage (for example, with dbt).
  • Experience with prompt engineering or LLM-powered assistants, including persona design, guardrails, retrieval or knowledge bases, and validation.
  • Experience working with P&C insurance data such as quote, bind, policy, claims, or agent data.
  • Familiarity with orchestration tools such as Airflow, Dagster, Prefect, or dbt Cloud.

Responsibilities

  • Work closely with the Data Science team on complex analytics and data preparation tasks.
  • Design, build, and launch sophisticated data models and visualizations for multiple use cases across departments, products, and states.
  • Solve challenging data integration problems using appropriate ETL patterns, frameworks, query techniques, and structured and unstructured data sources.
  • Help own production processes and optimize complex code using advanced algorithmic concepts.
  • Develop expert knowledge of Mercury’s data lakes, warehouses, and data cubes, and extract and manipulate data from any source.
  • Collaborate with data analysts and data scientists to integrate algorithms and develop solutions to complex data problems.
  • Influence functions across the organization to identify data opportunities that support profitable growth.
  • Proactively identify pain points with existing data models.
  • Use existing data infrastructure to fulfill data requests and perform data housekeeping, cleansing, normalization, hashing, and required data model changes.
  • Analyze data to identify anomalies and trends and correlate similar data sets.
  • Design, develop, and implement natural language processing software modules.
  • Perform other functions as assigned.

Benefits

  • Competitive compensation
  • Bonus potential and incentive bonus programs, including potential holiday, referral, and performance-based bonuses
  • Paid time off, including vacation time, sick time, nine paid company holidays, and volunteer hours
  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Life insurance
  • Pet insurance
  • 401(k) retirement savings plan with company match
  • Education assistance
  • Professional and personal development opportunities
  • Health and wellbeing resources, including free mental wellbeing therapy/coaching sessions and child and eldercare resources
  • Company recognition program
  • Promotional opportunities
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service