Data and Research Manager
- 1401 John F Kennedy Blvd, Philadelphia, PA 19102, USA
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.
The Department of Revenue collects over $5 billion dollars from hundreds of thousands of taxpayers to support the School District of Philadelphia and City services and provides over $100 million in tax relief to a quarter million households. The Department of Revenue is seeking a Data and Research Manager to work with the Director of Data Intelligence and the Head of Data and Research.
The Data and Research Manager will manage a group of analysts that works primarily with tax and water customer data from internal City systems and external Federal, State, and third-party sources for the purposes of driving revenue generation, reporting on revenues and receivables, responding to information requests, and conducting data analysis/enhancement. The majority of the work is conducted in data warehouse environments using SQL Server tools.
Functions of the Data and Research Unit
- Develop analyses and prepare various operational reports on revenues and accounts receivables to relevant stakeholders (internal and external);
- Respond to information requests from both City agencies and outside partners. This involves utilizing data contained in the Department’s data warehouse environments to answer questions about revenues, receivables, and policy issues;
- Perform location analysis using GIS software;
- Prepare data extracts, perform file matches and create actionable leads out of data from both internal external sources for tax compliance and enforcement purposes;
- Set up automated extract, transform and load (ETL) workflows for internal and external data sources that make-up the unit’s Data Warehouse and Case Management (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 or identify new technologies that automate or streamline existing business processes;
- Design and operationalize predictive models to drive Department actions through implementation of proactive and innovative solutions.
Functions of the Data and Research Manager
- Manage the regular reporting of revenues and receivables;
- Manage the responses to information requests;
- Staff supervision with an emphasis on the support of staff development and team-building;
- Improve data quality – this includes recognizing any lack of data quality;
- Coordinate with Office of Information Technology (OIT) staff as well as other data groups in various City departments and agencies;
- Supervise outside user groups who conduct analyses using City tax data;
- Communicate with operational units within the Department of Revenue.
- Master’s Degree in Information Systems, Computer Science, Statistics or Economics/Finance (Bachelor’s Degree will be considered only if candidate has five or more years’ experience in both SQL Server and tax/water utility data);
- One or more years of experience with Microsoft SQL Server;
- One or more years of experience working with tax or water utility information.
- Ability to write queries in SQL Server;
- Must have a keen interest in public policy;
- Strong organization and management skills;
- Communication skills (both verbal and written);
- Ability to manage multiple projects/tasks simultaneously;
- Ability to recognize poor data quality and develop practical plans to proceed when data quality is an issue;
- Ability to review reports and analyses and look for consistency with other reports and information;
- Knowledge of economic theory, including industry sector classification systems and regional spatial/geographic analysis;
- Knowledge and experience with GIS software is a plus;
- Knowledge and experience with R, Python, STATA or various business intelligence platforms is a plus.
Please submit a resume and cover letter with your application.
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. For more information, go to: Human Relations Website: http://www.phila.gov/humanrelations/Pages/default.aspx