Excel jobs in United Kingdom

The City’s Auditing Division promotes an honest, effective, and fully accountable City government. It strives to provide independent, timely oversight of the City’s finances and operations to ensure that City programs are implemented legally, efficiently, and effectively. The Division functions as a safeguard against potential fraud or misuse of City resources. Auditing contributes to deadline-driven documents such as the Annual Comprehensive Financial Report, Schedule A, and the Per-Pupil Report, which play a crucial role in providing financial and other information to the City Council, City Manager, the investment community, the state and federal governments, and the residents of Cambridge. The Auditing Division uses electronic processing of accounts payable payments and journal entries in order to reduce paper usage and create an efficient method for tracking information electronically.

Reporting directly to the City Auditor and Assistant City Auditor, this position will provide timely, accurate, and efficient financial reporting for the City of Cambridge. This includes but is not limited to submission of fiscal reporting documents such as the Comprehensive Annual Financial Report (CAFR), Schedule A, and the Per-Pupil Report. This position will play a crucial role in providing financial and other information to the City Council, City Manager, the investment community, the state and federal governments, and the residents of Cambridge.

Duties and responsibilities include, but are not limited, to the following:

• Monitoring the City’s financial systems to ensure all accounting transactions are accurate and complete.
• Researching and resolving all financial/payroll system posting errors or discrepancies.
• Providing assistance with the preparation of year-end closing and all required financial statements.
• Assisting in the compilation of the annual “Annual Comprehensive Financial Report” (ACFR) which includes, but not limited to, populating footnotes, required information, and statistics section of the report.
• Working closely with external auditors on the research and implementation of new GASB pronouncements.
• Assisting in the compilation of the A-133 Schedule of Expenditures of Federal Awards and the state required Schedule A Report.
• Supporting external auditors on various projects conducted during the calendar and fiscal year.
• Compiling Fund Statements which includes loading the trial balance and completing all necessary journal entries.
• Prepare monthly grant, capital and trust fund reports.
• Prepare monthly reconciliations for fixed assets, real estate and personal property abatements.
• Maintain Fixed Assets system and related module.
• Preparing and posting journals as needed.
• Participating in all financial system implementations and upgrades.
• Managing multiple schedules and tasks.
• Acting as a liaison between the Auditing Department and all other City Departments requiring assistance in resolving accounting, financial, and system issues.
• Performing other duties as assigned.

Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

• Bachelor’s Degree in Accounting or related discipline, or equivalent combination of education, training and experience.
• Minimum of four years of successful accounting experience, preferably in a public sector organization or school district.
• Extensive working knowledge of computerized financial systems.
• Proficiency in MS Word and Excel is required.
• Strong interpersonal skills and excellent communication skills, both written and verbal.
• Highly organized and detail-oriented individual able to work both as part of a team and individually.
• Demonstrated project management experience highly desirable.

Ability to access, input, and retrieve information from a computer. Answer telephones and maintain multiple files. May require minimal lifting of up to 10 pounds.

General office environment with air conditioning and fluorescent lighting. Requires attendance at meetings. Noise level can be high as the office is active with phone calls and walk in applicants.

Please upload the following documents to complete your application:

• Resume
• Cover Letter