Job Title: Python Developer
Number of Positions: 1
Projected Start Date: 08/18/2025
Projected End Date: 02/28/2026 (Please note the corrected timeline — the original listed an end date earlier than the start date)
Position Type: Contract
Location: Boston MA
Remote Work: Partial (Hybrid)
Job Description:
We are seeking an experienced Python Developer to lead automation and orchestration of complex data workflows. This individual will help modernize legacy job scheduling logic (Perl/PLSQL/RunMyJobs) into robust traceable and fault-tolerant Apache Airflow DAGs for Oracle 19c systems. The ideal candidate will bring hands-on experience with Python Airflow and enterprise data orchestration.
Key Responsibilities:
- Develop deploy and maintain Python-based automation scripts to orchestrate jobs across Oracle 19c systems.
- Design and implement Apache Airflow DAGs for complex ETL workflows.
- Migrate existing job logic from Perl RunMyJobs and PL/SQL to modular Python-based orchestration.
- Build custom Airflow operators/sensors for integration with Oracle DB REST APIs SFTP and external triggers.
- Implement robust error handling logging retry and alert mechanisms.
- Work with DBAs and application teams to define job dependencies critical paths and data lineage.
- Establish logs audit trails and SLA monitoring dashboards.
- Participate in code reviews documentation and onboarding of new pipelines.
Mandatory Skills:
- 5 years of Python development experience focused on automation and data workflows.
- 2 years of Apache Airflow experience building and deploying production-grade DAGs.
- Strong understanding of Oracle 19c including SQL tuning and PL/SQL concepts.
- Experience with job scheduling systems like RunMyJobs Autosys and their orchestration via Python/Airflow.
- Proficient in debugging across logs database layers and filesystem operations.
- Skilled in building REST API integrations SFTP-based file movements and parameterized job .
Highly Desired / Preferred Skills:
- Experience migrating legacy workflows from Perl or PL/SQL procedures.
- Familiarity with Git/Bitbucket Jenkins and CI/CD pipelines.
- Background in financial data workflows (holdings NAVs tax lots transactions).
- Understanding of data governance audit compliance and operational risk in financial environments.