Hunter A. May
Education
Drake University
Bachelor of Science — Double Major in Computer Science & Data Analytics
Des Moines, IA
Professional Experience
The Mutual Group|Data Engineer
June 2023 – Present
Des Moines, IA
- •Architected and maintain multi-step ETL pipelines supporting Actuarial Reserving, Accident Year analysis, state filing, and the full Technical Pricing model across all Lines, Coverages, and transactions
- •Built a web application for the Underwriting team's renewal process — users pull live GuideWire account data, enter their inputs, and write results back to the analytics database, replacing a fully manual data entry Excel workflow
- •Designed and automated an end-to-end cash forecasting pipeline for the finance team — aggregating multiple years of billing center transaction data, generating forward-looking cash receipt projections, and delivering results through a Tableau dashboard
- •Own and manage the team's EC2 server, serving as the central development environment and task scheduler for the data team
- •Own the NGINX application server — built and deployed Python and React applications running in Docker containers, providing internal interfaces for backend data interaction
- •Automated executive reporting packages, eliminating manual data entry and significantly reducing report turnaround time
GuideOne Insurance|Data Warehouse Specialist
May 2021 – June 2023
West Des Moines, IA
- •Built ETL processes across the Data Store, Data Mart, and KPI layers, coordinating directly with business stakeholders to align data delivery with reporting needs
- •Administered the Tableau Server as an admin, overseeing data source governance, refresh schedules, and user access to ensure consistent and reliable report delivery
- •Designed end-to-end data flow for the Claims department's TPA integration, including downstream reporting
- •Automated the compilation and extraction of Programs data from SharePoint, improving data quality and reclaiming significant analyst time
GuideOne Insurance|Data Management Intern
May 2020 – May 2021
West Des Moines, IA
- •Automated analyst-requested reporting workflows and backend data processes, reducing recurring manual effort across the team
- •Designed and automated a data feed for the Loss Control team, aggregating account, policy, and coverage data into a single unified view
- •Assisted in building out the Data Store, Data Mart, and KPI data pipelines alongside the core data management team
Mediacom Communications|Central Video Operations Intern
May 2019 – August 2019
Ames, IA
Technical Skills & Tools
Languages & Analytics:SQL, Python, R, Shell Scripting (Bash/PowerShell), JavaScript
Data & ETL Tools:SQL Server Tools Suite, Postgres, In-house SQL tool suite, Tableau (Admin)
Cloud & Infrastructure:AWS (EC2, Lambda, S3, Secrets Manager, IAM)
AI & Development:Claude Code, MCP, Library & Agent competence, full-stack & agentic automation workflows