Scott Saenz
Rockford
Summary
Data engineering professional poised to add significant value through comprehensive experience in developing scalable data solutions. Noted for strong team collaboration and adaptability in fast-paced environments. Reliable in driving results with key skills in data modeling, ETL processes, and cloud-based data platforms.
Overview
11
11
years of professional experience
Work History
Senior Data Engineer
USAA
02.2021 - Current
- Led the development a data pipeline in AWS that ingested of 5k files/hr while reducing costs by 55%
- Utilized S3, Dynamo DB, SQS, IAM, KMS, Secret Manager, Step Functions, and Terraform
- Upskilled other developers on partner teams on AWS; increasing standardization across org
- Implemented robust unit tests in dbt, ensuring automated regression testing for tier 1 reports and enhancing data reliability.
- Designed and executed a scalable third-party ingestion pipeline, facilitating the seamless integration of vendor data in various formats into our analytical environment.
- Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
Senior Data Warehouse/BI Engineer
Little Caesars
06.2020 - 02.2021
- Setup CI/CD process utilizing Tabular Editor for Azure Analysis Services
- Enabled multiple people to work on model while avoiding merge conflicts
- Assisted with migrating from on-prem to cloud DW utilizing Azure Data Factory, Databricks, and pySpark
- Created Power BI mobile-friendly KPI report for C-level stakeholders
Data Scientist
Ford Motor Company
11.2019 - 05.2020
- Created a computer vision machine learning model using Python with tensor flow to identify critical portions in CAD drawings. Used to bulk export Bill of Materials for a project
- Automated CAE reports by creating custom Python scripts to utilize VCollab’s API – resulted in a reduction of time from 4 hours to 15 minutes
- Automated repetitive tasks using Python, saving time during the analytical process significantly.
Senior BI Engineer
Quicken Loans Inc.
03.2017 - 11.2019
- Created Power BI reporting standards to ensure reports have a consistent branding for 200+ content creators
- Implemented a SQL template for adding KPIs for C-level reporting. The template allowed for any measure to easily be added to reporting solution
- Created an Azure Analysis Services KPI model using CI/CD with GitHub actions
- Ensured compliance with CCPA by updating over 50 SQL objects. Objects were changed to ensure clients could be removed from the system or de-identified upon a client’s request to prevent unwanted marketing (direct mail, e-mail, and phone calls).
- Provided insight into operational inefficiencies by creating an SSAS tabular model based off of Kimball data warehousing methodology
- Transformed source control to GIT to enable future CI/CD
- Created training to ensure a smooth transition for 40+ engineers
- Created a framework for upgrading 110 SSIS jobs from SQL Server 2008 R2 to SQL Server 2016 before Microsoft's end-of-life support lapsed
- Implemented continuous deployment for C# app that handled internal asynchronous messages (similar in functionality to Kafka)
- Discovered internal bad-practices regarding T-SQL query performance and taught a SQL performance tuning class for 52 engineers
BI Business Analyst
Quicken Loans Inc.
10.2014 - 03.2017
- Gathered requirements from stakeholders and collaborated with engineers on SQL scripts within an Agile environment.
- Created Tableau dashboard on clients’ complaints, allowing stakeholders to change processes to ensure a smoother, more reliable process for the clients
- Created an internal Tableau training class to ensure new hires can implement our standards and hit the ground running
- Tableau Server Admin - Determined source of bug after upgrading Tableau server and implemented short-term fixes while awaiting patch to become available
- Solved and implemented fixes in consultation with Tableau support regarding severe server degradation
Education
MS - Applied Data Science
Syracuse University
09.2021
Skills
- Git version control
- ETL development
- Big data processing
- Python programming
- Data pipeline design
- Data modeling
- Performance tuning
- Advanced SQL
- Business intelligence
Timeline
Senior Data Engineer
USAA
02.2021 - Current
Senior Data Warehouse/BI Engineer
Little Caesars
06.2020 - 02.2021
Data Scientist
Ford Motor Company
11.2019 - 05.2020
Senior BI Engineer
Quicken Loans Inc.
03.2017 - 11.2019
BI Business Analyst
Quicken Loans Inc.
10.2014 - 03.2017
MS - Applied Data Science
Syracuse University
Similar Profiles
Brandin M. SullivanBrandin M. Sullivan
Life, Health, and Annuities Agent at USAALife, Health, and Annuities Agent at USAA
Virgilia BurrillVirgilia Burrill
Claims Adjuster at USAAClaims Adjuster at USAA
JUAN CARLOS OSUNAJUAN CARLOS OSUNA
Loan Officer at USAALoan Officer at USAA
Antanae BrownAntanae Brown
Short Term Disability Claims Specialist at USAAShort Term Disability Claims Specialist at USAA
Benito JassBenito Jass
Banquet Server at Embassy SuitesBanquet Server at Embassy Suites