Analytics Engineer II – CX Metrics

Job description

Overview

Position Summary:

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.

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.

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.

Responsibilities

Essential Job Functions:

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.

Qualifications

Education:

Minimum:

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

Preferred:

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

Experience:

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.

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.

Pay Range

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

Apply on Himalayas (opens in a new tab)

Source: Himalayas.

Report this job

Wrongly listed? Tell us why.