LEFT JOIN data jobs Alerts Saved
Left Join › City of Philadelphia

City of Philadelphia

Employer
Follow City of Philadelphia

City of Philadelphia's new roles by email, the morning after we find them. Companies you follow come first in your alert email, with how their hiring moved that week. Narrow it, or keep every role.

How often
We email a link to confirm it.
Open roles
3
New in 7 days
0
Closed in 7 days
0
Last verified
1 h ago

Open source

City of Philadelphia's public GitHub repositories with 100 or more stars.

ProjectLanguageStars30 days
flu-shot-spec CityOfPhiladelphia/flu-shot-spec Ruby 214 —
Is an open-source project wrong or missing?
What's wrong?

US Visa filings

Labor Condition Applications City of Philadelphia filed with the US Department of Labor for H-1B, H-1B1 and E-3 workers, certified, for computer, data and engineering roles. They're what it applied for, not visas granted, and not a promise for any role: a posting says whether it sponsors. How these are counted.

Fiscal yearApplicationsDataNew hiresChanging employerMedian offered pay
FY2026171151$70K
FY2025233172$78K
FY202410261$83K

Titles filed most, FY2025–FY2026: Graduate Civil Engineer 9 · Engineering Specialist 5 · Civil Engineer 1 3 · Civil Engineer I 2 · Business Analyst 1 · Civil Engineer 2 1 · Data Analyst 1 · Database Administrator 2 1

Where they'd work: PA 40

Filed as City of Philadelphia. From DOL's LCA disclosure files, decisions through June 30, 2026. US fiscal years start October 1. New hires and changing employer count workers; pay is the base wage offered, without bonus or equity.

Is a legal name wrong or missing?
What's wrong?

Data stack

pipelinedbt + Airflow, Power BI

Read from 7 data roles open now or closed in the last 90 days, 5 naming a tool: the tool named most in each layer, in the order data moves, then BI, where a quarter or more of them name it.

What City of Philadelphia's postings ask for: how many of its 3 open postings name each tool, and (+/−) how many naming it were opened and closed in the last 90 days. Read from the postings' text: what they mention, not everything the team does.

Transformation
dbt 2/3 +2 −1
Orchestration
Airflow 2/3 +2 −1
BI
Tableau 1/3 +2 −1Power BI 1/3 +2 −1
Languages
SQL 3/3 +4 −2Python 3/3 +4 −2SAS 2/3 +2 −0R 1/3 +1 −0

Open roles

Data engineering 2

Analytics & BI 1

Where this data comes from

Jobs come from City of Philadelphia's smartrecruiters job board, found in JobAware's board census.