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. 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. Master’s degree is preferred. 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. Salary: $75,000-$85,000 Salary cannot exceed $85,000 We’re interested in hiring the best possible candidate for the role. We recognize that experience, education, and qualifications can be attained in a variety of ways and that many skillsets are transferable. If you feel you’re a good fit, please don’t hesitate to apply. Please include: • Resume • A cover letter Please note: Applications will not be considered without a cover letter. Did you know? ● 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 *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. For more information, go to: Human Relations Website: phila.gov

Requirements

Must-haves

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.

Nice-to-haves

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.
Salary: $75,000-$85,000
Salary cannot exceed $85,000

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

aimachine learningsqlpythongo

Platform: smartrecruiters
Effort: medium

Benefits

Benefits detected in the listing.

Vision

Wellness