DBT + Oracle-Python ETL Lead with Airflow (Onsite)

Yoh, A Day & Zimmermann Company; Jersey City (NJ); On-site; USD 103,000 - 131,000; Part time

Job summary

Yoh, a Day & Zimmermann company, is seeking a Senior DBT Developer to lead the automation of data workflows on Oracle 19c systems. The role focuses on Python-based orchestration, Airflow DAGs, and replacing legacy scheduling with modern pipelines.

Onsite work in Jersey City is required, with interviews onsite preferred. The ideal candidate has 5+ years in Python development, 2+ years with Airflow, and strong Oracle/PLSQL experience, plus familiarity with RunMyJob or Autosys.

Qualifications

• Hands-on DBT experience with Oracle database.
• Python development is required.
• Finance experience is a plus.
• ETL background with Python Shell Script.
• Linux both advanced and fundamental.
• Apache Airflow: building production DAGs.

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 Perl/RunMyJob/PL/SQL-based scheduling to modular Airflow DAGs.
• Build custom Airflow operators/sensors for Oracle, REST APIs, SFTP/FTP, and external triggers.
• Implement robust error handling, alerting and retry mechanisms across pipelines.
• Collaborate with DBAs and teams to understand dependencies and data lineage.
• Establish job execution logs, audit trails, and SLA dashboards.
• Participate in code reviews and onboarding new jobs into the orchestrator.

Skills

Python development

Apache Airflow

Oracle 19c

PL/SQL concepts

SQL tuning

ETL automation

Linux (advanced & fundamental)

REST API integrations

SFTP/FTP data movement

RunMyJob / schedulers

Automated job orchestration

Tools

Airflow

Oracle 19c

RunMyJob

Autosys

Git/Bitbucket

Job description

Yoh, a Day & Zimmermann company, is seeking a Senior DBT Developer to lead the automation of data workflows on Oracle 19c systems. The role focuses on Python-based orchestration, Airflow DAGs, and replacing legacy scheduling with modern pipelines.

Onsite work in Jersey City is required, with interviews onsite preferred. The ideal candidate has 5+ years in Python development, 2+ years with Airflow, and strong Oracle/PLSQL experience, plus familiarity with RunMyJob or Autosys.