Auto BI Data Analyst

American Family Insurance Group; Madison (WI); Hybrid; USD 69.000 - 115.000; Vollzeit

Benefits dieser Stelle

Relocation support

New Employee Orientation

Comprehensive medical, dental, vision

401(k) contribution

Pension plan

Annual incentive

9 paid holidays

Paid time off 23 days

Student loan repayment program

Paid-family leave

Zusammenfassung

American Family Insurance Group seeks an Auto BI Data Analyst to enable faster, trusted Auto data access and scalable self-service BI solutions. You will translate business needs into data requirements, guide KPI definitions, and partner with data governance to standardize datasets. This hybrid role requires ~10 days/month in multiple U.S.

offices and relocation flexibility where needed. Responsibilities include owning analytics initiatives, building dashboards, and supporting enterprise

Qualifikationen

• 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

Aufgaben

• 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 all digital analytics programs through various platforms
• Support and execute the analytical needs throughout the enterprise
• Process, manipulate, and investigate large and complex datasets
• Explore data to identify new attributes and determine best approach to address business issues
• Develop tools or dashboards to monitor and evaluate performance
• May be requested to complete other assignments or participate in projects

Kenntnisse

Customer-driven solutions

Forecasting techniques

Statistical analysis

Advanced Excel

SQL coding

AI capabilities

Tools

Tableau Cloud

Claude

Data Studio

Jobbeschreibung

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

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

Travel requirements up to 10%

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 [e-mail] to request a reasonable accommodation.

#LI-RS1
American Family Insurance, based in Madison, Wis., has been serving customers since 1927. We inspire, protect and restore dreams through our insurance products, exceptional service from our agency owners and employees, community investments and creative partnerships. American Family Insurance is the nation’s 12th-largest property/casualty insurance company, ranking No. 202 on the Fortune 500 list. American Family has a current 'a+' credit rating through AM Best, and has distinction as a "Standing the Test of Time" company, which is represented by having an AM Best financial strength rating of 'A' or better for at least 75 years. The company offers American Family-brand products through a network of exclusive agency owners as well as nationwide through key strategic partnerships. American Family Insurance also includes Homesite and Main Street America Insurance. The company has approximately 10,500 employees nationwide.

Join our Talent Community