> Markdown version of [/jobs/ext/2625113-data-engineer-python-dbt-oracle](https://www.wearedevelopers.com/jobs/ext/2625113-data-engineer-python-dbt-oracle). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer - Python, dbt & Oracle - **Company:** Interon IT Solutions LLC - **Location:** Jersey City, NJ, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Airflow, CA Workload Automation Ae, Batch Processing, Unix, Databases, Continuous Integration, Directed Acyclic Graph (Directed Graphs), Data Governance, Data Infrastructure, Extract Transform Load (ETL), Database Queries, Linux, File Systems, Perl (Programming Language), Job Scheduling, Python (Programming Language), Oracle (Applications), Oracle SQL Developer, Performance Tuning, PL-SQL, Scripting, File Transfer Protocol (FTP), Git, Data Lineage, Bitbucket, Restful APIs, Data Pipelines, Jenkins - **Published:** August 29, 2026 - **Apply:** https://www.careerjet.com/jobad/usdc40fce44e0c4b89d0c31d9e279c6563 ## About the Role * Strong hands-on experience with dbt and Oracle 19c. Both are mandatory. * At least five years of Python development experience, particularly in automation, scripting, and enterprise ETL pipelines. * At least two years of experience developing and deploying production-grade Apache Airflow DAGs, custom operators, and sensors. * Strong experience with Oracle SQL, PL/SQL development, complex queries, and performance tuning. * Advanced knowledge of Linux/Unix environments and shell-based processing. * Experience modernizing or replacing enterprise job schedulers such as RunMyJobs or AutoSys. * Experience developing REST API integrations and SFTP/FTP file-transfer processes. * Strong understanding of batch processing, job dependencies, failure recovery, and operational monitoring. * Proven ability to troubleshoot issues across application logs, databases, filesystems, and data pipelines., * Experience modernizing or replacing legacy Perl applications or scripts. * Previous experience in banking, investment management, or financial services. * Familiarity with financial data such as holdings, transactions, net asset values, and tax lots. * Experience with Git or Bitbucket, Jenkins, and CI/CD-based deployment processes. * Knowledge of operational risk, data governance, audit controls, and data lineage within financial systems. ## Description Our Client is seeking an experienced Data Engineer to support a major data infrastructure modernization initiative. This project involves assessing and modernizing approximately 700 800 legacy Perl scripts and RunMyJobs/PL/SQL scheduling workflows. The selected candidate will help migrate these legacy processes to a modular, observable, and testable data platform using Python, dbt, Apache Airflow, and Oracle 19c., * Assess, redesign, and migrate legacy Perl scripts, RunMyJobs workflows, and PL/SQL scheduling logic to Python scripts and Apache Airflow DAGs. * Design, build, and deploy production-grade Airflow DAGs for complex, interdependent enterprise batch workflows. * Develop custom Airflow operators and sensors for Oracle 19c, REST APIs, SFTP/FTP transfers, and external triggers. * Build and maintain data transformation workflows using dbt. * Write and optimize complex Oracle SQL and PL/SQL queries. * Improve the performance and reliability of data pipelines operating across on-premises systems. * Implement error handling, retry processes, SLA alerts, execution logs, audit trails, and data-lineage monitoring. * Troubleshoot failed or partially completed jobs across application logs, databases, and Linux/Unix filesystems. * Work closely with DBAs and application teams to document job dependencies, identify critical processing paths, and improve data quality and recoverability. * Support parameter-driven automation and reusable pipeline-development standards. ## Related Videos - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [WeAreDevelopers LIVE - Node and Package Security](https://www.wearedevelopers.com/videos/2138-wearedevelopers-live-node-and-package-security) - [Docker network without Docker](https://www.wearedevelopers.com/videos/1418-docker-network-without-docker) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)