Auto BI Data Analyst

Posted Yesterday
4 Locations
Hybrid
69K-115K Annually
Entry level
Insurance
The Role
Analyzes complex automotive data, standardizes datasets and KPI definitions, partners with engineering and governance teams, and develops scalable self-service dashboards. The role translates ambiguous business needs into data requirements, automates digital analytics programs, investigates trends and attributes, and supports enterprise reporting. It requires SQL, Excel, data visualization, statistical analysis, and AI tool experience. The position is hybrid, requiring at least 10 office days monthly, with travel up to 10%.
Summary Generated by Built In
The Auto BI Data Analyst will enable faster, more consistent access to trusted Auto data by partnering with data engineering and governance teams to standardize key datasets and definitions. You will also support the development of scalable self-service dashboards and reporting. You will independently translate ambiguous business needs into well-defined data requirements, guide stakeholders to standard KPI definitions, and shape scalable self-service BI solutions. You will report to the Senior Manager, Data Analytics.
In this flex office/home role, you will be expected to work a minimum of 10 days per month from one of the following office locations: Madison, WI 53783; Boston, MA 02110; Denver, CO 80112; Eden Prairie, MN 55343; Keene, NH 03431; St. Joseph, MO 64507; Phoenix, AZ 85034
Internal candidates are encouraged to apply and should review the internal mobility guidelines in the hybrid policy reference guide for more information on potential relocation. Depending on the candidate pool, this position may be filled at a lower level to maintain alignment with experience and qualifications.
We will not consider candidates who require current or future sponsorship for this position

Position Compensation Range:

$69,000.00 - $115,000.00

Pay Rate Type:

Salary

Compensation may vary based on the job level and your geographic work location. Relocation support is offered for eligible candidates.

Primary Accountabilities


  • You will take ownership of initiative analysis and deliver that information company-wide to provide transparency into digital performance.
  • You will manage and operate a wide variety of analytical programs.
  • You will lead the improvement and automation of all digital analytics programs through various platforms.
  • You will support and execute the analytical needs throughout the enterprise.
  • You will process, manipulate, and investigate large and complex datasets.
  • You will explore data to identify new attributes and determine best approach to address business issues.
  • You will develop tools or dashboards to monitor and evaluate performance.
  • You may be requested to complete other assignments or participate in projects based upon skills, achievements, or experience.

Specialized Knowledge & Skills Requirements


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

Additional Qualifications


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

#LI-Hybrid

Additional Information
  • To ensure a strong start, all employees participate in our New Employee Orientation during their first week.  This experience is held in person at our Madison, WI Headquarters or one of our AmFam core locations to help you connect with our mission, meet key team members and build relationships that support your growth.  At times, sessions may be delivered virtually based on scheduling and availability. 
  • Offer to selected candidate will be made contingent on the results of applicable background checks
  • Offer to selected candidate is contingent on signing a non-disclosure agreement for proprietary information, trade secrets, and inventions
  • Sponsorship will not be considered for this position unless specified in the posting

We provide benefits that support your physical, emotional, and financial wellbeing. You will have access to comprehensive medical, dental, vision and wellbeing benefits that enable you to take care of your health. We also offer a competitive 401(k) contribution, a pension plan, an annual incentive, 9 paid holidays and a paid time off program (23 days accrued annually for full-time employees). In addition, our student loan repayment program and paid-family leave are available to support our employees and their families. Interns and contingent workers are not eligible for American Family Insurance Group benefits.

We are an equal opportunity employer. It is our policy to comply with all applicable federal, state and local laws pertaining to non-discrimination, non-harassment and equal opportunity. We also consider qualified applicants with criminal histories, consistent with applicable federal, state and local law.

American Family Insurance is committed to the full inclusion of all qualified individuals. If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please email [email protected] to request a reasonable accommodation.

#LI-RS1

Skills Required

  • Experience providing customer-driven solutions, support, or service
  • Understanding of forecasting techniques or statistical analysis
  • Experience using Microsoft Excel to build complex formulas and create reports
  • Understanding of software tools for querying and reporting data
  • Data visualization experience using Tableau Cloud, Claude, or Data Studio
  • Extensive SQL coding experience
  • Experience developing AI capabilities using tools such as Gemini or Claude

American Family Insurance Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about American Family Insurance and has not been reviewed or approved by American Family Insurance.

  • Pay Growth & Progression — Compensation has seen multiple increases, including a higher internal minimum hourly wage effective 2025 for many customer‑facing and claims roles. These moves indicate continued investment to raise the pay floor and improve total rewards competitiveness.
  • Retirement Support — The total package includes a 401(k) with company match alongside a company‑funded cash‑balance pension, strengthening long‑term financial security. This combination is positioned as a standout element within the overall benefits mix.
  • Parental & Family Support — Paid parental leave was expanded in 2025 for birthing parents and for all parents, including adoptive and foster. Caregiver leave adds further family support within the leave portfolio.

American Family Insurance Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Madison, WI
16,528 Employees
Year Founded: 1927

What We Do

For more than 85 years, American Family Insurance has built its reputation on sound principles. We strive to provide you industry-leading service, exceptional claims experience and products that build long-term relationships. This is accomplished by treating policyholders fairly in a helpful and caring way and making it easy and convenient to work with us. We know our customers like family. American Family Insurance thrives by conducting its business in accordance with the highest ethical standards and the law at all times. Integrity is part of our culture and always has been. The reputation we enjoy and trust-based relationships we have built with our customers are determined by the example set by management and the character and good judgment exercised at all levels of our organization. It’s a way of doing business that our customers have come to expect from us and a standard that we continue to live up to.

Similar Jobs

Circle (circle.so) Logo Circle (circle.so)

Lead Engineer, AI Platform

Artificial Intelligence • Consumer Web • Digital Media • Information Technology • Social Impact • Software
In-Office or Remote
60 Locations
250 Employees

Circle Logo Circle

Principal, Creative Producer

Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
In-Office or Remote
25 Locations
1050 Employees
173K-223K Annually

Circle Logo Circle

Senior Analyst, AML Investigations

Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
In-Office or Remote
25 Locations
1050 Employees
98K-116K Annually

Circle Logo Circle

Senior Manager, Engineering - Onboarding

Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
In-Office or Remote
25 Locations
1050 Employees
218K-264K Annually

Similar Companies Hiring

MassMutual India Thumbnail
Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana
Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account