The Role
Execute large-scale data platform migrations to Snowflake, adapting approximately 1,000 datasets and existing pipelines. Develop, test, schedule, and monitor reliable Apache Airflow workflows while supporting migrations from Airflow 2 to 3, Confluent regions, and Iceberg. Use Python, advanced SQL, Spark, Kafka, AWS S3, and Snowflake data modeling to ensure data quality, performance, and reliability throughout the modernization effort.
Summary Generated by Built In
AgileEngine is an Inc. 5000 company that creates award-winning software for Fortune 500 brands and trailblazing startups across 17+ industries. We rank among the leaders in areas like application development and AI/ML, and our people-first culture has earned us multiple Best Place to Work awards.
WHY JOIN US
If you're looking for a place to grow, make an impact, and work with people who care, we'd love to meet you!
ABOUT THE ROLE
We are looking for a Data Engineer to execute large-scale data platform migrations to Snowflake and support reliable Airflow workflows.
MUST HAVES
- Strong software engineering fundamentals.
- 3+ years of hands-on Python development experience.
- Advanced SQL, including complex joins, CTEs, window functions, and performance tuning.
- Snowflake data modeling.
- Apache Airflow — developing and testing pipelines in Airflow and Python.
- Apache Kafka.
- Apache Spark, including hands-on PySpark experience.
- Iceberg and Parquet data formats.
- AWS experience, particularly S3 (data lakes, partitioning, and lifecycle policies).
- Testing strategy experience, with the ability to hands-on debug and test code.
- At least 2 years of industry experience working with large-scale datasets, including Airflow and Spark.
- Overlap until 12 PM Pacific Time.
- Upper-intermediate English level.
NICE TO HAVES
- Hands-on experience with Snowflake migrations (data warehouse modernization, performance and cost optimization).
- Experience with Apache Airflow migrations (version upgrades, executor changes, or platform migrations).
- Experience using AI tools for development.
WHAT YOU WILL DO
- Work embedded within the data engineering function, partnering closely with the data platform team to support a large-scale data platform modernization effort.
- Execute the migration of approximately 1,000 datasets to Snowflake.
- Adapt existing pipelines to Snowflake, following the core architecture and technical approach defined by the internal team.
- Ensure data quality and reliability throughout the migration process.
- Support workflow scheduling and monitoring in Apache Airflow 3.
- Execute time-sensitive migrations, including Airflow 2 to 3, Confluent region migration, and the move to Iceberg.
- Help accelerate the migration initiatives targeted for completion by the end of March 2027.
PERKS AND BENEFITS
- Professional growth: Mentorship, TechTalks, and personalized growth roadmaps.
- Competitive compensation: USD-based pay with education, fitness, and team activity budgets.
- Exciting projects: Modern solutions with Fortune 500 and top product companies.
- Flextime: Flexible schedule with remote and office options.
Meet Our Recruitment Process
Application → Coding Challenge → Video Interview → Technical Interview or Hiring Manager Interview
Each step helps us understand your skills and overall fit.
If it’s a match, you’ll receive an offer.
Skills Required
- Strong software engineering fundamentals
- 3+ years of hands-on Python development experience
- Advanced SQL, including complex joins, CTEs, window functions, and performance tuning
- Snowflake data modeling experience
- Apache Airflow development and testing experience with Airflow and Python
- Apache Kafka experience
- Apache Spark and hands-on PySpark experience
- Experience with Iceberg and Parquet data formats
- AWS experience, particularly Amazon S3, data lakes, partitioning, and lifecycle policies
- Testing strategy experience, including hands-on debugging and code testing
- At least 2 years of industry experience working with large-scale datasets, including Airflow and Spark
- Availability for work overlap until 12 PM Pacific Time
- Upper-intermediate English proficiency
- Hands-on Snowflake migration experience, including data warehouse modernization and performance or cost optimization
- Apache Airflow migration experience, including version upgrades, executor changes, or platform migrations
- Experience using AI tools for development
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
AgileEngine is a privately held company established in 2010 that builds dedicated teams of designers and developers. We turn good ideas into awesome software that people actually want to use. Some of the biggest names and the hottest startups around the world chose us to build their tech.
