Data Analyst (Accounting)

Job Description

The Accounting Data Analyst is responsible for working primarily with the Department of Revenue’s Data and Research Unit to prepare reports on revenues and receivables. Most of the work will be performed in a 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 purposes of reporting and revenue generation. The Department is in the process of implementing a new Integrated Tax System (ITS), thus business process improvement and data modeling to improve operational performance will also be a significant focus going forward.

The job will involve primarily using SQL Server suite of data management and reporting tools to work in the Department’s DWCM environment. The position will:

• Prepare accounting schedules for incorporation into the Comprehensive Annual Financial Report (CAFR) of the City of Philadelphia, using tables stored in a data warehouse environment
• Prepare monthly and quarterly reports on revenues and receivables for management purposes, using tables stored in a data warehouse environment
• Prepare and maintain interactive reports using tools such as Microsoft Power BI for management.
• Develop analyses and prepare various operational reports on revenues and accounts receivables to relevant stakeholders (internal and external)

Qualifications

• Master’s Degree with a major in Accounting or Bachelor’s Degree with a major in accounting plus relevant accounting experience
• Experience with data warehousing and/or large-scale databases

• Knowledge and experience with basic accounting principles and practices
• Ability to write queries in SQL Server
• Knowledge and experience with governmental accounting is a plus
• Knowledge and experience with business intelligence platforms such as Power BI and SAS Visual Analytics is a plus
• Knowledge and experience with R, Python, STATA or PHP is a plus
• Knowledge of federal and/or Commonwealth of Pennsylvania taxation a plus

Additional Information

Please submit a cover letter and resume with your application.Applications without all required documents will not be considered. A referencelist is optional.

• 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

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

#LI-OHR