Python Developer

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 execution 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 execution. 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.