US-Remote Remote (Country) Full-time USD 94,458 – 179,048 / year

Mercury Insurance is hiring a Data Analytics Engineer II

Responsibilities

  • Construct and expand the metric layer
  • Create and maintain dbt models
  • Contribute to semantic layer definitions including metrics, dimensions, and relationships
  • Ensure key business metrics and metric hierarchies are consistent and correct
  • Implement analytical logic for root cause analysis and metric insights
  • Develop root cause analysis workflows with baseline comparisons and companion metric analysis
  • Convert business questions into scalable analytical patterns
  • Enable metric consumption across various tools
  • Support metric usage in different BI or analytical tools
  • Build reusable logic to prevent duplication across tools
  • Prepare for a future API-based metric serving layer
  • Collaborate 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

Compensation

Base salary ranges from $77,283 to $179,048 depending on location and factors like experience and skills; includes competitive compensation, incentive bonus programs, and 401(k) with company match.

Work Arrangement

Flexibility to work from anywhere in the United States for most positions

Team

Partners with sales, product, underwriting, claims, experience, and other business teams

Other

  • An in-person interview may be required during the hiring process
  • State specific pay scales for this role are as follows: $94,458 to $179,048 (CA, NJ, NY, WA, HI, AK, MD, CT, RI, MA) $85,871 to $162,771 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME) $77,283 to $146,494 (UT, ID, MT, NM, SD, NE, KS, OK, IA, AR, LA, MS, AL, TN, KY, IN, SC, NC, WV)
  • The expected base salary for this position will vary depending on a number of factors, including relevant experience, skills and location.
  • 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
Job Details
Location US-Remote
Work mode Remote (Country)
Employment Full-time
Salary USD 94,458 – 179,048 / year
Department Engineering
Category Data & ML
Posted 14 days ago
or drop your CV first
About company
Mercury Insurance logo

Mercury Insurance has been providing comprehensive coverage options for auto, home, condo, renters, and business insurance as well as mechanical protection since 1961. The company is guided by its purpose to help people reduce risk and overcome unexpected events, and it takes pride in providing smooth and efficient claims resolutions. Headquartered in Brea, California, Mercury operates 15 additional offices across the 11 states in which it operates. The Special Investigations Unit (SIU) works with local and federal law enforcement to take down hundreds of fraud rings and scammers each year, saving customers from paying additional premiums due to phony claim payouts. Mercury has also established a stress-free vehicle repair process by designating Mercury authorized auto shops where any repairs are guaranteed for as long as you own the vehicle.

All jobs at Mercury Insurance Visit website