About

Andrew Therin is an experienced Lead Data Engineer with over 10+ years of specialization in ETL. He has been managing and coaching data engineering teams for a long time and is always on the lookout for new growth and learning opportunities. Andrew is currently working at FloSports as a Lead Data Engineer, where he has established an in-house ETL platform to replace several pipelines from various languages such as Python 2, Python 3, and PHP. He has reduced Redshift disk space usage by over 50% through a data lake to mitigate AWS expenses and has optimized and automated data warehousing workflows to trim runtimes by ~2 hours on average. Andrew has an impressive track record of refactoring internal workflows and codebase from Redshift, Athena, and Spectrum to Snowflake. He introduced an audit process to compare nightly builds by dogfooding internal reports and implemented PagerDuty across all DE codebases to standardize response processes. Andrew has also automated DAG generation to optimize which tables can be built in parallel and in what order. He migrated workflows to Airflow for additional control and granularity with job orchestration and leveraged Snowflake to replace replication costs for dev/staging/BI environments. Prior to joining FloSports, Andrew worked at Civitas Learning as a Lead Data Engineer, where he optimized Jenkins workflows for data extraction and application deployment for 50+ institutions. He expanded ETL/DML/DDL through an in-house Python framework and AWS services and supported and created additional functionality for an in-house data validation web app (Veritas). Andrew integrated both standard and custom SIS/LMS client solutions to their internal data mappings and led a team of data engineers to decrease client backlog by over 30%. He also prototyped a parallel group mapping process to expedite ETL, reducing turnaround from months to weeks. Andrew's past experience also includes working as a Senior Associate at Deloitte, where he managed DML and ETL operations for ESI within InfoDox repositories and Relativity workspaces. He provided eDiscovery services for federal agencies (productions, reunitizations, blowbacks, etc.) and expanded a PowerShell-based automated environment to streamline litigation support for ESI. Andrew coordinated metrics through SSRS/Tableau/Excel for a wide range of cases (Internal Operations, Medicare, LTHD, Fraud, etc.). Andrew graduated from the Texas McCombs School of Business with a BBA in Finance in 2008. He has a strong tech stack