Jodi Schutz
Grand Rapids,MI
Summary
Detail-focused data analyst with 14 years of experience creating and presenting data visualizations that drive actionable next steps to achieve company goals. Strong business and analytics thought partner to leverage data to tell accurate and motivating stories. Proven ability to lead through change and quickly scale new tools.
Overview
27
27
years of professional experience
Work History
Data Analyst 1&2
Farmers Insurance Company
Caledonia, Michigan
01.2010 - 09.2024
- Gather data from multiple sources to identify and translate trends into simple and impactful presentations utilizing multiple visualization tools.
- Timely converted 6 Tableau dashboards to Power BI, while working with business to improve efficiency and effectiveness.
- Responsible for onboarding new hires and mentoring junior analysts. Not only improved time to proficiency from 6 to 3 months, but also sharing of knowledge with understanding of outputs.
- Implemented at least 3 process improvements annually that resulted in increase of team's delivery time. One Implementation yielded increase of 80% and improved accuracy of 60%.
- Liaison between customers and leadership, being primary link that proactively listens and effectively communicates back needs of intended users. Example of this, during demonstration to sales team, it was communicated there was lack of visibility of policies sold and was frustrating and time consuming to reconcile. Took this information back to leadership which resulted in new dashboards that yielded less frustration and added time back to increase premium growth for company.
- Acted as Inside Sales Reporting team lead, guiding 10 analysts to increase time to delivery by 14 days. Team was able to create 7 impactful dashboards that helped in performance management.
- Created and executed validation processes and used trouble shooting skills to find, and correct, data discrepancies. This resulted not only in improved data accuracy but also increased confidence from our stakeholders.
- Led cross-functional collaboration improving data-informed decision making through proactive data integrity and accuracy validation.
- Based on customer needs, produced monthly reports using advanced Excel spreadsheet functions rather than creating new Power BI dashboards. This allowed less time to move to production and gave customer desired functionality.
- Safe Agile trained and acting Scrum Master for team.
Executive Administrative Assistant
Farmers Insurance Company
Caledonia, Michigan
01.2008 - 01.2010
- Organized a high demand schedule while managing daily tasks for an Executive team,
- Presented new processes and deciphered reports and analytics to business partners.
- Maintained confidentiality when handling sensitive information, protecting company interests and employee privacy.
- Handled administrative tasks efficiently; allowing executives to focus on high-priority responsibilities without distraction.
- Managed budgets and expenses for Specialty Billing and Specialty Service teams, maintaining financial records for accurate reporting and analysis.
Retention Specialist
Farmers Insurance Company
01.1998 - 01.2008
- Call center experience working directly with out-bound calls to customers to retain revenue, prevent cancellations.
- Gathered feedback from departing customers to identify areas for improvement in products or services offered.
- Enhanced customer satisfaction levels with proactive communication and timely resolution of issues.
- Audited customer records to ensure accuracy of information and coverages.
Education
Bachelor’s Degree - Business Administration
Cornerstone University
Grand Rapids, MI12.2012
Skills
Excel Functions
SQL
Toad for Oracle
Mainframe SAS
SAS EG
Snowflake
Data Cleaning and Validation
Analytical Problem Solving
Tableau
PowerPoint
Power BI
Power BI Workspaces
Microsoft Access
Procedural Documentation
Yellow Belt Training
Prosci Change Practitioner Certified
Timeline
Data Analyst 1&2
Farmers Insurance Company
01.2010 - 09.2024
Executive Administrative Assistant
Farmers Insurance Company
01.2008 - 01.2010
Retention Specialist
Farmers Insurance Company
01.1998 - 01.2008
Bachelor’s Degree - Business Administration
Cornerstone University