IT Analyst 3-Free Library Data Analyst

City-of-Philadelphi; Philadelphia (Philadelphia County); Presencial; USD 75.000 - 85.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Health insurance

Wellness program

Paid vacation

Retirement plan

Tuition discount

Descripción de la vacante

The City of Philadelphia's Office of Innovation & Technology, in partnership with the Free Library of Philadelphia, seeks a Data Analyst to join the Research & Data Analytics group. The role will cover data acquisition, cleaning, and descriptive, prescriptive and predictive analytics, plus data visualization to deliver actionable insights aligned with Performance Management objectives.

You will work with cross-functional teams, supervise junior staff, and help prepare SOPs and datasets

Formación

• Proficiency with R and/or Python, and SQL programming languages.
• Experience developing statistical methods and analyses including predictive analytics, and correlation and regression models.
• Experience using industry standard data visualization and graphics tools for creation of professional reports and presentations.
• 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.

Responsabilidades

• 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.

Conocimientos

R and/or Python

SQL

Data visualization

Statistics / Modeling

Communication

Project Management

Collaboration

Educación

Bachelor's degree in GIS/Geography/Urban Planning/Public Health/Statistics/Information Science/Civil Engineering

Master's degree preferred

Herramientas

ArcGIS

Tableau

Power BI

Excel

Descripción del empleo

• Compensation: USD 75,000 - USD 85,000 - yearly

Company Description

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.

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 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.

Additional Information

Salary cannot exceed $85,000

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:
http://www.phila.gov/humanrelations/Pages/default.aspx