Auto BI Data Analyst

American Family Insurance•Minneapolis, MN

7d•$69,000 - $115,000•Hybrid

About The Position

The Auto BI Data Analyst enables faster, more consistent access to trusted Auto data by partnering with data engineering and governance teams to standardize key datasets and definitions. The role supports scalable self-service dashboards and reporting, translates ambiguous business needs into well-defined data requirements, guides stakeholders toward standard KPI definitions, and shapes scalable self-service BI solutions. The position reports to the Senior Manager, Data Analytics. This is a flex office/home role requiring at least 10 days per month in an office in Madison, WI; Boston, MA; Denver, CO; Eden Prairie, MN; Keene, NH; St. Joseph, MO; or Phoenix, AZ. Travel may be required up to 10%. Depending on the candidate pool, the position may be filled at a lower level to align with experience and qualifications. Candidates requiring current or future sponsorship will not be considered. The listed compensation range is $69,000 to $115,000, with pay based on job level and geographic work location. Relocation support is available for eligible candidates. Employees attend in-person New Employee Orientation during their first week at the Madison headquarters or another core location, though sessions may sometimes be virtual. Offers are contingent on applicable background checks and signing a nondisclosure agreement.

Requirements

Demonstrated experience providing customer-driven solutions, support, or service.
Understanding of forecasting techniques or statistical analysis.
Demonstrated experience using Microsoft Excel to build complex formulas and create reports.
Understanding of software tools used to query and report data.
Extensive SQL coding experience.
Travel requirements up to 10%.

Nice To Haves

Data visualization experience using tools such as Tableau Cloud, Claude, and Data Studio.
Demonstrated experience developing AI capabilities with tools such as Gemini or Claude.

Responsibilities

Take ownership of initiative analysis and deliver 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 through various platforms.
Support and execute analytical needs throughout the enterprise.
Process, manipulate, and investigate large and complex datasets.
Explore data to identify new attributes and determine appropriate approaches to business issues.
Develop tools or dashboards to monitor and evaluate performance.
Complete other assignments or participate in projects as requested, based on skills, achievements, or experience.