Data Engineer-Integration Specialist
City of Philadelphia6 days ago
Philadelphia, PA, USAMid Level
Responsibilities
- Work with business partners to understand how data is produced, stored, and updated and design improved enterprise integrations.
- Develop, expand, refine, and support data pipelines connecting systems of record, centralized databases, and SaaS environments.
- Improve data platform components, data governance, master data management, data standardization, enrichment, and quality assurance.
- Support critical City systems and initiatives including DataBridge, Databridge-Airflow, AIS, enterprise data warehousing, and open data publishing.
- Write technical documentation, collaborate with data stewards, and communicate technical concepts to non-technical stakeholders.
- Evaluate and adopt data engineering tools and practices in a public-service context.
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 focused on data management, integration, ETL, or ELT.
- Proficiency in Python and strong SQL skills with database management experience, preferably with Postgres.
- Familiarity with modern Python development practices, Docker, Bash, Linux server administration, AWS, Git/GitHub, and CI/CD pipelines.
- Experience or ability to learn Apache Airflow, DBT, Terraform, Kubernetes, and MuleSoft.
- Ability to reason about, model, manipulate, maintain, and secure complex datasets, including spatial datasets as a plus.
- Strong writing, communication, problem-solving, critical-thinking, time-management, collaboration, and continuous-learning skills.
- Experience in a public-sector or large-organization setting is a plus.
- Applicants must submit a resume and cover letter.
Benefits
- Public Service Loan Forgiveness Program qualified employer.
- 25% tuition discount program for City employees and sometimes spouses and dependents through partner 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.
- Hybrid work involving on-premises and cloud environments.
- Successful candidate must become a City of Philadelphia resident within six months of hire.
Tech Stack
Categories
Data Engineering
About City of Philadelphia
The City of Philadelphia is the municipal government serving residents, businesses, and visitors through public safety, infrastructure, licensing, social services, and digital services. It is funded by taxes, fees, and grants, and develops and operates citizen-facing portals, data platforms, and internal tools; current initiatives include a hybrid AWS GovCloud and Commercial cloud environment. Headquartered in Philadelphia, PA, it is the primary public-service provider for the city and a major regional employer.