Python Developer w/ Oracle, DBT Airflow and Linux Experience- Onsite Final Interview

Join a team at Yoh, A Day & Zimmermann Company to build and modernize data orchestration for on-prem Oracle 19c environments. This onsite role in Jersey City, NJ focuses on translating legacy scheduling into Python-based automation and Apache Airflow DAGs with auditing, observability, and reliable operations. The position runs 3 days onsite.

Compensation: USD 70 to 85 per hour.
Experience: 5+ years.

What you’ll do

• Develop, deploy, and maintain Python automation scripts to orchestrate jobs across Oracle 19c on-prem systems.
• Design and implement Airflow DAGs for complex, interdependent ETL workflows.
• Migrate existing job logic from Perl, RunMyJob, and PL/SQL scheduling into modular, observable Airflow DAG orchestration.
• Create custom Airflow operators and sensors to integrate with Oracle, REST APIs, and file drops using SFTP/FTP, including external triggers.
• Implement robust error handling, alerting, and retry mechanisms across job pipelines.
• Work with DBAs and application teams to map dependencies, critical paths, and data lineage.
• Set up execution logs, audit trails, and SLA monitoring dashboards for job execution.
• Participate in code reviews, documentation, and onboarding new jobs into the orchestrator.

What you bring

• 5+ years of Python development experience, including system and process automation.
• 2+ years building production Apache Airflow DAGs.
• Solid understanding of Oracle 19c, including SQL tuning and PL/SQL concepts.
• Experience orchestrating jobs that move large volumes of data across enterprise systems.
• Familiarity with job schedulers such as RunMyJob and Autosys, including replacing or abstracting them with orchestration tooling.
• Strong debugging across logs, databases, and the filesystem for failed jobs and partial runs.
• Experience building integrations involving REST APIs, SFTP/FTP, and parameter-driven automation.

Preferred experience

• Experience modernizing legacy data workflows from Perl or PL/SQL stored procedures.
• Hands-on knowledge of Git/Bitbucket and Jenkins with CI/CD for code-controlled job rollouts.
• Familiarity with financial data models such as holdings, transactions, NAVs, and tax lots.
• Basic understanding of data governance, audit, and operational risk in financial systems.

Benefits

• Medical, Prescription, Dental & Vision Benefits (for employees working 20+ hours per week)
• Health Savings Account (HSA) (for employees working 20+ hours per week)
• Life & Disability Insurance (for employees working 20+ hours per week)
• MetLife Voluntary Benefits
• Employee Assistance Program (EAP)
• 401K Retirement Savings Plan
• Direct Deposit & weekly epayroll
• Referral Bonus Programs
• Certification and training opportunities

Technologies: Python, Oracle, DBT, Linux, Apache Airflow, Oracle 19c, SQL, PL/SQL, Perl, RunMyJob, Autosys, REST API, SFTP, FTP, Git/Bitbucket, Jenkins, CI/CD.

Location: Jersey City, NJ (3 days onsite)