Data Engineer: Snowflake, Airflow & CDC Specialist (Contract)

Aptonet; New York (NY); On-site; USD 90,000 - 120,000; Part time

Job summary

A leading data solutions company is seeking a skilled Data Engineer to design and maintain data pipelines and architectures. The ideal candidate will have 3–6 years of experience with Snowflake and Apache Airflow, focusing on data governance and ETL processes. This is a mid-senior level contract position based in New York, with collaborative opportunities across various teams in technology and analytics.

Qualifications

• 3–6 years of professional experience in data engineering or a closely related field.
• Proven hands-on experience with Snowflake.
• Strong experience implementing Change Data Capture (CDC) pipelines.
• Proficiency with Apache Airflow or similar orchestration frameworks.
• Advanced SQL skills and proficiency in Python or another programming language.
• Solid understanding of data modeling and data warehousing best practices.
• Experience working in cloud environments (AWS, Azure, or GCP).

Responsibilities

• Design, develop and operate batch and near-real-time data ingestion pipelines.
• Build and manage orchestration workflows using Apache Airflow.
• Utilize Snowflake as the core data warehouse platform.
• Develop and maintain ETL/ELT processes.
• Design and implement scalable data models.
• Monitor and improve data platform performance.
• Collaborate with cross-functional stakeholders.
• Implement best practices for data governance.
• Stay up to date with emerging data engineering tools.

Skills

Snowflake

Apache Airflow

SQL

Python

Change Data Capture (CDC)

Data modeling

ETL/ELT patterns

Cloud environments (AWS, Azure, GCP)

Problem-solving skills

Communication skills

Job description

A leading data solutions company is seeking a skilled Data Engineer to design and maintain data pipelines and architectures. The ideal candidate will have 3–6 years of experience with Snowflake and Apache Airflow, focusing on data governance and ETL processes. This is a mid-senior level contract position based in New York, with collaborative opportunities across various teams in technology and analytics.