JobsAmerican Family Insurance

Lead Strategic Partnership Data Analyst (Hybrid)

American Family Insurance · MA Boston, WI

Posted Jul 1, 2026 · We last checked this listing on Sep 20, 2026

Apply at American Family Insurance

Likely interview questions for this role

Written from this job description, not a generic list. Each one notes what the interviewer is really checking.

Behavioral

Walk me through a time you had to explain a complex analysis to a non-technical executive. How did you decide what to leave out?

whether the candidate can translate technical work into a clear business story for leadership audiences

Tell me about a project where you worked closely with account executives, data engineers, and finance at the same time. What made that hard?

ability to operate credibly across technical and business stakeholders with different priorities

Give me an example of a business metric you defined from scratch because none existed yet. How did you get stakeholders to agree on it?

comfort leading ambiguous, cross-functional metric definition work rather than just executing on given specs

Tell me about a time you found a data quality issue that was affecting a report leadership relied on. What did you do?

rigor in catching and resolving data integrity problems before they mislead decisions

Tell me about a time your analysis pointed to a conclusion that stakeholders didn't want to hear. How did you handle presenting it?

willingness to deliver fact-based recommendations under pushback, not just pleasant messaging

Tell me about a time you used an AI-enabled tool in your analytics work. What did it help with and where did you still need to apply your own judgment?

practical, honest experience with AI tools rather than buzzword familiarity

Technical

Write or describe a SQL query in BigQuery that would pull monthly performance trends for a set of national accounts, joining across at least two tables. What would you watch out for?

actual fluency with BigQuery/SQL and awareness of common join or aggregation pitfalls

How would you approach building a forecasting model for a book of business, and how would you decide when it's worth updating the model versus living with its current limitations?

practical judgment on statistical modeling and model maintenance tradeoffs, not just theory

Describe a manual reporting process you automated. What tools did you use and what broke along the way?

hands-on experience building and troubleshooting automated reporting pipelines

How have you used R or Python together with SQL in a single analysis workflow? Give a specific example.

whether the multi-tool experience claimed on a resume reflects real, integrated day-to-day use

What insurance product or pricing knowledge do you bring, and how has it changed the way you approached an analysis compared to someone without that background?

depth of actual insurance domain knowledge versus generic analytics skill

Situational

Say a dashboard you built in Tableau is technically correct but the account team says it doesn't answer their real question. What do you do next?

customer-driven mindset and willingness to iterate rather than defend the original output

If you noticed customer outcomes differing significantly by channel, say web versus contact center, how would you investigate whether that's a pricing issue, a product issue, or something else?

structured thinking about customer journey analysis across distribution channels, tied to the additional qualifications

You're given a dataset that's messy, undocumented, and needed for an executive presentation in two days. Walk me through how you'd triage it.

ability to produce reliable, analysis-ready output efficiently under ambiguity and time pressure

Practice this interview out loud.

Offer builds a real interview for this exact role at American Family Insurance from your resume and this job description, asks the questions one at a time, and tells you what landed. The first one is free.

Practice this out loud

The full job description

As published by American Family Insurance.

The Lead Strategic Partnership Data Analyst turns data into clear, actionable insights that support National Accounts. You will identify what is driving performance and influence decisions with fact-based recommendations. You will also create advanced data visualization and executive-ready presentations, translating complex findings into clear stories and dashboards for leadership audiences. This role partners closely with account executives, data engineers and finance, so the ability to communicate credibly at both technical and business levels is essential for success. 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 either Madison, WI 53783 or Boston, MA 02110 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: $111,000.00 - $189,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 conduct accurate and timely business analysis and reporting to support and drive business decisions using statistical modeling and other business analysis tools. • You will collaborate with key stakeholders to define key financial and operational metrics to continuously monitor, track, and report performance. • You will collaborate with business partners in the development and delivery of key performance analysis and reporting. • You will build and maintain models used to project business results; enhances the model where there is business value in adjusting the models. • You will ensure analysis and reporting accuracy and integrity and explains performance drivers and provides insights into performance trends. • You will analyze and address data quality issues, tests and analyzes impact of system changes to data/reporting infrastructure. • You will develop, test, and deploy automated reporting solutions and automated decision analytics to replace manual business processes. • You may be requested to complete other assignments or participate in projects based upon skills, achievements, or experience. Specialized Knowledge & Skills Requirements • Big Querry/SQL script writing experience required • Insurance product and pricing domain knowledge • Solid knowledge and understanding of forecasting techniques or statistical analysis. • Demonstrated strong experience utilizing data tools such as R and Python to build complex formulas and create reports. • Data visualization experience with BI tools such as Tableau • Knowledge of a variety of standard reporting software packages and best practices for report deployment processes. • Demonstrated experience developing data sets. • Demonstrated experience providing customer-driven solutions, support or service. • Willingness and ability to travel 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 Additional Qualifications • Experience analyzing the customer journey across web and digital and contact center distribution channels. • Experience using data to understand and optimize how channel interactions and product and price decisions influence customer outcomes. • Comfort efficiently working through ambiguity to produce reliable, analysis-ready outputs. • Experience using statistical analysis, explanatory and predictive modeling, and AI-enabled tools #LI-Hybrid 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 AskHR@AmFam.com to request a reasonable accommodation.

Apply at American Family Insurance

Related jobs

Desk Adjuster

American Family Insurance · Madison, WI

Posted Sep 17 · Verified Sep 20

Lead Engineer

American Family Insurance · Madison, WI

Posted Sep 16 · Verified Sep 20

Lead Data Engineer

American Family Insurance · Madison, WI

Posted Sep 16 · Verified Sep 20

Senior Manager, Insurance Product Analytics (Hybrid)

American Family Insurance · Madison, WI

Posted Sep 15 · Verified Sep 20

Sales District Leader - South Milwaukee, WI (Primarily Field)

American Family Insurance · Milwaukee, WI

Posted Sep 10 · Verified Sep 20

Senior Network Engineer

American Family Insurance · Madison, WI

Posted Sep 9 · Verified Sep 20