Senior Python Data Orchestrator: Oracle & Airflow (Finance)

Yoh Services LLC; Jersey City (NJ); On-site; USD 96,000 - 117,000; Full time

Benefits offered by this job

Medical benefits

Health Savings Account (HSA)

Life & Disability Insurance

MetLife Voluntary Benefits

Employee Assistance Program (EAP)

401K Retirement Savings Plan

Direct Deposit & weekly ePayroll

Referral Bonus Programs

Certification and training

Job summary

Yoh Services LLC is seeking an experienced Python Oracle Linux Airflow Developer for an onsite role in Jersey City, NJ. The candidate will lead automation and orchestration of complex data workflows on Oracle 19c on‑prem systems, replacing legacy Perl/PLSQL scheduling with Python-based DAGs in Airflow.

Required: 5+ years Python, 2+ years Airflow, Oracle 19c expertise, and familiarity with RunMyJob/Autosys. Onsite interview required; USC/GC only, NO VISAS.

Qualifications

• 5+ years of Python development experience with emphasis on automation.
• 2+ years of Apache Airflow building production DAGs.
• Solid Oracle 19c database knowledge including SQL tuning and PL/SQL concepts.
• Experience orchestrating large data moves across enterprise systems.
• Familiarity with job schedulers (RunMyJob, Autosys) and replacing them with orchestration tools.
• Strong debugging skills across logs, databases, and filesystem for failed jobs.
• Experience building REST API integrations and SFTP/file movement logic.

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/PLSQL scheduling into modular Airflow DAGs.
• Build custom Airflow operators/sensors for Oracle REST APIs and file drops.
• Implement robust error handling, alerting, and retry mechanisms across pipelines.
• Collaborate with DBAs and teams to understand dependencies, paths, and data lineage.
• Establish logs, audit trails, and SLA monitoring dashboards.

Skills

Oracle database experience

ETL background/Python Shell Script

Linux (advanced & fundamental)

Airflow

Finance experience is nice to have

Tools

RunMyJob

Autosys

Job description

Yoh Services LLC is seeking an experienced Python Oracle Linux Airflow Developer for an onsite role in Jersey City, NJ. The candidate will lead automation and orchestration of complex data workflows on Oracle 19c on‑prem systems, replacing legacy Perl/PLSQL scheduling with Python-based DAGs in Airflow.

Required: 5+ years Python, 2+ years Airflow, Oracle 19c expertise, and familiarity with RunMyJob/Autosys. Onsite interview required; USC/GC only, NO VISAS.