About Me

Hello! I'm Scott Saenz, a Senior Data Engineer with a passion for data quality, analytics, and building scalable solutions. Over the years, I've gained extensive experience in data engineering, business intelligence, and data science, working with a variety of tools and technologies.

Professional Experience

Senior Data Engineer

USAA · Full-time
Feb 2021 - Present (4 yrs 3 mos)
- Led the development of a high-throughput AWS data pipeline ingesting 5,000+ files per hour, reducing costs by 55%. - Utilized AWS services including S3, DynamoDB, SQS, IAM, KMS, Secrets Manager, Step Functions, and Terraform. - Upskilled partner teams on AWS, increasing standardization across the organization. - Implemented robust unit tests in dbt for automated regression testing, enhancing data reliability. - Designed and executed a scalable third-party ingestion pipeline for seamless vendor data integration. - Reengineered ETL workflows to identify bottlenecks and optimize performance.

Instructor - Data Analytics/Visualization

2U · Part-time
Nov 2022 - Jun 2023 (8 mos)
- Remote instruction on data analytics and visualization concepts.

Sr. DW/BI Engineer

Little Caesars Pizza · Full-time
Jun 2020 - Feb 2021 (9 mos)
- Established CI/CD processes using Tabular Editor for Azure Analysis Services, enabling collaborative model development. - Assisted in migrating from on-premises to cloud data warehouse using Azure Data Factory, Databricks, and PySpark. - Developed mobile-friendly Power BI KPI reports for C-level stakeholders.

Data Scientist

Ford Motor Company · Full-time
Nov 2019 - Jun 2020 (8 mos)
- Built a computer vision model in Python/TensorFlow to identify critical portions in CAD drawings, streamlining Bill of Materials exports. - Automated CAE reports with custom Python scripts, reducing processing time from 4 hours to 15 minutes. - Automated repetitive analytical tasks using Python, significantly improving efficiency.

Quicken Loans

5 yrs 2 mos
- Senior BI Engineer
May 2019 - Nov 2019 (7 mos)
- Developed Power BI reporting standards for 200+ content creators. - Implemented SQL templates for KPI reporting and created Azure Analysis Services KPI models with CI/CD. - Ensured CCPA compliance by updating 50+ SQL objects for client privacy. - Led migration of 110 SSIS jobs to SQL Server 2016 and transitioned source control to Git. - Provided SQL performance tuning training to 52 engineers and created training for 40+ engineers during system transitions. - BI Engineer
Mar 2018 - May 2019 (1 yr 3 mos)
- BI Developer
Mar 2017 - Mar 2018 (1 yr 1 mos)
- Created a framework for upgrading SSIS jobs and implemented continuous deployment for internal C# apps. - Business Analyst
Jan 2015 - Mar 2017 (2 yrs 3 mos)
- Gathered requirements and collaborated on SQL scripts in Agile teams. - Developed Tableau dashboards and internal training, and administered Tableau Server, resolving critical issues.

Skills & Expertise

• Programming & Tools: Python, SQL, dbt, Snowflake, Terraform, AWS (Lambda, SQS, DynamoDB, Step Functions, S3), Azure Data Factory, Databricks, PySpark, Git
• Business Intelligence: Power BI, Tableau, SQL Server, Azure Analysis Services
• Data Engineering: ETL development, data pipeline design, big data processing, data modeling, performance tuning, automated testing
• Other: CI/CD, cloud migrations, stakeholder collaboration, training and mentoring

Education

MS, Applied Data Science
Syracuse University 2021

BS, Community Development
Central Michigan University 2018