Data Analytics Engineer II

🕒 June 16

🏈 Alabama, Alaska, +44 more states – Remote

🏈 Alabama – Remote 🐻 Alaska – Remote 🌵 Arizona – Remote 🏄 California – Remote ⛰️ Colorado – Remote 🦌 Connecticut – Remote 🐊 Florida – Remote 🌺 Hawaii – Remote 🥔 Idaho – Remote 🌽 Illinois – Remote 🌾 Iowa – Remote 🌪️ Kansas – Remote 🐎 Kentucky – Remote ⚜️ Louisiana – Remote 🦞 Maine – Remote 🦬 Montana – Remote 🌾 Nebraska – Remote 🎰 Nevada – Remote 🗻 New Hampshire – Remote 🏖️ New Jersey – Remote 🌶️ New Mexico – Remote 🗽 New York – Remote 🌲 North Carolina – Remote 🌾 North Dakota – Remote 🏈 Ohio – Remote 🌪️ Oklahoma – Remote 🌲 Oregon – Remote 🦀 Maryland – Remote 🍂 Massachusetts – Remote 🚗 Michigan – Remote ❄️ Minnesota – Remote 🎸 Mississippi – Remote 🏰 Missouri – Remote 🔔 Pennsylvania – Remote ⚓ Rhode Island – Remote 🌴 South Carolina – Remote 🗿 South Dakota – Remote 🎸 Tennessee – Remote 🤠 Texas – Remote ⛷️ Utah – Remote 🍁 Vermont – Remote ⚔️ Virginia – Remote ☕ Washington – Remote ⛰️ West Virginia – Remote 🧀 Wisconsin – Remote 🦬 Wyoming – Remote

💵 $94.5k - $179k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

📊 Analytics Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Mercury Insurance

WebsiteLinkedInAll Job Openings

5001 - 10000 employees

Founded 1962

🚘 Automotive

💼 Consulting

📦 Logistics

Automotive • Consulting • Logistics

Mercury Insurance is a leading provider of insurance products, focusing on protecting individuals and their assets with a commitment to privacy and customer service. The company operates through independent agents and offers a range of insurance services including auto, home, and other personal insurance products. Mercury Insurance prioritizes the security of personal information and compliance with privacy laws, ensuring that customer data is handled with care and only shared when necessary for account servicing or as legally required.

📋 Description

• Build and scale the metric layer • Develop and maintain dbt models • Contribute to semantic layer definitions (metrics, dimensions, relationships) • Ensure consistency and correctness of key business metrics • Implement analytical logic (root cause analysis & metric insights) • Build root cause analysis workflows: Implement baseline comparisons, companion metric analysis • Translate business questions into scalable analytical patterns • Enable metric consumption across tools • Support metric usage in different BI or analytical tools • Build reusable logic that avoids duplication across tools • Prepare for future API-based metric serving layer • Partner with business and product stakeholders • Work closely with sales, product, underwriting, claims, experience and other business teams • Translate ambiguous questions into structured metrics and actionable insights • Improve data quality and governance • Define and enforce metric definitions, dimension standards, and data contracts • Debug issues across upstream pipelines, semantic layer, and analytical outputs

🎯 Requirements

• Bachelor's Degree in Computer science, Statistics or similar • 3–5 years of analytics engineering or similar analytical role experience with dbt or similar transformation frameworks proficiency: models, tests, incremental materialization, Jinja macros • Advanced SQL on a columnar warehouse (Redshift, Snowflake, or BigQuery) • Python for data transformation and analysis (pandas, basic scripting) • Comfort working with YAML-based configuration and version-controlled analytics workflows • Clear written and verbal communication—able to explain metric definitions and data lineage to non-technical stakeholders.

🏖️ Benefits

• Competitive compensation • Flexibility to work from anywhere in the United States for most positions • Paid time off (vacation time, sick time, 9 paid Company holidays, volunteer hours) • Incentive bonus programs (potential for holiday bonus, referral bonus, and performance-based bonus) • Medical, dental, vision, life, and pet insurance • 401 (k) retirement savings plan with company match • Engaging work environment • Promotional opportunities • Education assistance • Professional and personal development opportunities • Company recognition program • Health and wellbeing resources, including free mental wellbeing therapy/coaching sessions, child and eldercare resources, and more