Data Engineer-Integration Specialist

City of Philadelphia • Philadelphia, PA

1d • $95,605

About The Position

The City of Philadelphia’s Office of Innovation & Technology (OIT) is hiring a Data Engineer-Integration Specialist to help develop, maintain, and optimize City data pipelines and integration strategies. The role is part of a diverse team of engineers, analysts, and GIS specialists working to improve City services through effective, innovative use of data. The specialist will develop a strong understanding of the City’s diverse data and help improve its data engineering infrastructure, pipelines, models, and integrations.

The team uses a mix of open-source, custom-built, and commercial tools, including Python, Bash, SQL, DBT, GIS, Docker, Terraform, Apache Airflow, Jenkins, Postgres, PostGIS, AWS, GitHub, GitHub Actions, MuleSoft, and APIs such as ArcGIS Online and CARTO. The role contributes to critical services and systems including DataBridge, the enterprise data warehouse; AIS, the City’s address information systems; and Databridge-Airflow, a workflow generator and orchestrator for departmental integrations and open-data publishing.

The successful candidate will work with business partners and data stewards across different technical backgrounds, support enterprise integration and open-data initiatives, and communicate technical information clearly to both technical and non-technical audiences. The City is seeking someone interested in using data to improve City operations and community life. The successful candidate must become a City of Philadelphia resident within six months of hire.

Requirements

• Bachelor’s degree in Computer Science, Data Science, Information Systems, Geography/GIS, or a related field; equivalent work experience may be considered.
• Demonstrated experience in data engineering or a similar role, with a focus on data management, integration, ETL, or ELT.
• Proven track record with Python, SQL, and database management.
• Experience working with a modern data engineering technology stack.
• Familiarity with developing custom ETL/CI/CD tools and ability to learn and adapt to new technologies.
• Proficiency in Python.
• Strong SQL skills and experience with databases; Postgres is preferred.
• Familiarity with Docker, Bash, and minimal Linux server administration.
• Understanding of Git/GitHub for version control and CI/CD pipelines.
• Ability to reason about, model, and manipulate complex datasets; maintain clean and secure data environments; work in a hybrid on-premises and cloud environment; communicate complex technical concepts clearly; and evaluate tools and practices in a public-service context.
• Clear and concise writing and communication skills, creative problem-solving and critical thinking, effective time management, and ability to manage multiple workflows.
• Curiosity, willingness to learn, interest in continuous improvement, and eagerness to contribute to team discussions and knowledge sharing.
• Must become a City of Philadelphia resident within six months of hire.
• Applications must include a resume and cover letter; applications without a cover letter will not be considered.

Nice To Haves

• Previous work in a public-sector or large-organization setting.
• Familiarity with modern Python development practices such as type annotations, data validation, and automated testing.
• Experience with cloud services; AWS is preferred.
• Experience with spatial datasets.
• Experience with, or ability to learn, Airflow, DBT, Terraform, Kubernetes, and MuleSoft.
• Experience using command-line interfaces.

Responsibilities

• Work with business partners of varying technical ability to understand how their data is produced, stored, and updated.
• Design enhancements that optimize enterprise integrations and public data accessibility.
• Design, develop, expand, and refine data pipelines using Apache Airflow, custom Python-based software, and other tools.
• Connect diverse systems of record, centralized databases, and SaaS environments.
• Improve data platform components, data governance, master data management, data standardization, enrichment, and quality assurance.
• Develop and support critical systems including DataBridge, Databridge-Airflow, and AIS.
• Write clear, descriptive technical documentation for systems and applications.
• Partner with data stewards and communicate technical details to non-technical stakeholders.
• Participate in knowledge sharing and discussions about coding standards and data engineering practices.

Benefits

• Public Service Loan Forgiveness Program-qualified employer.
• Tuition discount program for City employees, and sometimes their spouses and dependents, through partnerships with area colleges and universities.
• Comprehensive health coverage for employees and eligible dependents.
• Wellness program eligibility for a discounted medical plan.
• Paid vacation, sick leave, and holidays.
• Generous retirement savings options.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level