Auto BI Data Analyst: Dashboards & AI Insights

American Family Insurance Agency Staff; Madison (WI); Hybrid; USD 69,000 - 115,000; Full time

Benefits offered by this job

Healthcare benefits

401(k) plan

Pension plan

Paid holidays

Paid time off

Job summary

American Family Insurance is seeking an Auto BI Data Analyst to enable faster, trusted Auto data access by partnering with data engineering and governance teams. You will standardize key datasets, develop scalable self-service dashboards, translate business needs into data requirements, and shape BI solutions.

You will work in a flex office/home role, with a minimum of 10 days per month in Madison, WI or other AmFam locations. This role requires no sponsorship and offers relocation support.

Qualifications

• Experience delivering customer-focused data solutions.
• Forecasting or statistical analysis knowledge.
• Advanced Excel for complex formulas and reporting.
• Ability to query and report data with software tools.

Responsibilities

• Own initiative analysis and share insights across the company.
• Operate diverse analytical programs.
• Automate and improve digital analytics programs.
• Support enterprise analytical needs and projects.
• Process and explore large, complex datasets.
• Discover new data attributes to address business issues.
• Develop dashboards to monitor performance.
• Take on additional assignments as needed.

Skills

Customer-driven solutions

Forecasting techniques

Excel advanced formulas

Data querying tools

Travel up to 10%

Tools

SQL

Tableau Cloud

Claude / Gemini AI tools

Job description

American Family Insurance is seeking an Auto BI Data Analyst to enable faster, trusted Auto data access by partnering with data engineering and governance teams. You will standardize key datasets, develop scalable self-service dashboards, translate business needs into data requirements, and shape BI solutions.

You will work in a flex office/home role, with a minimum of 10 days per month in Madison, WI or other AmFam locations. This role requires no sponsorship and offers relocation support.