Data Scientist

City of Philadelphia; Philadelphia (Philadelphia County); On-site; USD 80,000 - 90,000; Full time

Benefits offered by this job

Unlimited public transportation

Paid parental leave

Comprehensive health coverage

Generous retirement options

Tuition discounts

Job summary

The City of Philadelphia is looking for a Data Scientist to enhance data-driven decision making within the Police Department. This onsite role involves modernizing data collection through Microsoft PowerApps and performing advanced analytics to expose crime patterns.

You will collaborate with various stakeholders, present findings, and develop tools to streamline data operations. The position offers comprehensive benefits and a salary range of $80,000 - $90,000.

Qualifications

• 3-5 years of experience in data science or analytics.
• Experience in developing Microsoft PowerApps.
• Proficient in data analytics tools and geospatial analysis.

Responsibilities

• Design and maintain Microsoft PowerApps and tools.
• Develop dashboards and reports using Power BI.
• Analyze data and develop predictive models.

Skills

Data Analytics

Microsoft PowerApps

Power BI

Python

R

SQL

Geospatial Analysis

Education

Bachelor’s or Master’s degree in Data Science or related field

Tools

Microsoft Power Automate

Dataverse

ArcGIS

Job description

The City of Philadelphia is seeking a Data Scientist to fortify data-driven decision making within the Police Department’s public safety operations. This onsite role in Philadelphia, PA centers on modernizing data collection through Microsoft PowerApps, performing advanced analytics, and building dashboards that reveal crime patterns and trends to inform strategic actions.

Responsibilities

• Design, develop, and maintain Microsoft PowerApps and supporting tools to streamline data collection from internal stakeholders such as officers, supervisors, and command staff.
• Integrate PowerApps with existing data systems including RMS, CAD, and internal SQL databases.
• Ensure data collection tools are secure, user-friendly, and responsive to field and administrative needs.
• Extract, clean, and analyze data from multiple law enforcement and city data systems.
• Develop predictive models and statistical analyses to identify crime patterns, resource allocation inefficiencies, and public safety risks.
• Create dashboards and reports using Power BI, R, or Python to support command-level decision-making.
• Design and conduct evaluations of crime-fighting initiatives such as hotspot policing, focused deterrence, or community engagement strategies.
• Apply methods such as matched comparisons, time-series analysis, or spatial analysis to measure program effectiveness.
• Present findings to department leadership, city officials, and public stakeholders with policy recommendations grounded in evidence.
• Collaborate with crime analysts, IT, patrol supervisors, and command staff to align data projects with operational needs.
• Partner with academic institutions and vendors on joint research initiatives.
• Provide training or support on new tools and methodologies to enhance data literacy across the department.

Requirements

• Bachelor’s or Master’s degree in Data Science, Computer Science, Applied Mathematics, or a related field.
• 3–5 years of experience in data science, analytics, or application development, preferably in government, healthcare, or criminal justice settings.
• Experience developing Microsoft PowerApps, including Power Automate and Dataverse integration.
• Proficiency in data analytics tools (Python, R, SQL), geospatial analysis (ArcGIS), and visualization platforms (Power BI).
• Experience in developing apps using PowerApps and other MS Power Platform.

Technologies

• PowerApps, Power Automate, Dataverse, R, Python, SQL, Power BI, ArcGIS

Benefits

• Transportation: Unlimited free public transportation through SEPTA’s Key Advantage program.
• Parental Benefits: 8 weeks of paid parental leave.
• Comprehensive health coverage for employees and their eligible dependents.
• Wellness program with eligibility into the discounted medical plan.
• Paid vacation, sick leave, and holidays.
• Generous retirement savings options.
• Public Service Loan Forgiveness program eligibility.
• Tuition discounts and scholarships (10% to 40%, with potential applicability to spouse and dependents).

Additional Information

• Salary Range: $80,000 - $90,000