Data Analytics Engineer II

Role Overview

Mercury Insurance is hiring an Analytics Engineer II to build and scale an enterprise metrics store and enable insights across underwriting, sales, product, claims, and experience. The role combines analytics engineering with prompt engineering to support a fully governed, AI-ready data ecosystem, with an evolving direction toward exposing metric infrastructure via internal services.

Responsibilities

• Build and scale the metric layer
• Develop and maintain dbt models
• Define and maintain the semantic layer (metrics, dimensions, relationships)
• Ensure consistency and correctness of key business metrics, including metric hierarchies (metric pyramid)
• Implement analytical logic for root cause analysis and metric insights
• Create and operationalize baseline comparisons and companion metric analysis
• Translate business questions into reusable analytical patterns
• Enable metric consumption across BI/analytical tools with support for different output requirements
• Build reusable logic to avoid duplication across tools
• Partner with business and product stakeholders (sales, product, underwriting, claims, experience)
• Translate ambiguous questions into structured metrics and actionable insights
• Improve data quality and governance by defining and enforcing:
  • Metric definitions
  • Dimension standards
  • Data contracts
• Debug issues across upstream pipelines, semantic layer, and analytical outputs
• Contribute to future API-based metric serving as the infrastructure matures

Requirements

• Bachelor’s degree in Computer Science, Statistics, or similar
• 3–5 years of analytics engineering (or similar) experience using dbt or equivalent transformation frameworks
• Proficiency with dbt features such as models, tests, incremental materialization, and Jinja macros
• Advanced SQL on a columnar warehouse (Redshift, Snowflake, or BigQuery)
• Python for data transformation/analysis (e.g., pandas and basic scripting)
• Comfort with YAML-based configuration and version-controlled analytics workflows
• Strong written and verbal communication; can explain metric definitions and data lineage to non-technical stakeholders

Nice to Have

• P&C insurance domain experience
• Experience with cohort analysis, funnel metrics, and performance analysis
• Familiarity with MetricFlow and the dbt Semantic Layer
• Exposure to Retool (or similar low-code operational write-back tools)
• Experience serving data products via FastAPI (or similar: Flask, Django REST)

Compensation (Base Salary)

• CA, NJ, NY, WA, HI, AK, MD, CT, RI, MA: $94,458–$179,048
• NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME: $85,871–$162,771
• UT, ID, MT, NM, SD, NE, KS, OK, IA, AR, LA, MS, AL, TN, KY, IN, SC, NC, WV: $77,283–$146,494
• Base salary varies by relevant experience, skills, and location.