IT Analyst 3-Free Library Data Analyst

City of Philadelphia • Philadelphia, PA

2d • $75,000 - $85,000

About The Position

The Free Library of Philadelphia (FLP) is seeking a talented Data Analyst to join the Research & Data Analytics group within the Performance Management and Technology Division. The successful candidate will be experienced in all aspects of data analytics, including data acquisition and cleaning, descriptive, prescriptive and predictive analytics, and data visualization. The Data Analyst will create organizational value by combining exceptional analytical skills with strong functional domain knowledge to deliver actionable data products, analyses and reports aligned to Performance Management objectives. The Data Analyst will work cooperatively with Performance Management and Technology staff to understand program objectives and manage complex projects. The Data Analyst may supervise the day to day work of associate data coordinators; supervisory tasks may include mentoring, evaluation, and ensuring compliance with standard operating procedures.

Requirements

• 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.
• 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 compentency by taking advantage of appropriate continuing education and training opportunities.

Nice To Haves

• Master’s degree is 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.

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.

Benefits

• 25% tuition discount program for City employees (and sometimes spouses and dependents as well) in partnership with area colleges and universities
• Comprehensive health coverage for employees and their eligible dependents
• Wellness program offers eligibility into the discounted medical plan
• Employees receive paid vacation, sick leave, and holidays
• Generous retirement savings options are available

What This Job Offers

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