remote
Senior Data Engineer / ETL Developer - Coca-Cola Consolidated, Inc.
Data Engineer
Senior Data Engineer responsible for designing, building, and maintaining scalable ETL pipelines on AWS, leveraging Python, SQL, Airflow, and Snowflake to deliver reliable data solutions.
About the role
Key Responsibilities
- Design, develop, and maintain high‑performance ETL pipelines to ingest, transform, and load data from multiple sources into cloud data warehouses.
- Implement and manage workflow orchestration using Apache Airflow, ensuring reliable scheduling, monitoring, and error handling.
- Collaborate with data analysts, scientists, and business stakeholders to understand requirements and translate them into scalable data models.
- Optimize SQL queries and data models for performance, cost efficiency, and scalability in Snowflake and other cloud platforms.
- Apply best practices for data quality, governance, and security within AWS services (S3, Redshift/Snowflake, Lambda, Glue).
- Mentor junior engineers, conduct code reviews, and contribute to continuous improvement of the data engineering stack.
Requirements
- 5+ years of professional experience in data engineering or ETL development.
- Strong proficiency in Python and SQL for data manipulation and pipeline development.
- Hands‑on experience with AWS services (S3, EC2, Lambda, Glue) and cloud data warehouses such as Snowflake or Redshift.
- Expertise in workflow orchestration tools, preferably Apache Airflow.
- Solid understanding of data modeling, data warehousing concepts, and performance tuning.
Skills
pythonsqlawsairflowsnowflake