With a workforce of over 30,000 people, and opportunities in more than 1,000 different job categories, the City of Philadelphia is the sixth largest city in the United States and one of the largest employers in Southeastern Pennsylvania. As an employer, the City of Philadelphia operates through the guiding principles of service, integrity, respect, accountability, collaboration, diversity and inclusion. Through these principles, we strive to effectively deliver services, to resolve the challenges facing our city, and to make Philadelphia a place where all of our residents have the opportunity to reach their potential. 

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 Research/Data Analyst to work with the Director of Research and Data Services Unit

The Data Analyst is responsible for working primarily with the Department of Revenue’s new 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; driving business process improvement and modeling future performance.

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 or identify new technologies that 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
• Performs 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

• Master’s Degree in Information Systems, Computer Science, Statistics or Economics/Finance or Bachelor’s Degree with relevant experience
• Experience with moving a variety of data types (ie. CSV, fixed width, GeoDatabase, JSON) between a variety of systems (ie. 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 is a plus
• Knowledge and experience with R, Python, STATA or PHP is also a plus
• Knowledge of federal and/or Commonwealth of Pennsylvania taxation a plus

Successful candidate must be a City 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 pchr@ phila.gov. For more information, go to: Human Relations Website at: http://www.phila.gov/humanrelations