Mercury Insurance · 8 hours ago
Lead Analytics Engineer – Metrics & AI Enablement
California, United States
Full-time
Onsite
Senior Level, Lead/Staff
$119K/yr - $231K/yr
7+ years expMercury Insurance is seeking a Lead Analytics Engineer to build a next-generation enterprise metrics store and enable insights across various business functions. The role involves defining metrics creation and governance, designing prompts for AI personas, and collaborating with cross-functional teams to enhance data quality and analytics capabilities.
Insurance
Responsibilities
Build and maintain our enterprise metrics store (Tier 1–3 KPIs)
Define metric relationships, hierarchies, lineage, and semantic layers using dbt
Partner with engineering and business teams to unify metric logic and governance
Implement automated data quality checks and testing
Develop high-quality dbt models, reusable marts, and production-grade SQL
Optimize performance in cloud data warehouses (Snowflake/BigQuery/Redshift)
Support dashboards, API consumers and operational systems
Maintain documentation, standards, and CI/CD for analytics workflows
Design prompts, logic flows, and knowledge structures for LLM-powered internal agents
Create metric-aware AI interactions that provide accurate, governed insights
Reduce hallucination risk through prompt patterns, guardrails, and validation steps
Collaborate with product and business teams to define AI personas for key roles
Work closely with underwriting, sales, product, claim and experience analytics team
Translate business logic into certified metrics and scalable models
Mentor junior analytics engineers and contribute to internal best practices
Qualification
Required
7+ years in analytics engineering, data engineering, or BI engineering
BS in STEM major is required
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
Preferred
MS is preferred
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
Variety of benefits to help our team members reach their health, retirement, and professional goals
Company
Mercury Insurance
Mercury Insurance has offered quality insurance for personal auto insurance to homeowners insurance to mechanical breakdown protection.
5001-10000 employees
H1B Sponsorship
Mercury Insurance has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (22)
2024 (23)
2023 (14)
2022 (15)
2021 (8)
2020 (13)
Funding
Current Stage
Public CompanyTotal Funding
unknown1985-11-29IPO
Leadership Team
T
Ted Stalick
SVP & CFO
V
Victor Joseph
President & Chief Operating Officer
Recent News
2026-01-22
2026-01-20
2026-01-16
Company data provided by crunchbase