Senior Python Developer: Airflow & Oracle ETL Lead

Yoh, A Day & Zimmermann Company; Jersey City (NJ); On-site; USD 75,000 - 95,000; Full time

Job summary

Yoh, a Day & Zimmermann company, seeks an experienced Python Developer to lead automation and orchestration of complex data workflows on on-prem Oracle systems in Jersey City. You will replace legacy scheduling with Python-based DAGs and ensure traceability, data quality, and recoverability.

The role requires hands-on DBT, Oracle DB, Airflow, and ETL expertise, with onsite interviews and USC/GC eligibility. Join a legacy staffing leader delivering critical data solutions.

Qualifications

• 5+ years of Python development experience and automation background.
• 2+ years of Apache Airflow building production DAGs.
• Solid Oracle 19c database, SQL tuning, and PL/SQL concepts.
• Experience moving large data volumes across enterprise systems.
• Familiarity with job schedulers (RunMyJob, Autosys) and how to replace them with orchestration tools.
• Strong debugging skills across logs, databases, and filesystem for failed jobs.
• Experience building REST API integrations, SFTP/file movement logic, and parameter-driven automation.

Responsibilities

• Develop, deploy, and maintain Python-based automation scripts to orchestrate jobs across Oracle 19c on-prem systems.
• Design and implement Airflow DAGs to manage complex ETL workflows.
• Migrate existing job logic from Perl/RMJ/PL/SQL to modular Airflow DAGs.
• Build custom Airflow operators/sensors for Oracle, REST APIs, and file drops.
• Implement robust error handling, alerting and retry mechanisms across job pipelines.
• Collaborate with DBAs and application teams to understand job dependencies and data lineage.
• Establish job execution logs, audit trails, and SLA monitoring dashboards.
• Participate in code reviews, documentation, and onboarding new jobs into the orchestrator.

Skills

Python development

Hands on DBT

Airflow

Oracle database

ETL background

Linux

Finance experience

Tools

RunMyJobs

Autosys

Perl

PL/SQL

REST APIs

SFTP/FTP

Git/Bitbucket

Jenkins

Job description

Yoh, a Day & Zimmermann company, seeks an experienced Python Developer to lead automation and orchestration of complex data workflows on on-prem Oracle systems in Jersey City. You will replace legacy scheduling with Python-based DAGs and ensure traceability, data quality, and recoverability.

The role requires hands-on DBT, Oracle DB, Airflow, and ETL expertise, with onsite interviews and USC/GC eligibility. Join a legacy staffing leader delivering critical data solutions.