Marika Lembke
Summary
Experienced Data Analyst with expertise in Python, SQL, and business intelligence visualization through Tableau dashboards. Skilled in applying advanced analytics techniques, including topic modeling, to extract insights from unstructured user feedback and deliver actionable reporting. Proven ability to build interactive dashboards and presentations that communicate trends in claims, marketing performance, and operational metrics. Completed an M.S. in Business Analytics with a foundation in mathematics and computer science.
Overview
8
8
years of professional experience
Work History
Insights & Analytics Analyst
Acuity Insurance
03.2025 - Current
- Refactored R code to a Python script, as well as rebuilt the dashboard tied to the data to streamline automation and align with department standards.
- Applied topic modeling to freeform website user responses and developed a Tableau dashboard to surface actionable insights for the Market Strategy team.
- Pulled and analyzed Google Analytics quotes data to populate Tableau dashboards, enabling the Market Strategy team to generate actionable insights
- Integrated Tableau-driven visual analytics into a Claims Overview deck to support storytelling and trend analysis across claim counts, types, lines of business, payments, and premiums.
Lead Data Analyst – Agency Data & Analytics Division
American Family Insurance
08.2023 - 03.2025
- Executed monthly updates to auto and marketing investment reports, delivering accurate performance tracking for key business initiatives
- Extracted and analyzed metrics across multiple data tables to monitor and evaluate a discount program’s effectiveness.
- Leveraged Python statistical libraries to model incentive scenarios, supporting strategic planning for agency sales target setting.
- Developed Tableau dashboards connected to on-prem SQL and Google Cloud Platform sources, embedding automated SQL-to-Python workflows to streamline policy eligibility and billing program reporting.
Business Analytics Analyst II – Internal Audit Division
American Family Insurance
05.2021 - 08.2023
- Cleaned and analyzed data using Python and Excel to create reports of anomalies and errors
- Maintained and ran quarterly Python scripts to update Tableau dashboards focused on Risk Assessment
- Created Python scripts to enhance continuous monitoring efforts defined by the auditors
- Built a Tableau dashboard to summarize key divisional metrics updated via a Python script
- Wrote SQL queries to pull data from Google Cloud Platform for fraud investigations
Software Engineer
Blue Yonder (formerly JDA Software)
06.2019 - 05.2021
- Created servers in Cloudbolt, set up configurations and installed proper software on the servers
- Analyzed graphs and outputs from the build failure analyzer to identify & troubleshoot key issues
- Improved performance & usability of internal Perl scripts by debugging and adding new features
- Triaged incoming issues and reprioritized the backlog accordingly
Data Engineer Intern
Sentry Insurance
05.2018 - 08.2018
- Developed SQL scripts that created documents needed to meet state & district requirements
- Created and updated Informatica ETL mappings, workflows, sessions and parameter files
- Proposed and presented an AI business solution as part of an Intern Competition
Education
Master of Science - Business Analytics
Drake University
01-2024
B.S - Mathematics & Computer Science
Carroll University
01-2019
Skills
- Python
- Tableau
- CloudPak
- Microsoft Excel
- SQL
- Google Analytics
- Agile Methodology
- Git Version Control
- Gitlab
Timeline
Insights & Analytics Analyst
Acuity Insurance
03.2025 - Current
Lead Data Analyst – Agency Data & Analytics Division
American Family Insurance
08.2023 - 03.2025
Business Analytics Analyst II – Internal Audit Division
American Family Insurance
05.2021 - 08.2023
Software Engineer
Blue Yonder (formerly JDA Software)
06.2019 - 05.2021
Data Engineer Intern
Sentry Insurance
05.2018 - 08.2018
Master of Science - Business Analytics
Drake University
B.S - Mathematics & Computer Science
Carroll University