Entry Level Excel Data Analyst Jobs in Madison, WI

The Lead Data Insights Analyst directly supports Technology leaders in achieving their financial, workforce, and operational objectives by transforming complex data into actionable insights. This role is responsible for strengthening Technology Performance Insights' data and reporting capabilities through data modeling, process improvement, automation, and scalable analytical solutions. You will connect data across financial, capacity, and operational domains to uncover performance drivers, frame tradeoffs, and translate complex information into clear, compelling narratives that help leaders understand what is changing, why it matters, and where to focus decisions and action. You will report to the Senior Manager, Corporate Financial Planning & Analysis.
In this flex office/home role, you will be expected to work a minimum of 10 days per month from 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:

$99,000.00 - $167,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 work with business partners in the development and delivery of key performance analysis and reporting.
• You will build and maintain various models used to project business results; enhancing the model where there is business value in adjusting the models.
• You will ensure analysis and reporting accuracy and integrity and explain performance drivers and provide insights into performance trends.
• You will create, execute and maintain forecasting models; speaks to the underlying assumptions and inter-workings of the model used to create the forecast.
• You will communicate findings to various stakeholders and leadership with recommendations for actions to address business changes, trends, and issues.
• You will evaluate, design, test and maintain data/analytics systems and make recommendations for new tools and system enhancements.
• You will develop, test, and deploy complex automated reporting solutions and automated decision analytics to replace manual business processes.
• You will develop and define standard analytics and reporting governance and communication and ensure adherence to standards.
• 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.
• Solid knowledge and understanding of forecasting techniques or statistical analysis or data modeling or data mining.
• Demonstrated experience utilizing software tools to query and report data.
• Demonstrated experience with a variety of standard reporting software packages and best practices for report deployment processes.
• Demonstrated experience communicating/presenting complex and independent concepts and unbiased fact-based decision-making and financial performance.
• Demonstrated experience developing complex data sets for wide-spread use.

• 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

Additional Qualifications

• Experience in extracting and consolidating data from multiple sources and platforms into GCP
• Experience migrating data from Excel to Tableau Cloud
• Experience providing robust business insight via data storytelling

#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.

#LI-RS1