Public Sector Data Engineer — ETL & Analytics Pipelines

The company name is \"The Philadelphia District Attorney’s Office\".; Chicago (IL); Vor Ort; USD 90.000 - 120.000; Vollzeit

Benefits dieser Stelle

Retirement plan

PSLF eligible

Health insurance

Paid time off

Wellness program

Commuter benefits

Zusammenfassung

The Philadelphia District Attorney’s Office is seeking a dedicated Data Engineer to join the DATA Lab Infrastructure team. You will build data pipelines that feed a Postgres reporting database, drawing from diverse sources to support analysis and policy work within the DAO and citywide research initiatives.

You’ll collaborate with analysts, researchers, and project managers, contributing to a culture of transparent, data-driven decisions while advancing data engineering best practices in a

Qualifikationen

• Education/experience: 1–3 years in data engineering or related field.
• Proficiency in Python or demonstrated ability to learn it.
• Strong SQL and ETL pipeline experience.

Aufgaben

• Design, build, and maintain automated, scalable data pipelines.
• Ensure data quality, efficiency, and accuracy.
• Troubleshoot outages and errors as they occur.
• Partner with Analysts/Researchers to identify datasets and requirements.
• Participate in Agile ceremonies and code reviews.
• Write documentation and provide technical training/support.

Kenntnisse

Python

SQL

ETL pipelines

AWS

Linux

Airflow

Git

Ausbildung

Computer science background or equivalent experience

Tools

Postgres

Jobbeschreibung

The Philadelphia District Attorney’s Office is seeking a dedicated Data Engineer to join the DATA Lab Infrastructure team. You will build data pipelines that feed a Postgres reporting database, drawing from diverse sources to support analysis and policy work within the DAO and citywide research initiatives.

You’ll collaborate with analysts, researchers, and project managers, contributing to a culture of transparent, data-driven decisions while advancing data engineering best practices in a