Financial-Data Analyst

Position Title Financial/Data Analyst Salary Grade 14

DEPARTMENT

Fiscal Affairs FLSA Status Non-Exempt, Hourly Standard Hours 37.5 per week Union Teamsters Local 122 Reports to Budget Director, Deputy Director of Fiscal Affairs

ABOUT US

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. Benefits 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.

SUMMARY

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.

QUALIFICATIONS

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. Education and/or Experience 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. Technical Skills 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.

ESSENTIAL DUTIES AND RESPONSIBILITIES

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 actual progress, budget revisions, and budget reporting and analysis. Perform other related duties as assigned.

COMPETENCIES

Behavioral Competencies Commitment: Sets high performance standards, pursues aggressive goals, and works hard/smart to achieve them while persisting despite obstacles. Customer Service: Exceeds expectations of internal and external customers, understands and measures their needs, and treats colleagues as customers. Effective Communication: Passes important information clearly and effectively, listens well, and ensures understanding of comments and questions. Responsiveness and Accountability: Demonstrates conscientiousness, holds oneself personally responsible for work, and completes a fair share of tasks. Teamwork: Balances team and individual responsibilities, welcomes feedback, builds morale, and supports team success. Job Competencies Knowledge of and the ability to understand and apply GAAP, GASB principles, and other accounting methods required for HUD and federal reporting. Comprehensive knowledge of policies, procedures, goals, objectives, operational entities, requirements and activities applicable to the Authority. Demonstrated track record of effective application of accounting and budgetary principles, practices, regulations and financial analysis. Knowledge of federal, state and local laws, regulations and accreditation standards. Ability to handle high volumes of workflow and monthly deadlines. Ability to exercise initiative, use sound judgment, and make timely decisions. Proven ability to work effectively in teams or groups.

PHYSICAL DEMANDS

Must maintain a stationary position, operate computers and other office equipment, move about the office, attend onsite and offsite meetings, and communicate in person, in writing, and via e‑mail and telephone. The employee may occasionally transport up to 10 pounds.

WORK ENVIRONMENT

Office environment with moderate noise level.

EMPLOYMENT POLICY

It is the policy of the Cambridge Housing Authority to give preference in employment to Section 3‑eligible individuals. The Cambridge Housing Authority is an equal opportunity affirmative action employer. Minorities, handicapped and others are encouraged to apply. #J-18808-Ljbffr Cambridge Housing Authority