Company Description

A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. With a workforce of over 30,000 people, and more than 1,000 different job categories, the City of Philadelphia offers boundless opportunities to make an impact.
As an employer, the City of Philadelphia values inclusion, integrity, innovation, empowerment, and hard work above all else. We offer a vibrant work environment, comprehensive health care and benefits, and the experience you need to grow and excel. If you’re interested in working with a passionate team of people who care about the future of Philadelphia, start here.
What We Offer:

Impact - The work you do here matters to millions.
Growth - Philadelphia is growing, why not grow with it?
Diversity & Inclusion - Find a career in a place where everyone belongs.
Benefits - We care about your well-being.

The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia headed by the Chief Information Officer (CIO). OIT oversees all major information and communications technology initiatives for the City of Philadelphia - increasing the effectiveness of the information technology infrastructure, where the services provided are advanced, optimized, and responsive to the needs of the City of Philadelphia’s businesses, residents, and visitors. OIT responsibilities include: identifying the most effective approach for implementing new information technology directions throughout city government; improving the value of the city’s technology assets and the return on the city’s technology investments; ensuring data security continuity; planning for continuing operations in the event of disruption of information technology or communications services; and supporting accountable, efficient and effective government across every city department, board, commission and agency.

The Free Library of Philadelphia (FLP) is one of the largest public library systems in the world. As an important cornerstone of the Philadelphia community, FLP has a mission to advance literacy, guide learning, and inspire curiosity. The long-term vision of the FLP is to build an enlightened community devoted to lifelong learning. For over 100 years, the FLP has championed education in and out of the classroom, providing no cost resources for literacy and learning.

Job Description

The Free Library of Philadelphia is looking for 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.

Essential Functions

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.

Competencies, Knowledge, Skills and Abilities
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 compentency by taking advantage of appropriate continuing education and training opportunities.

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.

Qualifications

Five or more years of relevant professional experience required. Baccalaureate degree from an accredited college or university which has included major course work in Information Science, Statistics, Data Science, Information Management, Geographic Information Systems (GIS), Urban Planning or a related field. Master’s degree is preferred.

Additional Information

Salary Range: $75,000 ‐ $85,000

Starting salary to be determined based on experience and qualifications.

Important: To apply, candidates must provide a cover letter and a resume.

Discover the Perks of Being a City of Philadelphia Employee:

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
Pay off your student loans faster - As a qualifying employer, City of Philadelphia employees are eligible to participate in the Public Service Loan Forgiveness program. Join the ranks of hundreds of employees who have already benefited from this program and achieved student loan forgiveness.
Enjoy a Free Commute on SEPTA - Starting September 1, 2023, eligible City employees will no longer have to worry about paying for SEPTA public transportation. Whether you're a full-time, part-time, or provisional employee, you can seize the opportunity to sign up for the SEPTA Key Advantage Program and receive free Key cards for free rides on SEPTA buses, trains, trolleys, and regional rails.
Unlock Tuition Discounts and Scholarships - The City of Philadelphia has forged partnerships with over a dozen esteemed colleges and universities in the area, ensuring that our employees have access to a wide range of tuition discounts and scholarships. Experience savings of 10% to 40% on your educational expenses, extending not only to City employees but in some cases, spouse and dependents too!

Join the City of Philadelphia team today and seize these incredible benefits designed to enhance your financial well-being and personal growth!

The successful candidate must be a city of Philadelphia resident within six months of hire

Effective May 22, 2023, vaccinations are no longer required for new employees that work in non-medical, non-emergency or patient facing positions with the City of Philadelphia. As a result, only employees in positions providing services that are patient-facing medical care (ex: Nurses, doctors, emergency medical personnel), must be fully vaccinated.

The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race, ethnicity, color, sex, sexual orientation, gender identity, religion, national origin, ancestry, age, disability, marital status, source of income, familial status, genetic information or domestic or sexual violence victim status. If you believe you were discriminated against, call the Philadelphia Commission on Human Relations at 215-686-4670 or send an email to faqpchr@phila.gov.