Principal Accounting/Financial Analyst
6 days ago
Cambridge
ABOUT THE DEPARTMENT:\n 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 to reduce paper usage and create an efficient method for tracking information electronically. \nESSENTIAL DUTIES & RESPONSIBILITIES:\n This position works as part of the Financial Reporting Team and reports directly to the General Ledger Accountant. This team works together to provide timely, accurate, and efficient financial reporting for the City of Cambridge and also produces a Comprehensive Annual Financial Report (CAFR), an A‑133 Schedule of Expenditures of Federal Awards, and various state‑required reports. Responsibilities include daily/weekly/monthly reconciliations as well as a functional knowledge of accounting adjustments, audit procedures, and financial statement preparation. Specific duties include but are not limited to the following: \n\n • Assist in monitoring the financial system, research, and resolve accounting errors or discrepancies. Prepare and post journal entries as needed.\n, • Reconcile and post accounts payable journals.\n, • Prepare monthly capital and grant fund balance reports. Assist with month‑end tasks.\n, • Monthly reconciliation of general ledger cash balance to treasury cash balance.\n, • Review budget journals for accuracy and reconcile with approved council orders.\n, • Complete accounts receivable roll forward. Monitor balance sheets to ensure receivables are in balance.\n, • Prepare monthly reconciliations for fixed assets and payroll withholding accounts.\n, • Participate in all financial system implementations, upgrades, and testing.\n, • Help all City Departments resolve any accounting, financial, or system inquiries.\n, • Assist with fiscal year‑end close and the preparation of all required financial statements.\n, • Assist in the compilation of the annual “Comprehensive Annual Financial Report” (CAFR) which may include but is not limited to: preparing adjusting journal entries in accordance with GAAP, maintaining a trial balance, populating footnotes, financial statements, and the statistical section of the report and other required information.\n, • Complete the State‑required ‘Schedule A’ report.\n, • Assist in the compilation of the A‑133 Schedule of Expenditures of Federal Awards (SEFA).\n, • Support the General Ledger Accountant and external auditors on various projects as needed.\n, • Complete duties of other team members in their absence.\n, • Bachelor’s degree in accounting or related discipline required.\n, • Minimum of two years of successful accounting experience, preferably in a public sector organization or school district.\n, • Highly organized and detail‑oriented individual able to handle multiple tasks while working in both a team environment as well as independently with minimal supervision.\n, • Extensive working knowledge of computerized financial systems.\n, • Working knowledge of PeopleSoft Financials and/or HRMS and MUNIS a plus.\n, • Proficiency in the Microsoft Office Suite, particularly MS Excel and Word, is required.\n, • Resume\n, • Cover Letter\n\n#J-18808-Ljbffr