The Philadelphia Department of Revenue seeks a Data Analyst to support our Data Warehouse and Case Management System. The data warehouse allows the Department to bring 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 to take the appropriate collection action at the right time, tailored for each account.

The ideal candidate must have a gift for envisioning how data from multiple sources can be harnessed into one seamless system, that will ultimately support the Department’s core mission of generating revenue in support of city services and the Philadelphia School District .

The ideal candidate for this position is a/an:

  • Software and systems guru: SQL Server user, GIS software, and other database management tools to work in the Department’s data warehouse environment. You’ll maintain and enhance data warehouse functionalities, and set up automated extract, transform and load (ETL) workflows for internal and external data sources that make-up the data warehouse environment.
  • Problem solver:  Identifies opportunities for business process improvements and automation. Able to use existing data warehouse capabilities or identify new technologies that automate or streamline existing business processes. Identify creative ways to report relevant information to executive staff and stakeholders.
  • Excellent communicator:  Creative in communicating complex data information in a clear and concise manner.  Able to prepare various operational reports on revenues and accounts receivables to relevant stakeholders (internal and external), automating and streamlining the reporting whenever possible.
  • Analytical thinker:  Able to perform data extracts, file matches and create actionable leads out of data from both internal and external sources for tax compliance and enforcement purposes. Analyzes data sources to identify any existing gaps in information needs.

Qualifications

  • 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
  • Ability to write scripts and deploy custom packages using SQL Server tools (SSIS, SSMS, SSRS, etc..)
  • Knowledge and experience with GIS software is a strong plus as well as knowledge and experience with R, SAS, STATA, XML or PHP
  • Must have a keen interest in public policy
  • Knowledge of federal and/or Commonwealth of Pennsylvania taxation a plus

Salary – Commensurate with experience

Photo Credit: Justin Grimes, Flickr

Get the full details and application instructions
Complete information and application instructions for this opportunity.