IT Analyst 3-Free Library Data Analyst

City of Philadelphia • Philadelphia, PA

1d

About The Position

The Free Library of Philadelphia is seeking a Data Analyst for the Research & Data Analytics group within the Performance Management and Technology Division. The role applies data analytics—including data acquisition and cleaning, descriptive, prescriptive, and predictive analysis, and data visualization—to produce actionable data products, analyses, and reports aligned with Performance Management objectives. The analyst works with division staff to understand program objectives and manage complex projects, and may supervise the day-to-day work of associate data coordinators, including mentoring, evaluation, and ensuring compliance with standard operating procedures.

The position works with internal and external data sources and database systems, applies statistical methods and predictive models, and communicates findings to technical and non-technical audiences. It also supports data security, privacy, documentation, and data-management protocols for Library agencies. The successful candidate must become a Philadelphia resident within six months of hire.

Requirements

• At least five years of relevant professional experience.
• Baccalaureate degree from an accredited college or university, including major coursework in Geographic Information Systems (GIS), Geography, Urban Planning, Public Health, Statistics, Information Science, or Civil Engineering.
• 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 to create professional reports and presentations, web content, and educational materials.
• Proficiency in developing database query strategies for spatial and non-spatial relational databases.
• Ability to communicate complex technical information effectively to diverse audiences.
• Excellent written and oral communication skills, and strong project planning, organization, and time-management skills.
• Ability to build and maintain good working relationships and collaborations while working independently and taking initiative.
• Willingness to expand professional competency through appropriate continuing education and training.
• Must become a City of Philadelphia resident within six months of hire.

Nice To Haves

• Master’s degree.
• Experience with cloud services and data management.
• Experience with Tableau and/or Power BI.
• Experience handling regulatory requirements related to personally identifiable information (PII).
• Experience with parcel mapping, editing, and parcel management.
• Experience using the ESRI ArcGIS software suite to publish data and produce GIS applications.
• Proficiency in spatial data creation, editing, and maintenance.
• Experience with multi-user versioned and distributed editing and replication in an ArcGIS Server/ArcGIS SDE 10.x environment.

Responsibilities

• Acquire data from multiple internal and external sources.
• Clean and preprocess data to ensure accuracy and integrity.
• Apply statistical analysis techniques to explore and identify patterns, trends, and correlations.
• Create data visualizations using tools such as Tableau, Power BI, and Excel.
• Prepare and present reports, summaries, and recommendations for 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.
• Use database systems to retrieve, manipulate, and analyze data, including writing SQL queries to extract relevant data.
• Collaborate with cross-functional teams to understand data needs and deliver actionable insights.
• Ensure data security and compliance with data privacy regulations.
• Prepare standard operating procedures and document datasets, scripting routines, and workflows.
• Supervise subordinate or junior staff or interns; identify mentoring opportunities and provide assistance as needed.
• Serve as a subject matter expert for Library agencies on data management, integration, and sharing protocols.
• Participate in meetings and events within the department, city, and wider data analytics community.
• Present reports at departmental meetings, informational sessions, and selected conferences.

Benefits

• Public Service Loan Forgiveness Program qualified employer.
• Tuition discount program of 25% for City employees, and sometimes spouses and dependents, in partnership with area colleges and universities.
• Comprehensive health coverage for employees and eligible dependents.
• Wellness program with eligibility for a discounted medical plan.
• Paid vacation, sick leave, and holidays.
• Generous retirement savings options.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior