Hybrid Auto BI Data Analyst: Self-Service Dashboards

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

Benefits offered by this job

Health benefits

401(k) plan

Pension plan

Paid time off

Job summary

American Family Insurance seeks an Auto BI Data Analyst to enable trusted Auto data access, collaborating with data engineering and governance teams to standardize datasets and definitions. The role supports scalable self-service BI solutions and translates business needs into data requirements.

The position is a flex office/home role with travel to multiple US locations and a strong focus on KPI standardization and dashboard development.

Qualifications

• Demonstrated experience translating ambiguous business needs into data requirements.
• Ability to translate business metrics into standard KPIs and dashboards.
• Proficiency with SQL and advanced Excel for data manipulation.

Responsibilities

• Own initiative analysis and share insights company-wide for digital performance transparency.
• Manage and operate a wide range of analytical programs.
• Lead automation and improvement of digital analytics across platforms.

Skills

Data analysis

SQL

Excel formulas

Data visualization

Tools

Tableau Cloud

Claude

Data Studio

Gemini

Job description

American Family Insurance seeks an Auto BI Data Analyst to enable trusted Auto data access, collaborating with data engineering and governance teams to standardize datasets and definitions. The role supports scalable self-service BI solutions and translates business needs into data requirements.

The position is a flex office/home role with travel to multiple US locations and a strong focus on KPI standardization and dashboard development.