Fiscal Affairs Analyst

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.

SUMMARY OF BENEFITS:

• Competitive health, dental, and vision insurance
• Vacation and Sick leave eligible
• Sick Incentive Pay Eligible
• 3 Personal days
• 14 Paid Holidays
• Management Allowance, $2,700/year
• City employee transportation benefits (T-Pass reimbursement Bluebikes membership, EZRide Shuttle)

REQUIRED DOCUMENTS:

Please upload the following documents to complete your application.

• Resume
• Cover Letter