Lead Analytics Engineer – Metrics & AI Enablement
Mercury InsuranceRiverside, California, United States
Posted February 3, 2026
118614 - 230619 USD
Full Time
About the Company
Mercury is a company that helps people reduce risk and overcome unexpected events for over 60 years. We are one team with a common goal to help others.
Job Description
We’re looking for a Lead Analytics Engineer to build our next-generation enterprise metrics store and enable insights across underwriting, sales, product, claim and experience. This role blends analytics engineering and prompt engineering, supporting our journey toward a fully governed, AI-ready data ecosystem.
Requirements
- 7+ years in analytics engineering, data engineering, or BI engineering
- BS in STEM major is required. MS is preferred
- Expert SQL and strong hands-on experience with dbt (semantic layer, macros, tests)
- Deep understanding of data modeling and governed metric design
- Experience building a metric layer, metrics store, or semantic model in production
- Practical experience with LLMs or prompt engineering for AI assistants
- Strong communication skills and ability to partner with business stakeholders
- Experience in P&C insurance data (Quote, Bind, Policy, Claims, Agent) is a plus
- Familiarity with LLM retrieval, embeddings, or knowledge bases is a plus
- Experience with Airflow, Dagster, Prefect, or dbt Cloud is a plus
Benefits
- Competitive salary
- Bonus potential
- Various benefits to help team members reach their health, retirement, and professional goals
