Data Engineer

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

Job Title

Data Engineer

Interview Process

3 rounds – technical interview will be in person

About the Role

We are seeking a highly skilled Data Engineer to design, build, and maintain reliable data pipelines and architectures that empower analytics, BI, and data science teams. The ideal candidate will be hands‑on with Snowflake, Airflow, and modern CDC techniques to ensure data is accurate, timely, and scalable.

This role will require close collaboration across teams — including product, analytics, and engineering — to translate complex business needs into robust technical solutions.

Key Responsibilities

• Design, develop and operate batch and near-real-time data ingestion pipelines leveraging CDC from multiple source systems.
• Build and manage orchestration workflows using Apache Airflow, including DAG design, dependencies, recoverability, and alerting.
• Utilize Snowflake as the core data warehouse platform: schema design, query optimization, partitioning, clustering, cost monitoring, and access control.
• Develop and maintain ETL/ELT processes to deliver clean, well‑structured datasets for downstream consumption.
• Design and implement scalable data models (dimensional, data vault, etc.) aligned with business domains.
• Monitor and improve data platform performance, reliability, and cost efficiency.
• Collaborate with cross‑functional stakeholders to understand requirements, support analytics initiatives, and provide high‑quality data solutions.
• Implement best practices for data governance, documentation, lineage, and data quality.
• Stay up to date with emerging data engineering tools and technologies to continuously improve architecture and processes.

Required Qualifications

• 3–6 years of professional experience in data engineering or a closely related field.
• Proven hands‑on experience with Snowflake, including data warehouse design, performance tuning, and security.
• 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, ETL/ELT patterns, and data warehousing best practices.
• Experience working in cloud environments (AWS, Azure, or GCP).
• Strong problem‑solving skills, attention to detail, and a collaborative mindset.
• Excellent communication skills with the ability to translate business needs into technical solutions.

Seniority level

Mid‑Senior level

Employment type

Contract

Job function

Information Technology

Industries

Staffing and Recruiting