Remote Data Analytics Engineer II — Metrics & Insights

Mercury Insurance; United States; On-site; USD 94,458 - 179,048; Full time

Benefits offered by this job

Competitive compensation

Flexibility to work from anywhere in the United States

Paid time off

Incentive bonus programs

Medical, dental, vision, life, and pet insurance

401(k) with company match

Promotional opportunities

Education assistance

Company recognition program

Health and wellbeing resources

Job summary

Mercury Insurance is seeking an Analytics Engineer II to build their next-generation enterprise metrics store. This role involves working across underwriting, sales, product, claim, and experience, blending analytics and prompt engineering.

Candidates should have a Bachelor's Degree, experience in analytics engineering, and strong skills in SQL and Python. The position offers flexibility to work remotely across the United States and includes competitive benefits.

Qualifications

• 3–5 years of analytics engineering or similar role experience with dbt or similar transformation frameworks.
• Advanced SQL on a columnar warehouse.
• Comfortable with YAML‑based configuration.

Responsibilities

• Build and scale the metric layer.
• Develop and maintain dbt models.
• Enable metric consumption across tools.

Skills

Analytics Engineering

SQL

Python

YAML

Education

Bachelor's Degree in Computer Science, Statistics or similar

Tools

dbt

Redshift

Snowflake

BigQuery

Job description

Mercury Insurance is seeking an Analytics Engineer II to build their next-generation enterprise metrics store. This role involves working across underwriting, sales, product, claim, and experience, blending analytics and prompt engineering.

Candidates should have a Bachelor's Degree, experience in analytics engineering, and strong skills in SQL and Python. The position offers flexibility to work remotely across the United States and includes competitive benefits.