DBT Developer with Oracle & Python Experience

Requirements:

• 5+ years of Python development experience, including system and process automation.
• 2+ years of experience building production Apache Airflow DAGs.
• Hands-on DBT and Oracle database experience, including Oracle 19c, SQL tuning, and PL/SQL concepts.
• Experience orchestrating jobs that move large volumes of data across enterprise systems.
• Familiarity with job schedulers such as RunMyJobs or Autosys and replacing or abstracting them with orchestration tools.
• Strong debugging skills across logs, databases, and filesystems, including troubleshooting failed jobs and partial runs.
• Experience with REST API integrations, SFTP or other file-movement workflows, and parameter-driven automation.
• ETL experience and Python shell scripting; advanced and fundamental Linux knowledge.
• Finance experience is a plus, including familiarity with financial data models such as holdings, transactions, NAVs, or tax lots.
• Preferred: experience modernizing legacy Perl or PL/SQL workflows; Git or Bitbucket, Jenkins, and CI/CD; and a basic understanding of data governance, audit, and operational risk in financial systems.

Responsibilities:

• Develop, deploy, and maintain Python automation scripts to orchestrate jobs across on-premises Oracle 19c systems.
• Design and implement Airflow DAGs for complex, interdependent ETL workflows.
• Migrate Perl, RunMyJobs, and PL/SQL scheduling logic into modular, observable Airflow DAGs.
• Build custom Airflow operators and sensors that integrate with Oracle, REST APIs, SFTP/FTP file drops, and external triggers.
• Implement error handling, alerts, and retry mechanisms across job pipelines.
• Work with DBAs and application teams to understand job dependencies, critical paths, and data lineage.
• Establish execution logs, audit trails, and SLA-monitoring dashboards.
• Participate in code reviews and documentation, and onboard new jobs to the orchestrator.

Technologies:

• Airflow
• API
• BitBucket
• CI/CD
• ETL
• Git
• Jenkins
• Linux
• Network
• Oracle
• Perl
• Python
• REST
• SQL
• dbt

More

We are seeking a Senior DBT Developer to lead automation and orchestration of complex data workflows, modernizing legacy processes and supporting traceable, high-quality, recoverable pipelines across on-premises Oracle systems. The role involves integrating with schedulers such as RunMyJobs and using Python and Airflow to replace legacy scheduling logic. The position is based in Jersey City, New Jersey, with three days onsite required; an onsite final interview is strongly preferred. The posting is open to CTC and W-2 contractors, with an estimated rate of $75–$95. We offer access to our client network and talent community, along with benefits that may include medical, prescription, dental and vision coverage, an HSA, life and disability insurance, voluntary benefits, an employee assistance program, a 401(k), weekly payroll by direct deposit, referral bonuses, and certification and training opportunities. Benefit eligibility is subject to applicable laws and client requirements. We are Yoh, a Day & Zimmermann company, with a longstanding staffing presence in the U.S., UK, and Canada.

last updated 43 week of 2026