Erik Farmer

About Me

I am a Senior Data Engineer and Technical Lead with over 10 years of experience in designing scalable data systems, developing ETL pipelines, and leading cross-functional teams to deliver impactful solutions. Passionate about optimizing data workflows, mentoring others, and driving technical excellence.

Recent Experience

Senior Data Engineer & Team Lead, PepsiCo

March 2020 - Present

Led the Supply Chain eCommerce team (8 contractors, 4 FTEs); mentored junior engineers through code reviews, design sessions, and pair programming—contributing to 3 promotions.
Built and maintained 30+ ETL pipelines across multiple third-party systems, expanding data coverage by 60% and enabling deeper business insights from 500k+ daily records.
Collaborated with business stakeholders to design data models that improved fill rate and fulfillment SLAs, supporting a 10% YoY increase in eCommerce sales.
Established testing frameworks and standardized code review practices, reducing production defects by 70% and improving delivery velocity by 20% (measured via JIRA).
Optimized Airflow DAG performance, reducing end-to-end pipeline execution time by 20%.

Senior Data Engineer, Clover Health

March 2018 - Feb 2020

Tech lead for vendor integration, ETL, and data integrity initiative resulting in $10MM+ annual savings.
Worked cross-functionally with analysts, PMs, and product stakeholders to define goals and deliver timely releases.
Expanded testing capabilities by developing end-to-end validation for modular SQL pipelines—improving data quality and developer confidence across teams.
Led forward-looking initiatives on future tech stack evaluation and engineering standards.
Mentored junior developers through code reviews, career planning, and communication coaching.

View full experience on LinkedIn

About Me

Recent Experience

Senior Data Engineer & Team Lead, PepsiCo

Senior Data Engineer, Clover Health

Core Skills

Contact Me