Senior DBT Developer
Context
An enterprise team is modernizing its data workflows, automating complex ETL processes and building reliable data orchestration on Oracle-based systems. The role is a hybrid W2 contract in Jersey City, NJ, with three days onsite per week.
What you'll do
- Develop, deploy and maintain Python automation scripts for Oracle-based systems
- Design, build and manage production-ready Apache Airflow DAGs
- Modernize legacy Perl, PL/SQL and scheduler-based workflows
- Build reusable Airflow operators and sensors for databases, APIs, file transfers and external triggers
- Implement error handling, retries, alerts, logging and audit trails, and monitor pipelines for data quality
Profile
- Hands-on experience with DBT (Data Build Tool)
- Strong Oracle Database 19c, SQL and PL/SQL experience
- 7+ years of Python development and 4+ years of hands-on Apache Airflow experience building production DAGs
- Advanced Linux/Unix knowledge, plus experience with job schedulers such as RunMyJobs or AutoSys
- Experience with REST APIs, SFTP/FTP and enterprise data integrations