Data Analyst (Free Library of Philadelphia)

Company Description

As a top-tier city attracting premier talent, Philadelphia presents an extraordinary platform to shape a career. With our blossoming art scene, deep-rooted history, and a culture fostered on passion and tenacity, there are endless reasons to adore living and working here. As part of a workforce of over 30,000 individuals across more than 1,000 diverse job categories, the City of Philadelphia provides limitless opportunities to make a difference. As an employer, the City of Philadelphia highly values inclusion, integrity, innovation, empowerment, and hard work. We offer a lively work environment, comprehensive health care and benefits, and the experience required to grow and thrive. If you're eager to join a team dedicated to the future of Philadelphia, your journey starts here. What We Offer: •    Impact - Your work here affects millions. •    Growth - Philadelphia is expanding, why not expand with it? •    Diversity & Inclusion - Build a career where everyone is welcomed. •    Benefits - We care about your well-being. The Office of Innovation & Technology (OIT) is the City of Philadelphia's leading IT agency, headed by the Chief Information Officer (CIO). OIT oversees the city's key information and communications technology initiatives, focusing on enhancing the capability of the city's IT infrastructure, ensuring services offered are leading-edge, efficient and align with the needs of Philadelphia's businesses, residents and visitors. OIT's responsibilities include formulating effective strategies to implement new IT directions across city government, increasing the value of the city's technology assets, ensuring a positive return on technology investments, safeguarding data security, making contingency plans for disruption of IT and communication services, and supporting an accountable, efficient, and effective government across all city departments, boards, commissions, and agencies. The Free Library of Philadelphia (FLP) ranks among the world's largest public library systems. As an integral pillar of the Philadelphia community, FLP's mission is to foster literacy, guide learning and stimulate curiosity. FLP's ultimate vision is to nurture an enlightened society committed to lifelong learning. For over a century, FLP has been a proponent of education both inside and outside the classroom, by providing cost-free resources for literacy and learning.

Job Description

The Free Library of Philadelphia seeks a skilled Data Analyst to join the Research & Data Analytics group within the Performance Management and Technology Division. The ideal candidate will have extensive experience in all aspects of data analytics, including data acquisition and cleaning, descriptive, prescriptive and predictive analytics, and data visualization. The Data Analyst will generate organizational value through exceptional analytical skills and a firm understanding of functional domains, delivering actionable data products, analyses and reports in line with Performance Management objectives. The Data Analyst will work collaboratively with Performance Management and Technology staff to recognize program objectives and oversee complex projects. The Data Analyst may manage the daily responsibilities of associate data coordinators, including mentoring, evaluation, and ensuring adherence to standard operating procedures. Essential Functions •    Source data from various internal and external databases. Verify data accuracy and integrity by cleansing and preprocessing the data. •    Employ suitable statistical analysis methodologies to spot and identify patterns, trends, and correlations. •    Visualize data using industry-standard tools (Tableau, Power BI, Excel) for effective portrayal of results. •    Prepare and present reports, summaries, and proposals to audiences with varying levels of technical expertise. •    Design and test data-driven hypotheses to answer specific questions. •    Develop predictive models, such as regression, AI, machine learning, or time series models to forecast trends and outcomes. •    Work with database systems to retrieve, manipulate, and analyze data effectively. •    Write SQL queries to extract relevant data. •    Collaborate with cross-functional teams to understand data requirements and deliver actionable insights. •    Guarantee data security and compliance with data privacy regulations. •    Prepare standard operating procedures (SOPs) and ensure comprehensive documentation of datasets, scripting routines, and workflows. •    Supervise junior staff, interns, identify mentoring opportunities and provide aid as needed. •    Serve as a Subject Matter Expert for Library agencies to ensure compliance with appropriate data management, integration, and sharing protocols. •    Participate in meetings and events within the department, city, and the broader data analytics community. •    Present reports at department meetings, informational sessions, and selected 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 forming database query strategies from spatial and non-spatial relational databases. •    Ability to communicate complex technical information effectively to diverse audiences. •    Excellent written and oral communication skills and strong project planning, organization, and time management skills. •    Ability to develop and maintain good working relationships and collaborations while independently undertaking initiative. •    Willingness to expand professional skills by availing appropriate continued education and training opportunities. Preferred •    Experience with cloud services and data management. •    Experience with Tableau and/or PowerBI applications. •    Experience adhering to 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. •    Experience with multi-user versioned and distributed editing, replication in ArcGIS Server/ArcGIS SDE 10.x environment.

Qualifications

A minimum of five years of relevant professional experience is required. Must hold a Bachelor's degree from an accredited college or university with major coursework in Information Science, Statistics, Data Science, Information Management, Geographic Information Systems (GIS), Urban Planning, or a related field. A 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: •    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. •    Accelerate your student loans repayment - As a qualifying employer, City of Philadelphia employees are eligible to participate in the Public Service Loan Forgiveness program. Join hundreds of employees who have already benefited from this program and achieved student loan forgiveness. •    Enjoy Free Commute on SEPTA - Starting September 1, 2023, eligible City employees will enjoy free SEPTA public transportation. Full-time, part-time, or provisional employees can sign up for the SEPTA Key Advantage Program and receive free Key cards for complimentary rides on SEPTA buses, trains, trolleys, and regional rails. •    Unlock Tuition Discounts and Scholarships - The City of Philadelphia has 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, spouses and dependents too! Join the City of Philadelphia team today and seize these tremendous benefits designed to enhance your financial stability and personal growth!

*The successful candidate must become a resident of Philadelphia within six months of hire

Effective May 22, 2023, vaccinations are not required for new employees in non-medical, non-emergency or non-patient facing positions with the City of Philadelphia. Therefore, only employees in roles that provide patient-facing medical care services (e.g., Nurses, doctors, emergency medical personnel) need to 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 have been discriminated against, call the Philadelphia Commission on Human Relations at 215-686-4670 or email [email protected].