Data Engineer

Role Overview

SynapOne is hiring a Data Engineer contractor for a 2-year, 100% remote role supporting the migration of ETL pipelines from Matillion to Apache Airflow. You will rebuild pipelines, improve reliability, and implement scalable, code-based data workflows.

Responsibilities

• Migrate existing ETL pipelines from Matillion to Apache Airflow, preserving logic and dependencies
• Develop and maintain Airflow DAGs with scheduling, retries, and failure handling
• Reverse engineer Matillion jobs and translate them into Python workflows
• Build and optimize data pipelines across systems such as S3, Snowflake, and relational databases
• Perform data validation and reconciliation between source and target systems
• Write and optimize SQL transformations for large-scale datasets
• Implement monitoring, alerting, and error handling for pipelines
• Collaborate with data/platform/analytics teams to support smooth migration and deployment
• Document pipelines, workflows, and operational processes

Required Qualifications

• 3+ years of experience in Data Engineering / ETL development
• Strong, hands-on experience with Apache Airflow (or similar orchestration tools)
• Proficiency in Python for data pipeline development
• Strong SQL skills with experience on large datasets
• Cloud experience (prefer AWS): S3, RDS/Aurora, IAM
• Experience with cloud data warehouses (prefer Snowflake or similar)
• Experience building and maintaining ETL/ELT pipelines

Preferred Qualifications

• Experience migrating from Matillion / Informatica / Talend / SSIS to Airflow
• Airflow experience in containerized environments (Docker, Kubernetes/EKS)
• Familiarity with data validation/reconciliation and pipeline testing strategies
• Monitoring tools experience: Datadog or CloudWatch
• Understanding of data modeling or medallion architecture