Lead Data Engineer / Integration Specialist
Core
Designing, building, and maintaining complex enterprise data integrations, pipelines, and APIs for Philadelphia City systems to support public services and open data.
Role type
Lead Data Engineer / Integration Specialist
Builds
Enterprise data pipelines, APIs, ETL/ELT workflows, and integration patterns connecting diverse City systems (SaaS, databases, file-based systems).
Domain
Public sector / Municipal government / Data Engineering
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Python, SQL, Apache Airflow, DBT, Postgres, PostGIS, AWS, MuleSoft, REST API integration, CI/CD, Docker, Bash, Linux
Preferred skills
Spatial datasets, public-sector experience, large-organization environment
Technologies
Python, SQL, Apache Airflow, DBT, Postgres, PostGIS, AWS, MuleSoft, Docker, Git/GitHub
Responsibilities
Design and develop complex enterprise data pipelines and integrations; Create custom API access patterns for systems lacking native APIs; Establish reusable integration templates and data contracts; Troubleshoot production data pipelines and integration issues; Collaborate with stakeholders to align integration designs with business processes; Write technical documentation for systems and integration logic.
Seniority
Senior, hands-on IC with leadership responsibilities