Data Analyst

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 business intelligence platforms such as Power BI and ArcGIS is a plus
Knowledge and experience with R, Python, or PHP is also a plus
Knowledge of federal and/or Commonwealth of Pennsylvania taxation a plus
Master’s Degree in Information Systems, Computer Science, Accounting, Statistics or Economics/Finance or Bachelor’s Degree with relevant experience
Experience with moving a variety of data types (i.e.. CSV, fixed width, GeoDatabase, JSON) between a variety of systems (i.e.. FTP server, Relational Databases, APIs)
Experience with data warehousing and/or large scale databases

Set up automated extract, transform and load (ETL) workflows for internal and external data sources
Data transformation of various data sources from existing feeds and internally generated data
Identify opportunities for business process improvements and automation
Develop analyses and prepare various operational reports on revenues and accounts receivable to relevant stakeholders (internal and external)
Respond to information requests from both City agencies and outside partners
Perform locational analysis and geospatial visualizations using GIS software
Leveraging internal and external data sources to generate actionable leads for tax/water compliance and enforcement purposes
Develop, refine and adhere to data governance best practices for handling highly confidential taxpayer/water customer data

Knowledge and experience with GIS software is a plus
Knowledge and experience with business intelligence platforms such as Power BI and ArcGIS is a plus
Knowledge and experience with R, Python, or PHP is also a plus
Knowledge of federal and/or Commonwealth of Pennsylvania taxation a plus