Data/Reporting Analyst II (Treasury Services)

Posting Expires: 11/7/25

Salary Range: $47,474.94- $62,500.00

General Description and Classification Standards:

The data/reporting analyst is a vital position within the City’s Office of Treasury, Debt and Investments. The primary responsibility is to ensure the accurate and efficient management of transactional banking operations for accounts supporting the city. This involves operational activity supporting banking processes within the City’s financial structure.

This position requires attention to the details of services provided by the banking institutions; performs reporting and analysis work in support of departmental requirements for cash operations; maintains oversight of operational policies and procedures in conjunction with banking operations; and acts as liaison for departmental operations. Designs, prepares, and summarizes reports by consolidating data from multiple sources. Sources of data may be enterprise systems, complex spreadsheets, databases, banking reports, etc. 

Essential Duties and Responsibilities:

These are typical responsibilities for this position and should not be construed as exclusive or all inclusive. May perform other duties as assigned.

Cash Operations Management

• Knowledge of banking reporting methods, formats, regulatory requirements, and technology advancements related to cash management systems. 

• Serves as the lead administrator regarding access and authorizations for all banking relationships.  Responsible for ensuring the structure of all banking requirements are met as they are added or removed. 

• Must execute appropriate cash operation transactions and provide customer service both internally (Treasury and City Departments) and externally (Banks, Invest Atlanta) to execute banking and system transactional needs and resolve errors.

• Responsible for processing wire transactions internally and on behalf of Invest Atlanta; that include wire transfers, book transfers, operating transfer, cash management entries, adding new accounts, and related tasks.

• Uses banking platforms and Treasury Management Systems as tools to accomplish daily goals.

• Uses the Oracle cash management module for general tasks; establishes new accounts; assists in the execution of debt payments ensuring timeliness and accuracy.

• Responsible for the review of all bank statements, analyzing deposits and withdrawals against internal reporting; and acts as a technical advisor to the department regarding bank account updates.

• Monitor and oversee fraudulent banking activity and ensure follow-up to avoid any loss.

• Monitor/oversee the compilation/distribution of City-wide merchant accounts information

Reporting & Other   

• Manages the Treasury SharePoint documents and filing system; Assumes responsibility for maintaining accuracy of assigned operating records and/or databases; Downloads, organizes and distributes as necessary all bank statements; Documents all standard financial reports; Provides operational reviews of administrative, operational, and financial processes for cash operation activity.

• Retrieves and summarizes data from various information systems for inclusion into research, open records requests, or operating reports.

• Develop and maintain professional relationships with those in similar positions in surrounding local government areas.

• Execution of certain Administrative/HR tasks as needed (i.e.- internal/external correspondence via letters, memos, etc.) 

• Perform Cash Management Accounting Entries in Oracle.

• Maintain records according to the records retention schedule and purge quarterly.

• Reviews the monthly close tracking tool from the General Accounting for completeness on behalf of the Treasury Department. 

• Supports stakeholders by gathering data and required documents to address incomplete tasks; May participate in the reconciliation of accounts in support of journal entries; Maintains all monthly/quarterly reconciliations within shared files. Interacts with line staff, managers, and supervisors during normal course of business tasks.