Data & BI Analyst jobs

IT Analyst 3-Free Library Data Analyst

City of PhiladelphiaPhiladelphia, PAFull-time5+ years experiencePosted 1 month ago

$75k–$85k/yr listed by the employer

This job is closed.

The employer took it down 8 days ago, after 12 days open. Here are similar open jobs.

  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: Pay listedJob posting
  • Checked: No reposts foundSmartRecruiters board
  • Note: Last seen open 9 days agoLive check
  • Trust score 100 / 100 · Strong
See all 5 checksShow fewer
How we check

Similar open jobs

Senior Data Analyst

City of Philadelphia · Philadelphia, PA

$110k/yrFull-timeOn-site

StrongChecked open todayPosted 1 month ago

See more like this

What you’ll do

  • Acquire, clean, and validate data from internal and external sources; query databases to retrieve and analyze it.
  • Perform statistical, predictive, and other data analyses, and develop data-driven hypotheses and models.
  • Create visualizations, reports, summaries, and recommendations for technical and non-technical audiences.
  • Document datasets, scripts, workflows, and standard operating procedures; ensure data privacy and compliance.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • Five or more years of relevant professional experience
  • Experience developing statistical methods and analyses, including predictive analytics and correlation and regression models using appropriate statistical software
  • Experience using industry-standard data visualization and graphics tools to create professional reports and presentations, web content, and educational materials
  • Experience with cloud services and data management (preferred)
  • Experience with Tableau and/or Power BI (preferred)
  • Experience handling regulatory requirements related to PII (preferred)
  • Experience with parcel mapping, editing, and parcel management (preferred)
  • Experience using the ESRI ArcGIS software suite to publish data and produce GIS applications (preferred)
  • Experience with multi-user versioned and distributed editing and replication in an ArcGIS Server/ArcGIS SDE 10.x environment (preferred)

Education

  • Baccalaureate degree from an accredited college or university, with major coursework in GIS, Geography, Urban Planning, Public Health, Statistics, Information Science, or Civil Engineering
  • Master’s degree (preferred)

Skills

  • Proficiency with R and/or Python, and SQL
  • Proficiency in developing database query strategies for spatial and non-spatial relational databases
  • Ability to effectively communicate complex technical information to diverse audiences
  • Proficiency in spatial data creation, editing, and maintenance (preferred)

Other requirements

  • Willingness to expand professional competency through continuing education and training
  • Philadelphia resident within six months of hire
  • Include a cover letter with the application

Benefits

Health insurance
Comprehensive health coverage for employees and eligible dependents
Retirement plan
Generous retirement savings options
Paid time off
Paid vacation, sick leave, and holidays
Learning & tuition
Public Service Loan Forgiveness Program qualified employer; 25% tuition discount program for City employees, and sometimes spouses and dependents, through area colleges and universities
Wellness & mental health
Wellness program eligibility for a discounted medical plan

Full job description

From City of Philadelphia’s careers site

Company Description

Show full descriptionShow less

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

http://www.phila.gov/humanrelations/Pages/default.aspx

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:

Something wrong with this job? Report it