Financial-Data Analyst

Position Title

Financial/Data Analyst

14

Fiscal Affairs

Non-Exempt, Hourly

37.5 per week

Teamsters Local 122

Budget Director, Deputy Director of Fiscal Affairs

The Cambridge Housing Authority ("CHA") is a leader in developing and maintaining affordable housing communities. CHA provides long-term rental housing and rental assistance to more than 5,500 individuals and families through its Public Housing and Housing Choice Voucher (HCV) Programs. CHA has been awarded accreditation by the Affordable Housing Accreditation Board (AHAB) and was the seventh affordable housing provider in the nation to receive this prestigious accreditation.

CHA offers competitive compensation commensurate with experience. The benefits package includes health and dental insurance, paid time off, paid holidays, life and disability insurance options, tuition reimbursement, commuter benefits, retirement pension and deferred compensation 457b plans, and more. Employees enjoy flexible work schedules, including a hybrid environment of on-site and remote days.

The primary purpose of this position is to gather, synthesize, and analyze financial data to support budget creation and tracking for CHA and its departments, and to prepare corresponding reports. The incumbent will also serve as the Emphasys‑Elite data expert for financial information, developing reports for the Authority and coordinating with IT to ensure that financial data needs are met in Elite.

All activities must support CHA’s strategic goals and objectives and produce results that accomplish the goals of the Fiscal Affairs department.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made for individuals with disabilities.

Bachelor’s Degree in accounting, finance, or related field, and a minimum of three (3) years of demonstrated budget experience, including preparation, administration, and reporting. Must have a valid Massachusetts driver’s license and be insurable under CHA policies. An equivalent combination of education and experience may be considered.

Advanced computer skills in MS Word, MS Excel, MS Access, and MS Outlook. Ability to learn other software programs may be required by assigned tasks.

• Assist departments in gathering, synthesizing, and analyzing financial data related to short-term and long-term project budgets and timelines, leading to the creation and tracking of Authority‑wide budgets.
• Serve as the point‑of‑contact for all financial matters relating to the Emphasys‑Elite software; ensures that financial data in Elite is accurate and complete, and develops Elite reports as requested.
• Coordinate with IT to ensure financial data needs are met in Elite; collaborate to design, implement, or improve related processes and policies.
• Assist CHA departments with a wide range of financial information requests and problem solving; help identify departmental funding needs and match those needs with revenue sources.
• Maintain financial data on grant spending and receipts.
• Assist in monitoring expenditures against overall plans, and reporting results to departments and management.
• Ensure timely obligation and expenditure of funds.
• Process and approve all requisitions for expenditures.
• Prepare monthly variance analysis reports for each site and department.
• Prepare and post journal entries for management fees, fee‑for‑service, and front‑line costs.
• Review monthly Board resolutions for funding and eligibility.
• Prepare and post allocation entries for gasoline and postage monthly.
• Book bank reconciliation entries and miscellaneous cash receipts and HUD payments to General Ledger.
• Provide funding requests to HUD and other federal, state, and local governments as well as foundations and other organizations; ensure compliance with CHA standards and goals.
• Ensure that all operating budgets, capital funds, Section 8 fee accounts and grant money comply with grantor and program guidelines and CHA standards and practices.
• Track…