Cityofphiladelphia
Lead Data Engineer / Integration Specialist
Philadelphia, PA, United States · Part-time
Sponsorship not specifiedDetected 9 days ago
PythonBashCode ReviewGitSQLPostgreSQLAWSDockerCI/CDLinuxAPI DevelopmentRESTAirflowdbtData AnalysisData EngineeringData ScienceTest AutomationGISProblem Solving
About the role
- With a workforce of over 30,000 people, and more than 1,000 different job categories, the City of Philadelphia offers boundless opportunities to make an impact.
- As an employer, the City of Philadelphia values inclusion, integrity, innovation, empowerment, and hard work above all else.
- If you're interested in working with a passionate team of people who care about the future of Philadelphia, start here.
Responsibilities
- The Lead Data Engineer / Integration Specialist will play a key role in designing, building, documenting, and improving enterprise data integrations across diverse City systems.
- The position will support priority departmental and enterprise integration initiatives, while also contributing to the broader enterprise integration portfolio managed by CityGeo.
- Design, develop, test, deploy, and maintain complex enterprise data pipelines and integrations.
- Work with departments, product teams, vendors, and technical partners to understand how data is
- Design integrations that connect systems of record, centralized databases, SaaS platforms, APIs, file-
- Develop robust ETL/ELT workflows using Python, SQL, Apache Airflow, DBT, Postgres, PostGIS, AWS,
Requirements
- Strong documentation habits and ability to explain technical decisions.
- Ability to work with data from diverse domains and systems.
- Ability to guide technical implementation in a collaborative team environment.
- Ability to identify opportunities for standardization, reuse, automation, and continuous improvement. · Service-oriented approach to working with departments and stakeholders.
Nice to have
- Bachelor's degree in Computer Science, Information Systems, Data Science, GIS, Engineering, or a related field.
- Equivalent work experience may be considered.
- Five or more years of progressively responsible experience in data engineering, data integration, ETL/ELT development, API integration, or a related role.
- Experience working directly with stakeholders to understand business processes, data needs, and system constraints.
- Dedication to making Philadelphia municipal government more robust, efficient, equitable, and data-informed.
Skills
- Advanced Python skills for data engineering, automation, API integration, and pipeline development.
- Strong SQL skills and experience working with relational databases, preferably Postgres and PostGIS.
- Experience designing, building, and maintaining ETL/ELT pipelines.
- Experience with Apache Airflow, DBT, Git/GitHub, CI/CD practices, and modern data engineering workflows.
- Experience integrating with REST APIs, SaaS systems, databases, file-based systems, and other data sources.
- Familiarity with cloud services, preferably AWS.
- Understanding of data governance, metadata, master data management, data quality, and data standardization concepts.
- Experience working in a public-sector, civic technology, or large enterprise environment is a plus.
- To maintain clean, secure, and reliable data environments.
- To work effectively in a hybrid environment that includes cloud, on-premises, open source, custom, and commercial systems.
- Demonstrated experience designing and maintaining production data pipelines or enterprise integrations.
- Proven experience with Python, SQL, relational databases, and version-controlled development workflows.
Compensation
- Starting salary to be determined based on experience and qualifications.
Benefits
- Benefits - We care about your well-being.
Company info
- We are looking for a candidate who is not only technically skilled, but also passionate about leveraging data to improve City operations and community life.
Apply directly at Cityofphiladelphia →Create a free account for alerts like thisView Cityofphiladelphia immigration profile
This listing is sourced directly from Cityofphiladelphia's careers page and normalized into a canonical job model.