caferemote
Mercury Insurance

Analytics Engineer II - CX Metrics

Remote United States $94K – $179K / year Posted 5h ago
Apply now
Work from
United States
Salary
$94K – $179K / year
Posted
21 November 2026
Apply by
20 January 2027

We’re seeking a curious, detail-oriented Analytics Engineer II to build the data foundations that help our CX Metrics team collect, analyze, and act on customer experience data. You’ll create semantic models that make data accessible, align data across sources, work across teams to clarify sources of truth, document metric definitions and usage practices, and build and maintain dashboards that support decision-making. You’ll also coach analysts and decision-makers and share best practices.

About the role

The ideal candidate is an efficient, self-directed data storyteller who can design the data structures and visualizations needed to answer business questions. You can look beyond the initial request, connect data with business context, and develop practical data strategies that put reliable insights in the hands of analysts and decision-makers. You will become an expert on the core metrics used by the Experience team and support the enterprise in leveraging customer-focused data.

Responsibilities

Under limited supervision

  • Build and maintain curated tables and semantic models, in partnership with the data science team, making CX data consistent and easy to use for dashboards and analysis. Use SQL and tools like dbt to transform and combine warehouse data, then validate it for accuracy and usability.
  • Partner with teams across the organization, including Service, Sales, Product, Claims, and Underwriting Analytics, to identify data sources of truth and align on definitions, metrics, and datasets. Define how to connect, interpret, and use data across sources and data types including surveys, contact center metrics, digital interactions, policy / pricing / underwriting / claims data, and business outcomes.
  • Develop reports and Power BI dashboards that help stakeholders track CX trends and identify customer pain points and opportunities to improve experiences. Partner with business stakeholders to understand context and build actionable dashboards and datasets efficiently.
  • Develop a high-level data strategy that keeps customer experience data accurate and usable. Establish processes for ongoing documentation and maintenance of new data sources and metrics. Share information about new CX-owned data with relevant users and answer questions about its use.
  • Coach analysts on SQL and Power BI fundamentals. Advise on data structures and hygiene, storytelling through data visualization, the trade-offs of different approaches, practical tips, and best practices.
  • Create reusable templates for recurring data requests, such as contact lists, and develop data structures and visualizations to evaluate pilots, A/B tests, and new programs.
  • Support ongoing and ad hoc analysis through statistical analysis, alerts, email digests, or reports, as needed.
  • Identify opportunities to automate data preparation, analysis, and visualization. Evaluate the effectiveness and reliability of AI tools for cleaning and analyzing data.

• Perform other duties as assigned.

Requirements

Minimum

  • Bachelor’s degree in data science, data engineering, analytics, economics, mathematics, statistics, finance, computer science, or a related field.

Minimum

  • At least 4 years in data analytics, data engineering, data visualization, data science, business intelligence, or a related field, including understanding the business context behind the data.

• At least 2 years writing SQL.

  • At least 2 years using data visualization tools such as Power BI or Tableau.

Nice to have

Preferred

  • Master’s degree, or an equivalent combination of education and experience.

Preferred

  • Experience with property and casualty insurance, contact centers, customer experience, and/or survey data.

Knowledge and Skills

Minimum

  • Excellent written and verbal communication, including synthesizing inputs and presenting reasoning clearly and persuasively.
  • Strong data storytelling; ability to explain complex data and insights clearly and concisely.
  • Strong cross-functional collaboration and relationship-building skills.
  • Initiative and ability to drive projects to completion; attention to detail and ability to work independently and as part of a team.
  • Excellent analytical, critical-thinking, and problem-solving skills; experience analyzing complex datasets and applying analytics and visualization to business challenges.
  • Strong SQL programming skills; strong understanding of cloud-based data warehouses.
  • Expertise in Power BI, Tableau, or similar business intelligence and reporting tools.
  • Comfort using AI-assisted tools in analytical or business contexts and evaluating AI-generated outputs for accuracy, bias, and appropriateness; awareness of data privacy, responsible AI, and AI limitations in regulated industries such as insurance.

Preferred

  • Knowledge of CX principles and best practices, or strong interest in learning CX.
  • Experience with A/B testing and experimental design.
  • dbt experience; Amazon Redshift experience or working knowledge of cloud data warehouses.
  • Python experience, including reading and adapting existing scripts for routine reporting or data pulls.
  • Experience with GitHub or similar version-control tools.

Salary

USD $94,458.00 - USD $179,048.00 /Yr.

Geo-Salary Information

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 (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)

In CA: Typical hiring range is $102,565 to $150,428

The expected base salary for this position will vary depending on a number of factors, including relevant experience, skills and location.

Discussion

No comments yet. Ask a question or share a tip about this role.

Apply now

More jobs from Mercury Insurance

View company →

Sr Director Research and Development

Mercury Insurance
Remote United States $145K – $382K / year

Overview Position Summary: The Sr Director, Research & Development (R&D), is the senior product R&D leader for the personal property products (Homeowners and…

3h ago Product

Principal Data Architect

Mercury Insurance
Remote United States $107K – $300K / year

Overview Position Summary: Mercury Insurance is seeking a Principal Data Architect to lead the strategy, design, and evolution of our enterprise data…

4h ago Data

Finance Transformation Lead

Mercury Insurance
Remote United States $101K – $204K / year

Overview Position Summary: The Finance Transformation Lead is a hands-on technology, data and process-automation leader responsible for advancing modernization…

10h ago Management and Finance

Data Engineer I

Mercury Insurance
Remote United States $83K – $161K / year

Overview Join an amazing team that is consistently recognized for our achievements and culture, including our most recent Forbes award of being one of…

yesterday DevOps and Sysadmin

Similar remote jobs

Browse all →

Senior BI/DW Developer

Nextpower
Remote India Full-time

Job Description: BI/DW Architect (Finance Analytics & Insights) Position Summary The BI/DW Architect (Finance Analytics & Insights) is a strategic leader within the Global Controllership…

2h ago Data

Senior Analytics Solutions Lead – Power BI & Fabric

Cooper Equipment Rentals Limited
Remote Canada Full-time CAD 110K – CAD 130K / year

Build your Career at Cooper Equipment Rentals Please note, to be considered for this position applicants should currently be residing in Canada and legally entitled to work. Why Work with…

2h ago Data

ServiceNow Business Analyst

LIGHTFEATHER IO LLC
Remote United States Full-time $110K – $130K / year

LightFeather is seeking a Senior ServiceNow Business Analyst to lead the requirements gathering and process design for our federal agency clients. In this role, you will act as the critical…

2h ago Data

Senior Data Migration Specialist

WELLSTAR
Remote Canada Full-time CAD 75K – CAD 95K / year

Who we are At WELLSTAR , we are committed to reshaping Canadian healthcare by leveraging technology to address the administrative burdens that pull physicians away from their true calling,…

2h ago Data

Risk Adjustment Operations Senior Project Analyst

Datavant
Remote United States Full-time $103K – $121K / year

Datavant is the data collaboration platform trusted for healthcare. Guided by our mission to make the world’s health data secure, accessible and actionable, we provide critical data…

2h ago Data

Data Scientist

Timeleft
Remote Albania, Andorra, Austria, Belarus, Belgium, Bosnia and Herzegovina, Bulgaria, Croatia, Cyprus, Czechia, Denmark, Estonia, Faroe Islands, Finland, France, Germany, Gibraltar, Greece, Guernsey, Holy See (Vatican City State), Hungary, Iceland, Ireland, Full-time

⌘Role Overview The Data Scientist is the first hire on the team whose job is to put machine learning into production , not just into a notebook. You'll build models that power product and…

3h ago Data

Get remote jobs the moment they are posted

Choose your categories and skills. We push matching jobs to your device. No email, ever.