Data Analyst

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 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 View email address on click.appcast.io to request a reasonable accommodation.