Data Analyst

  • Full-time

Company Description

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 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 has recently implemented a Data Warehouse and Case Management (DWCM) System. This new system allows the Department 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 to take the appropriate collection action at the right time, tailored for each account.

Job Description

POSITION SUMMARY

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 has recently implemented a Data Warehouse and Case Management (DWCM) System. This new system allows the Department 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 to take the appropriate collection action at the right time, tailored for each account.

SALARY - Commensurate with experience

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 scripts and deploy custom packages using SQL Server tools (SSIS, SSMS, SSRS, etc..)
  • Knowledge and experience with GIS software is a strong plus
  • Knowledge and experience with R, 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

Qualifications

  • 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

Additional Information

Please include a resume and cover letter with your application.

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

The successful candidate must reside in the City of Philadelphia or establish primary residence in the City of Philadelphia within 6 months of employment.