Reporting Database Coordinator

The Local Government Reporting Database Coordinator manages engagement agreements, processes around 3,600 financial reports annually, and prepares documents for public issuance. This position monitors CPA firm engagement costs, serves as a records liaison, and collaborates with the Local Government Reporting, Records Management, and IT teams. The position involves frequent communication with CPA firms and operates under strict deadlines, especially around major reporting dates.

    Essential Competencies and Skills

      Communication:

• Communicates confidently and tactfully with supervisors, colleagues, agency personnel, and external CPAs.
• Prepares clear, concise, and well-organized written documentation with proper grammar and spelling.
• Keeps supervisors informed on assignment status.
• Builds effective working relationships with all departments and LLA staff

     Professional Conduct:

• Adheres to LLA standards of conduct, independence, ethics, and confidentiality while maintaining a positive attitude.
• Remains flexible to changing work schedules and tasks, including working overtime when required.
• Meets productivity level of 70% (excluding K-time use).

     Job Knowledge and Skills:

     Engagement Agreements

• Receive, review for compliance, and approve engagement agreements; and
• Enter engagement agreements in the various applicable databases, checking the information for accuracy.

      Receive Financial Reports

• Receive and review for completeness financial reports submitted through the portal and via email, and contact the CPA for any missing information;
• Enter the report and related information in the database; and
• Assign reports, when necessary, to various team members or the manager.

     Issue Financial Reports

• Process financial reports that have been reviewed and prepare them for upload into the audit library and issuance by the Records Management team

     Engagement Costs

• Monitor compliance with the requirement for CPA firms to submit actual engagement costs

     Other Specific Job Duties and Responsibilities

• Set up new local auditees and work with others to maintain information in the various databases
• Receive and process annual budgets
• Serve as a records liaison between the Local Government Services section and Records Management to ensure compliance with the LLA’s record retention policy

• An Associate degree in accounting or finance from an accredited college or university, OR
• Five years’ experience working in Word, Excel, and database software, including running database queries, AND
• Five years’ experience working with financial reports or in an auditing/accounting environment.