City of Philadelphia · 16 hours ago
IT Analyst 3-Free Library Data Analyst
Philadelphia, PA
Full-time
Onsite
Mid, Senior Level
$70K/yr - $85K/yr
5+ years expThe City of Philadelphia's Office of Innovation & Technology is seeking a Data Analyst to join the Free Library of Philadelphia's Research & Data Analytics group. The successful candidate will utilize their analytical skills to deliver actionable data products and insights while collaborating with various teams to manage complex projects and ensure data accuracy and compliance.
Law EnforcementNewsPublishing
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
Qualification
Required
Proficiency with R and/or Python, and SQL programming languages
Experience developing statistical methods and analyses including predictive analytics, and correlation and regression models using appropriate statistical software tools
Experience using industry standard data visualization and graphics tools for creation of professional reports and presentations, web content, and education materials
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
Willing to expand professional competency by taking advantage of appropriate continuing education and training opportunities
Five or more years of relevant professional experience required
Baccalaureate degree from an accredited college or university which has included major course work in Geographic Information Systems (GIS), Geography, Urban Planning, Public Health, Statistics, Information Science, or Civil Engineering
Preferred
Experience with cloud services and data management
Experience with Tableau and/or PowerBI applications
Experience handling regulatory requirements related to PII
Experience with parcel mapping, editing, and parcel management
Experience using ESRI ArcGIS software suite to publish data and produce GIS applications
Proficiency in spatial data creation, editing and maintenance
Multi-user versioned and distributed editing, replication in ArcGIS Server/ArcGIS SDE 10.x environment
Master's degree is preferred
Benefits
We are a Public Service Loan Forgiveness Program qualified employer : 25% tuition discount program for City employees (and sometimes spouses and dependents as well) in partnership with area colleges and universities
We offer Comprehensive health coverage for employees and their eligible dependents
Our wellness program offers eligibility into the discounted medical plan
Employees receive paid vacation, sick leave, and holidays
Generous retirement savings options are available
Company
City of Philadelphia
Philadelphia is the largest city in the Commonwealth of Pennsylvania, the fifth-most-populous city in the United States.
10001+ employees
H1B Sponsorship
City of Philadelphia has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (30)
2024 (13)
2023 (5)
2022 (15)
2021 (13)
2020 (8)
Funding
Current Stage
Late StageLeadership Team
A
Alan Burstein
Chief Surveyor
A
Alba Collazo-Irwin
Chief Deputy
Recent News
The Philadelphia Inquirer
2026-01-23
The Philadelphia Inquirer
2025-11-27
The Philadelphia Inquirer
2025-11-12
Company data provided by crunchbase