City of Philadelphia

Senior Data Analyst

Sep 01, 2023

Philadelphia, PA, United States

Company Description

A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. With a workforce of over 30,000 people, and more than 1,000 different job categories, the City of Philadelphia offers boundless opportunities to make an impact.

As an employer, the City of Philadelphia values inclusion, integrity, innovation, empowerment, and hard work above all else. We offer a vibrant work environment, comprehensive health care and benefits, and the experience you need to grow and excel. If you’re interested in working with a passionate team of people who care about the future of Philadelphia, start here.

What we offer

  • Impact - The work you do here matters to millions. 
  • Growth - Philadelphia is growing, why not grow with it? 
  • Diversity & Inclusion - Find a career in a place where everyone belongs.
  • Benefits - We care about your well-being.

Agency Description

The Department of Revenue collects over $5 billion dollars from hundreds of thousands of taxpayers to support the School District of Philadelphia and City services and provides over $100 million in tax relief to a quarter million households. The Department of Revenue is seeking a Senior Data Analyst to work with the Tax Enforcement Unit.

Job Description

This position is multi-disciplinary and will focus on assisting with revenue collection and reporting.  Employee will have responsibility for researching, collecting data and performing statistical analysis needed to monitor trends in tax and revenue collections and to support collection operations.  Additional analysis will also be conducted of collection programs and initiatives, in order to determine their effectiveness, efficiency, and results.  The employee will work with multiple managers and/or other more senior staff members within the Collections Division.  The employee will also be expected to interact with other groups within Revenue, as well as other City agencies.   The employee will report directly to the Deputy Revenue Commissioner, for Collections.

Essential Functions

  • Designs research and information systems projects; may act as project leader assuming such tasks as identifying resource needs and setting time frames for the completion of project phases; conducts research utilizing selected data collection methods; designs and constructs computer files, analytical processes, and output reports. 
  • Performs evaluation and analysis of data using standard statistical or database analysis methods; prepares reports documenting results of findings; makes recommendations based on findings to improve departmental operations; may participate in formal presentations of research findings.
  • Confers with departmental representatives; reviews policies, procedures, forms and systems used for data collection.
  • Designs new or modifies current systems and programs based on assessed needs using query languages, report writers, interactive database programs, spreadsheets and/or application generators; monitors system resources to ensure effective operation of computer applications; performs related duties which include modifying computer data bases designing source and output documents, developing schedules for the input of data, and testing new programs.
  • Analyzes departmental database extract files reflective of Department of Revenue operations including revenue collections; provides information on business development and growth; identifies existing gaps in information needs; assists in designing new files to meet additional data needs; tests accuracy of data integrity and preparation work.
  • Designs research lists for data purification, tax compliance and/or tax collection; write programs using SQL Server; write queries in Access; provides technical assistance, consultation, training and direct support to staff on research, evaluation and information management activities.
  • Performs comparative research on data compiled by Department of Revenue, and revenue departments in other municipalities.
  • Performs related work as required

Competencies, Knowledge, Skills and Abilities

  • Problem Solving
  • Data Interpretation and Presentation
  • Attention to Detail
  • Critical Thinking
  • Verbal and Written Communication


Working hours are generally 37.5 hours per week. Our team is currently hybrid with both virtual and in-office days, however the position can opt to come in the office each day if desired.


Four (4) years of progressive and relevant work experience employing data analysis and statistics using large amounts of complex data housed in data warehousing systems; identifying trends and patterns; and assisting management with fact-based decision making. Ability to tell stories with data and communicate across the organization. Independence, creativity, problem-solving, and passion for public service desired.

Additional Information

TO APPLY: Interested candidates must submit a cover letter and resume.

Salary Range: $79,000 - $85,000

Discover the Perks of Being a City of Philadelphia Employee:

  • 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
  • Pay off your student loans faster - As a qualifying employer, City of Philadelphia employees are eligible to participate in the Public Service Loan Forgiveness program. Join the ranks of hundreds of employees who have already benefited from this program and achieved student loan forgiveness.
  • Enjoy a Free Commute on SEPTA - Starting September 1, 2023, eligible City employees will no longer have to worry about paying for SEPTA public transportation. Whether you're a full-time, part-time, or provisional employee, you can seize the opportunity to sign up for the SEPTA Key Advantage Program and receive free Key cards for free rides on SEPTA buses, trains, trolleys, and regional rails.
  • Unlock Tuition Discounts and Scholarships - The City of Philadelphia has forged 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, spouse and dependents too!

Join the City of Philadelphia team today and seize these incredible benefits designed to enhance your financial well-being and personal growth!

*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 [email protected].

For more information, go to: Human Relations Website:

Join 27118+ Machine Learning Engineers, receiving daily job alerts.