Eric Smith
NYC Metro Area,NJ
Summary
Data Engineer with 4+ years of experience building and maintaining scalable ETL/ELT pipelines and cloud-based data platforms. Strong experience with Apache Airflow, dbt, Snowflake, and AWS. Proven ability to improve data reliability, automate workflows, and support production analytics systems.
Overview
11
11
years of professional experience
Work History
Data Engineer
IMG Academy
Remote
05.2022 - Current
- Designed and maintained ETL/ELT pipelines using Apache Airflow and Fivetran to ingest and process data from external APIs and internal systems
- Built and optimized data warehouse solutions in Snowflake and AWS Redshift, developing dbt models for analytics and reporting
- Implemented CI/CD pipelines using GitHub Actions to automate deployments and enforce code quality standards
- Developed and maintained AWS-based data infrastructure using MWAA, S3, Redshift, DMS, EC2, and Secrets Manager
- Improved data pipeline reliability through workflow scheduling, monitoring, and error handling within Airflow
Senior Data Analyst (Data Engineering Focus)
Epsilon Data Management, LLC
Chicago, IL
02.2018 - 05.2022
- Built automated data pipelines using Python and Apache Airflow to replace manual data processing workflows
- Developed reusable Python libraries to standardize interactions with APIs and PostgreSQL databases
- Designed and implemented data workflows integrating Airflow, Jira, and database systems to support production operations
- Created data auditing and change tracking processes for PostgreSQL databases to improve data integrity and troubleshooting
- Collaborated with cross-functional teams to translate business requirements into scalable data pipeline solutions
Software Implementation Consultant
DealerSocket, Inc.
Minneapolis, MN
06.2015 - 02.2018
- Mastered technical aspects of complex CRM software and independently communicate key insights to non-technical client leadership in fast-paced environment
Education
Bachelor of Arts - Economics
University of Illinois At Urbana-Champaign
Champaign, IL05-2015
Skills
TECHNICAL SKILLS
Languages: Python, SQL
Data Engineering: ETL/ELT, Apache Airflow, dbt, Fivetran, Data Modeling, Data Warehousing
Cloud Platforms: AWS (S3, MWAA, Redshift, DMS, EC2, Secrets Manager), Snowflake
Tools & DevOps: Git, GitHub Actions, Docker, Terraform, CI/CD
Timeline
Data Engineer
IMG Academy
05.2022 - Current
Senior Data Analyst (Data Engineering Focus)
Epsilon Data Management, LLC
02.2018 - 05.2022
Software Implementation Consultant
DealerSocket, Inc.
06.2015 - 02.2018
Bachelor of Arts - Economics
University of Illinois At Urbana-Champaign