Data/Reporting Analyst II (Treasury Services) at City of Atlanta

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. 

• Provides general administrative support including routine correspondence, memoranda, and letters; provides responses to FOIA Open Records for review; and other duties as assigned.

The above statements reflect the general duties, responsibilities and competencies considered necessary to perform the essential duties and responsibilities of the job and should not be considered as a detailed description of all the work requirements of the position. COA may change the specific job duties with or without prior notice based on the needs of the organization.

Knowledge Skills and Abilities:

This is a partial listing of necessary knowledge, skills, and abilities required to perform the job successfully, it is not an exhaustive list.

• Strong understanding of banking and cash management reporting, including regulatory requirements, data formats, and emerging financial technologies.

• Proficient in data analysis and Excel, with the ability to identify trends, variances, and inconsistencies across multiple data sources.

• Skilled in preparing, interpreting, and presenting analytical reports and financial summaries.

• Excellent written and verbal communication skills and interpersonal skills are required; able to collaborate effectively with internal teams and external partners.

• Proven accuracy, attention to detail, and performance under pressure in fast-paced or ambiguous environments.

• Ability to quickly sift through various inputs and arrive at a logical, executable conclusion

• Strong problem-solving, analytical thinking, and decision-making abilities.

• Capable of prioritizing multiple tasks, managing deadlines, and working independently.

• Adept with Microsoft Office Suite (Excel and PowerPoint); Oracle and accounting knowledge preferred.

• Self-motivated with a proactive and positive attitude, demonstrating strong interpersonal and team-building skills.

Minimum Qualifications:

• Bachelor’s Degree in Business Administration, Public administration, Accounting, Finance, Statistics or a related field; OR an equivalent combination of education, skills, experience, and training.

• Minimum of (3) years of work experience in creation, reporting, and/or management of data or closely related tasks (not including data entry; equivalent professional experience may be considered for substitution).