Data Analyst: Visualization & Predictive Analytics

City-of-Philadelphi; Philadelphia (Philadelphia County); On-site; USD 75,000 - 85,000; Full time

Benefits offered by this job

Health insurance

Wellness program

Paid vacation

Retirement plan

Tuition discount

Job summary

The City of Philadelphia's Office of Innovation & Technology, in partnership with the Free Library of Philadelphia, seeks a Data Analyst to join the Research & Data Analytics group. The role will cover data acquisition, cleaning, and descriptive, prescriptive and predictive analytics, plus data visualization to deliver actionable insights aligned with Performance Management objectives.

You will work with cross-functional teams, supervise junior staff, and help prepare SOPs and datasets

Qualifications

• Proficiency with R and/or Python, and SQL programming languages.
• Experience developing statistical methods and analyses including predictive analytics, and correlation and regression models.
• Experience using industry standard data visualization and graphics tools for creation of professional reports and presentations.
• Proficient in developing database query strategies from spatial and non-spatial relational databases.
• Able to effectively communicate complex technical information to diverse audiences.
• Excellent written and oral communication skills, strong project planning, organization, and time management skills.
• Ability to create and maintain good working relationships and collaborations while working independently and taking the initiative.

Responsibilities

• Acquire data from multiple sources, both internal and external. Ensure data accuracy and integrity by cleaning and preprocessing data.
• Use appropriate statistical analysis techniques to explore and identify patterns, trends, and correlations.
• Create data visualizations using industry standard tools (Tableau, Power BI, Excel) to present findings effectively.
• Prepare and present reports, summaries, and recommendations to both technical and non-technical audiences.
• Develop and test data-driven hypotheses to answer specific questions.
• Build predictive models, including regression, AI, machine learning, or time series models to forecast trends and outcomes.
• Work with database systems to retrieve, manipulate, and analyze data efficiently.
• Write SQL queries to extract relevant data.
• Collaborate with cross-functional teams to understand data needs to deliver actionable insights.
• Ensure data security and compliance with data privacy regulations.
• Prepare standard operating procedures (SOPs) and ensure complete documentation of datasets, scripting routines, and workflows.
• Supervise subordinate or junior staff, or interns, identify mentoring opportunities and provide assistance as needed.
• Serve as Subject Matter Expert for Library agencies to ensure compliance with appropriate data management, integration, and sharing protocols.
• Participate in meetings and events within department, city and the greater data analytics community.
• Present reports at departmental meetings, informational sessions, and select conferences.

Skills

R and/or Python

SQL

Data visualization

Statistics / Modeling

Communication

Project Management

Collaboration

Education

Bachelor's degree in GIS/Geography/Urban Planning/Public Health/Statistics/Information Science/Civil Engineering

Master's degree preferred

Tools

ArcGIS

Tableau

Power BI

Excel

Job description

The City of Philadelphia's Office of Innovation & Technology, in partnership with the Free Library of Philadelphia, seeks a Data Analyst to join the Research & Data Analytics group. The role will cover data acquisition, cleaning, and descriptive, prescriptive and predictive analytics, plus data visualization to deliver actionable insights aligned with Performance Management objectives.

You will work with cross-functional teams, supervise junior staff, and help prepare SOPs and datasets