Data & Process Analyst - Office of the Controller, Accounting Division (1823) - 150060

Job Description

Accounting Operations and Suppliers Division (AOSD) is responsible for monitoring, tracking and approving citywide financial transactions in conformance with established procedures and controls. It is also responsible for establishing and maintaining citywide guidelines, policies, procedures and internal controls. The City’s financial system, PeopleSoft, is used extensively in this work. The City’s reporting and analytical tool, BI, and Excel are also heavily used.

As part of the Supplier Management, Chartfield and Policy Team within the Accounting Operations & Suppliers Division (AOSD), performs professional-level and complex analytical work in the areas of data maintenance, reporting, and analysis; leads process enhancement projects to streamline Citywide employee reimbursement processes, workflows that require CON approval, and supplier onboarding processes; collaborates with other divisions in the Controller’s Office (CON) and other City departments to achieve the City’s financial and social economic strategic goals.

Essential Duties

• Create a comprehensive database of Citywide accounting/financial policies, job aids, canned responses, and other knowledge bases
• Adopt use of AI for City users’ accounting/financial questions and troubleshooting requests
• Automate and enhance workflows involving CON approval including Surplus Transfer, P-Card onboarding and maintenance, State Travel Program onboarding and maintenance, etc.
• Integrate data from third party applications for CON managed card programs (e.g., US Bank Access Online) with PeopleSoft, and build reporting tools for both City internal users and the general public
• Unify and enhance the business processes for Citywide travel purchases which are currently achieved through multiple mechanisms: employee reimbursement, P-Card, City booking from local travel agencies, and City booking through State Travel Program.
• Analyze and align business processes to enhance data governance and use of AI
• Prepare and develop metrics in calculating efficiencies and effectiveness of alignment of business process and technology
• Develop solution options and makes recommendations to management accordingly on various business process enhancement projects; prepare and deliver regular management reports
• Create and update desk procedures related to workflow design, report building, and data analysis; train and develop staff for succession planning
• Prepare analyses and analytical reviews of City departments’ financial data supporting year-end activities
• Create, validate and analyze the data for various departmental and Citywide projects
• Maintain, validate and analyze supplier profile and ChartField data in PeopleSoft as assigned
• Assume AOSD Financial & Accounting Support Team (FAST) assignments as necessary