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.

  Opportunities in Tech - Don’t wait for the future, shape it.

  Benefits - We care about your well being.

Agency Description

The Department of Revenue collects over $5 billion from hundreds of thousands of taxpayers to support the School District of Philadelphia and City services, and collects more than $650 million in water bills. It provides $150 million in tax relief to a quarter million households. In the exercise of its mission, the Department mailed out an estimated 11.8 million letters to Philadelphia residents and business owners last year. This is in addition to thousands of emails and other digital communication the Department exchanges annually with taxpayers and water customers. The Department is currently replacing its existing tax system. It is redesigning and improving interactions with the public as part of this multi-year process.

The Department of Revenue is seeking a Research/Data Analyst who will be responsible for working primarily with the Department of Revenue’s existing Data Warehouse and Case Management (DWCM) environment utilizing taxpayer and water customer data from internal City systems and external Federal, State and third-party sources for the purpose of driving revenue generation; conducting data analysis/enhancement. The successful candidate will utilize experience in data analytics, process improvement, and business intelligence to support the department’s enforcement and reporting efforts.

Essential Functions

The job will involve primarily using SQL Server suite of data management and reporting tools to work in the Department’s DWCM environment, in support of the Department’s core mission of generating revenue in support of schools and services. The position will:

•  Set up automated extract, transform and load (ETL) workflows for internal and external data sources that make-up the DWCM environment
• Data transformation of various data sources not related to automated ETL workflows.
• Identify opportunities for business process improvements and automation. Use existing DWCM capabilities, identify new technologies and leverage the new ITS to automate or streamline existing business processes.
• Develop analyses and prepare various operational reports on revenues and accounts receivables to relevant stakeholders (internal and external), automating and streamlining the reporting whenever possible
• Respond to information requests from both City agencies and outside partners. This involves utilizing data contained in the Department’s DWCM environment to answer questions about revenues, receivables, and policy issues
• Perform location analysis using GIS software
• Perform data extracts, file matches and create actionable leads out of data from both internal external sources for tax compliance and enforcement purposes.
• Design and operationalize predictive models to drive Department actions through implementation of proactive and innovative solutions

Education and Experience

• Master’s Degree in Information Systems, Computer Science, Accounting, Statistics or Economics/Finance or Bachelor’s Degree with relevant experience outlined below
• Experience with moving a variety of data types (CSV, fixed width, GeoDatabase, JSON) between a variety of systems (FTP server, Relational Databases, APIs)
• Experience with data warehousing and/or large scale databases

Competencies, Knowledge, Skills and Abilities

• Ability to write queries in SQL Server
• Must have a keen interest in public policy
• Knowledge and experience with GIS software, a plus
• Knowledge and experience with business intelligence platforms such as Power BI and SAS Visual Analytics, a plus
• Knowledge and experience with R, Python, STATA or PHP, a plus
• Knowledge of federal and/or Commonwealth of Pennsylvania taxation, a plus

Salary Range: $60,000 - $70,000

Please submit a cover letter and resume with your application. Applications without all documents will not be considered.

Did you know?

• We are a Public Service Loan Forgiveness Program qualified employer
• Employees are eligible for a 25% tuition discount program (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 

Successful candidate must be a city of Philadelphia resident within six months of hire

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

#LI-OHR