Lead Strategic Partnership Data Analyst (Hybrid)

American Family Insurance; Boston (MA); Hybrid; USD 111,000 - 189,000; Full time

Benefits offered by this job

Comprehensive medical, dental, vision, and wellbeing benefits

Competitive 401(k) contribution and a pension plan

Annual incentive award

Paid time-off program (23 days annually)

Job summary

American Family Insurance is seeking a Lead Strategic Partnership Data Analyst to turn data into actionable insights supporting National Accounts. This hybrid role involves creating data visualizations and presenting findings to leadership. Candidates must have strong communication skills and experience in data analysis, particularly with Big Query, SQL, R, and Python.

The position offers a competitive compensation range of $111,000 to $189,000, along with comprehensive benefits including medical, dental, vision, and a pension plan.

Qualifications

• Experience with Big Query and SQL scripting.
• Strong skills in data analysis and reporting.
• Ability to develop automated reporting solutions.

Responsibilities

• Conduct accurate and timely business analysis.
• Collaborate with key stakeholders for performance monitoring.
• Build and maintain models for projecting business results.

Skills

Big Query / SQL script‑writing experience

Insurance product and pricing domain knowledge

Forecasting techniques or statistical analysis

Data tools such as R and Python

Data visualisation with BI tools

Standard reporting software packages

Tools

Tableau

Data sets development

Job description

Job Overview

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 create advanced data visualisation and executive‑ready presentations, translating complex findings into clear stories and dashboards for leadership audiences. The role partners closely with account executives, data engineers and finance, requiring strong communication skills at both technical and business levels. The analyst reports to the Senior Manager, Data Analytics and works in a hybrid office/home setup, with a minimum of 10 days per month expected in one of two locations: Madison, WI 53783 or Boston, MA 02110.

Primary Accountabilities

• Conduct accurate and timely business analysis and reporting to support and drive business decisions using statistical modelling and other business analysis tools.
• Collaborate with key stakeholders to define key financial and operational metrics to continuously monitor, track, and report performance.
• Collaborate with business partners in the development and delivery of key performance analysis and reporting.
• Build and maintain models used to project business results and enhance the models where there is business value in adjusting them.
• Ensure analysis and reporting accuracy and integrity, explain performance drivers, and provide insights into performance trends.
• Analyse and address data quality issues, test and analyze the impact of system changes to data/reporting infrastructure.
• Develop, test and deploy automated reporting solutions and automated decision analytics to replace manual business processes.
• May be requested to complete other assignments or participate in projects based on skills, achievements, or experience.

Qualifications

• Big Query / SQL script‑writing experience required.
• Insurance product and pricing domain knowledge.
• Solid knowledge and understanding of forecasting techniques or statistical analysis.
• Strong experience utilizing data tools such as R and Python to build complex formulas and create reports.
• Data visualisation experience with BI tools such as Tableau.
• Knowledge of a variety of standard reporting software packages and best practices for report deployment processes.
• Experience developing data sets.
• Experience providing customer‑driven solutions, support or service.
• Willingness and ability to travel up to 10%.

Additional Qualifications

• Experience analysing the customer journey across web, digital, and contact‑centre distribution channels.
• Experience using data to understand and optimise 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 modelling, and AI‑enabled tools.

Additional Information

All employees participate in a New Employee Orientation during their first week, which takes place in person at our Madison, WI headquarters or one of our core locations, and may also be delivered virtually as scheduling permits. Offers to selected candidates are contingent on background checks and the signing of a non‑disclosure agreement for proprietary information, trade secrets, and inventions. Sponsorship will not be considered for this position unless specified in the posting.

Benefits

• Comprehensive medical, dental, vision, and wellbeing benefits.
• Competitive 401(k) contribution and a pension plan.
• Annual incentive award.
• 9 paid holidays and a paid time‑off program (23 days accrued annually for full‑time employees).
• Student loan repayment program.
• Paid‑family leave.
• Position compensation range: $111,000.00 – $189,000.00.

EEO Statement

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.