With a workforce of over 30,000 people, and opportunities in more than 1,000 different job categories, the City of Philadelphia is the fifth 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 mission of the Department of Revenue is the timely, courteous and prompt collection of all revenue due to the City of Philadelphia, and all tax revenue due to the School District of Philadelphia. The Department of Revenue is in the process of implementing a Data Warehouse and Case Management (DWCM) System. This new system will allow us to bring all information about anyone with financial obligations to the City of Philadelphia, such as payments and balances for taxes, fees, fines and water charges, into one place and provide the tools for us to take the appropriate collection action at the right time, tailored for each account.

POSITION

This position works with the Director of Data Services Unit. Working primarily in the Department of Revenue’s new DWCM environment, the Data Analyst will utilize 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 and other database management 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:

• Maintain and enhance DWCM functionalities.
  
• Set up automated extract, transform and load (ETL) workflows for internal and external data sources that make-up the DWCM environment.
  
• 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.
  
• 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.
  
• Analyzes data sources to identify any existing gaps in information needs.
  

COMPETENCIES, KNOWLEDGE, SKILLS, AND ABILITIES

• Ability to write queries in SQL Server
• Knowledge and experience with GIS software is a plus
• Knowledge and experience with SAS, STATA, XML or PHP is also a plus 
• Must have a keen interest in public policy
• Knowledge of federal and/or Commonwealth of Pennsylvania taxation a plus

• Masters 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.
  

Interested applicants should submit a current resume and cover letter.

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