Job Description

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

Qualifications

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

Additional Information

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 faqpchr@phila.gov. For more information, go to: Human Relations Website: http://www.phila.gov/humanrelations/Pages/default.aspx

#LI-OHR