Fiscal Affairs Analyst

Company: City of Cambridge
Location: Cambridge
Posted on: September 23, 2022

Job Description:

ESSENTIAL DUTIES AND RESPONSIBILITIES: This position works as part of the Office of Planning Budget and Personnel and reports directly to the Director of Planning, Budget, and Personnel. The Fiscal Affairs Analyst will assist the Director with all the Department's fiscal matters. The Analyst will assist with the duties of the Account Clerk, and/or Payroll Coordinator in their absence. The work requires developing a thorough knowledge of the City's payment and revenue procedures and procurement requirements, to ensure compliance with regulations and accuracy in Departmental reporting. Specific duties include but are not limited to the following: Assist with monitoring and establishing financial controls to monitor expenditures and revenues, including grant and capital funds Maintain various detailed spreadsheets and monthly reconciliations and analysis for revenues and expenditures. This includes running PeopleSoft inquiries and reports at division and/or unit level Assist with cash and revenue management, including billing, collection, and other third-party payments Research and resolve any revenue or expenditure errors or discrepancies Prepare salary and overtime projections Assist with Department grant applications, monitoring and grant reporting and assist in the maintenance of proper record-keeping of grants Assist in the preparation departmental financial documents and schedules Preparation of financial reports and appropriation and budget transfer requests. Assist in the preparation of the Department's operating and capital budget Assist in the review of Capital and Grant roll forward schedules Assist with the Year End close out, including grant reconciliations and revenue reporting Help resolve any accounting, financial or system inquiries Assist the Director of Planning, Budget, and Personnel with presentation documents Assist with the development of the budget narrative as well as data tracking systems including benchmarks and other monthly reports Develop internal working documentation for fiscal and administration processes and procedures. Support the development and improvement of departmental procedures and policies relating to fiscal and business operations Assist in staff training on the use of the City's computerized systems Provide administrative support, including creating and maintaining meeting minutes, agenda, and other meeting documentation Assist the Director with customer inquiries, meeting coordination and special projects as designated and other duties as assigned. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. MINIMUM REQUIREMENTS: Bachelor's Degree in Accounting, Business, Finance, or related discipline required or equivalent combination of either education and/or experience. Demonstrated successful accounting or financial experience, preferably in a public-sector organization or school district. Highly organized and detail oriented individual able to handle multiple tasks while working in both a team environment as well as independently with minimum supervision. Excellent communication, organizational, analytical, and planning skills required. Working knowledge of computerized financial systems. Working knowledge of PeopleSoft Financials a plus. Proficiency in the Microsoft Office Suite, particularly MS Word and Excel is required. Experience in handling confidential and sensitive information a plus. The City may require that candidates take and pass a computer skills proficiency test in Excel at the time of hire. The City of Cambridge's workforce, like the community it serves, is diverse. Applicants must have the ability to work and interact effectively with individuals and groups with a variety of identities, cultures, backgrounds, and ideologies. PHYSICAL DEMANDS: Ability to access, input, and retrieve information from a computer using various software programs. Answer telephones and maintain multiple files. May require minimal lifting of up to 10 pounds WORK ENVIRONMENT: General office environment with air conditioning and fluorescent lighting. Noise level can be high as the office is active with phone calls and walk ins. RATE: $53,224 - $64,994 annually excellent benefits (rate is effective 07/01/22) APPLICATION PROCEDURE: Internal applicants submit a job bidding form and 2 copies of both your resume and cover letter; external applicants submit both your resume and cover letter via email to employmentcambridgema.gov or to the Personnel Dept, Room 309, City Hall, 795 Massachusetts Avenue, Cambridge MA 02139. Fax 617-349-4312. Review of resumes is ongoing. Position will remain open until filled. THE CITY OF CAMBRIDGE IS AN AFFIRMATIVE ACTION/EQUAL OPPORTUNITY EMPLOYER AND DOES NOT DISCRIMINATE ON THE BASIS OF RACE, COLOR, SEX, RELIGION, AGE, NATIONAL ORIGIN, DISABILITY OR ANY OTHER PROTECTED CATEGORY. WOMEN, MINORITIES, VETERANS, MEMBERS OF THE LGBTQ COMMUNITY, AND PERSONS WITH DISABILITIES ARE ENCOURAGED TO APPLY. CITY OF CAMBRIDGE RESIDENTS ARE ESPECIALLY ENCOURAGED TO APPLY. AUXILIARY AIDS AND SERVICES, WRITTEN MATERIALS IN ALTERNATIVE FORMATS, AND REASONABLE MODIFICATIONS IN POLICIES AND PROCEDURES WILL BE PROVIDED TO QUALIFIED INDIVIDUALS WITH DISABILITIES FREE OF CHARGE, UPON REQUEST. The City is committed to advancing a workforce culture of antiracism, diversity, equity, and inclusion. PDN-948e5e08-cfee-4c6b-a096-ccad7f11d9ef

Keywords: City of Cambridge, Cambridge , Fiscal Affairs Analyst, Accounting, Auditing , Cambridge, Massachusetts