IT Analyst 3-Free Library Data Analyst

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.

Qualifications :

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 (Education and Experience)

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.  Masters degree is preferred.  

Additional Information :

Salary: $70000-$85000

Salary cannot exceed $85000

Were 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 youre a good fit please dont 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 or send an email to faqpchr @. For more information go to: Human Relations Website:
Work :

No

Employment Type :

Full-time