Lead Strategic Partnership Data Analyst (Hybrid)

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

Benefits offered by this job

Comprehensive medical, dental, and vision benefits

401(k) contribution

Pension plan

Annual incentive

Paid time off (23 days)

Job summary

American Family Insurance Agency Staff is seeking a Lead Strategic Partnership Data Analyst to turn data into actionable insights. In this hybrid role, you'll work with account executives, data engineers, and finance to create advanced data visualizations and execute data analysis that drives performance.

The ideal candidate has strong SQL and data visualization skills and will be involved in business analysis and reporting. Benefits include comprehensive health coverage and a competitive 401(k).

Qualifications

• Experience analyzing customer journeys across web and digital channels.
• Strong experience with data analysis tools.
• Ability to travel up to 10%.

Responsibilities

• Conduct business analysis to drive decisions using statistical modeling.
• Collaborate with stakeholders for key performance metrics.
• Develop automated reporting solutions.

Skills

Big Query/SQL script writing

Data visualization with Tableau

Statistical analysis and forecasting techniques

Data tools like R and Python

Job description

Description

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 of the following locations: 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 Query/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.

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

Benefits

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.

Equal Opportunity and Employment

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.

Accommodation Statement

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.