Clint Epperly
West Des Moines,IA
Overview
1
1
Certification
21
21
years of professional experience
Work History
Senior Data Engineer
Holmes Murphy
Waukee, IA
09.2021 - Current
- Develop and maintain end-to-end data pipelines using Alteryx, Snowflake, Azure Logic Apps, and DBT to support critical insurance reporting, claim check processing, and TPA integrations.
- Architected and implemented Snowflake database objects to support seamless ETL processes and data warehousing requirements.
- Developed and deployed DBT data models, streamlining ETL and improving reporting capabilities within data warehouse.
- Optimized and troubleshot production ETL processes, enhancing timely data delivery for critical reporting.
- Administered and maintained Snowflake database instances, achieving high availability and optimal performance.
ETL Developer
ITA Group
West Des Moines, IA
08.2016 - 09.2021
- Developed and supported ETL solutions enhancing reporting and transactional system capabilities.
- Established direction, standards, and best practices to optimize corporate ETL processes.
- Guided development teams on ETL processes, database design, and SQL performance tuning, ensuring best practices were followed.
- Design reporting data warehouse and data marts.
- Data modeling and source to target mapping of source and destination databases.
- Work with analytics decision support team to define and provide reporting and analytics solutions for our clients.
- Troubleshoot production issues related to database and ETL processes.
- Research and recommend reporting, database and ETL software.
- Provide DBA assistance and on-call support in a secondary/backup capacity.
Database Administrator – Analytics team
Wells Fargo Consumer Credit Solutions
12.2014 - 07.2016
- Architect SQL Server Dev, UAT, and production reporting environments.
- Installed, configured, and supported SQL Server and Reporting Services to ensure reliable reporting capabilities.
- Develop, monitor, and manage ETL processes using Integration Services and SQL Server Agent.
- Managed database backup, recovery, and maintenance solutions to safeguard data integrity and availability.
- Implement database and server alerts for 24/7 monitoring.
- Performance tuning of long running SQL and batch processes.
- Architected disaster recovery and business continuity planning solutions to minimize downtime and ensure operational resilience.
Database Administrator
ITAGroup
West Des Moines, IA
10.2005 - 12.2014
- Design and support of multi-site HA/DR solution using SQL Server 2012 Availability Groups.
- Installation, configuration, and support of SQL Server 2012 and Reporting Services 2012 instances.
- Design, implementation and support of enterprise data warehouse.
- Executed database backup, recovery, and maintenance solutions to ensure data integrity and availability.
- Develop and maintain enterprise data models.
- Monitored database performance and tuned systems to optimize response times and resource utilization.
- Executed environment migrations and deployments in a 24/7 on-call setting.
- Developed and managed ETL processes using Integration Services and DTS to facilitate data integration and reporting.
- Provided technical assistance to multiple development groups for project execution.
Education
Bachelor of Arts (BA) - Marketing
University of Northern Iowa
Cedar Falls, IAAssociate of Arts (AA) -
North Iowa Area Community College
Mason City, IASkills
- Alteryx
- Snowflake
- DBT
- Python
- Salesforce
- SQL Server
- SSIS
- Azure Data Factory
- Azure Logic Apps
- Nifi
Certification
- MCDBA - Administering a SQL Server database
- SQL Server Design and Implementation
- Installing, Configuring, and Administering Windows Server
- Designing and Implementing Data Warehouses with SQL Server
Timeline
Senior Data Engineer
Holmes Murphy
09.2021 - Current
ETL Developer
ITA Group
08.2016 - 09.2021
Database Administrator – Analytics team
Wells Fargo Consumer Credit Solutions
12.2014 - 07.2016
Database Administrator
ITAGroup
10.2005 - 12.2014
Bachelor of Arts (BA) - Marketing
University of Northern Iowa
Associate of Arts (AA) -
North Iowa Area Community College