Hybrid Auto BI Analytics Specialist

American Family Insurance Agency Staff; Kansas City (MO); Hybrid; USD 69,000 - 115,000; Full time

Job summary

The Auto BI Data Analyst role at American Family Insurance Agency Staff partners with data engineering and governance teams to standardize datasets and definitions, enabling faster access to trusted Auto data. You will translate business needs into clear data requirements and shape scalable self-service BI solutions.

In a flex office/home setting, you will work from multiple U.S. locations and occasionally travel up to 10%.

Qualifications

• Experience providing customer-driven solutions, support or service.
• Understanding of forecasting techniques or statistical analysis.
• Experience using Excel to build complex formulas and reports.
• Understanding of software tools to query and report data.
• Travel requirements up to 10%.

Responsibilities

• Take ownership of initiative analysis and deliver that information company-wide to provide transparency into digital performance.
• Manage and operate a wide variety of analytical programs.
• Lead the improvement and automation of digital analytics programs across platforms.
• Support and execute analytical needs throughout the enterprise.
• Process, manipulate, and investigate large datasets.
• Explore data to identify new attributes and address business issues.
• Develop tools or dashboards to monitor and evaluate performance.
• May be asked to complete other assignments or participate in projects.

Skills

Extensive SQL

Tableau Cloud

AI capabilities (Gemini/Claude)

Forecasting techniques

Excel advanced formulas

Tools

Tableau Cloud

Data Studio

Claude

Gemini

Job description

The Auto BI Data Analyst role at American Family Insurance Agency Staff partners with data engineering and governance teams to standardize datasets and definitions, enabling faster access to trusted Auto data. You will translate business needs into clear data requirements and shape scalable self-service BI solutions.

In a flex office/home setting, you will work from multiple U.S. locations and occasionally travel up to 10%.