Grant Budget & Financial Analyst

Community Partnership; Washington (District of Columbia); On-site; USD 75,000 - 85,000; Full time

Benefits offered by this job

COVID19 vaccination policy compliance

Equal opportunity employer

Job summary

Community Partnership for the Prevention of Homelessness is seeking a Financial Analyst responsible for data collection and analyzing revenue versus expenditures across various grants. The role involves updating contracts, maintaining financial reports, and ensuring compliance with budgets.

The ideal candidate holds a Bachelor’s degree in business or accounting and has 2-3 years of relevant experience, especially with federal contracts. Strong computer literacy and communication skills are essential.

Qualifications

• Minimum 2-3 years of accounts receivable and financial analysis experience.
• Experience with federal contracts preferred.
• Bilingual in English and Spanish is a plus.

Responsibilities

• Maintain and update bi-weekly financial reports.
• Track actual spending for key programs and reconcile expenditures.
• Prepare monthly/quarterly revenue vs. expense financial reports.
• Assist with budget and contract review.

Skills

Advanced computer literacy

Excellent communication skills

Strong data entry

Outstanding organizational skills

Ability to analyze information

Education

Bachelor’s degree in business or accounting

Tools

Microsoft Office Suite

Excel

Job description

Salary Range: $75,000.00 To $85,000.00 Annually

LOCATION:14 Kennedy Street NW, Washington, DC 20011

POSITION SUMMARY:

The Financial Analyst with the Community Partnership for the Prevention of Homelessness (TCP)'s primary responsibilities involve data collection and performing revenue versus expenditures analysis for all grants, including DHS, COC, SPC, and ADM. This role is tasked with updating all contracts and tracking grant budgets. It will also involve maintaining bi-weekly financial reports that monitor essential financial metrics such as carryover amounts and advance payments, while reconciling actual expenditures against established budgets for key programs.

SALARY:$75,000 - $85,000 (Depending on Experience)

ESSENTIAL POSITION FUNCTIONS INCLUDE THE FOLLOWING:

• Maintain and update bi-weekly financial reports, including Carryover, Advance Payment, and Master Grant Tracking document
• Track actual spending for key programs (e.g., MGMT, SS, ERAP), reconcile expenditures, and ensure alignment with approved budgets
• Prepare monthly/quarterly revenue vs. expense financial reports (e.g., MGMT, SS, ERAP); identify spending trends or issues and report findings to managers
• Maintain detailed site-level budgets by expense category, including operating, food, security, janitorial, and maintenance costs
• Perform ADM spending analysis, revenue adjustments, and reserve update
• Perform TCP audit-related duties and assist with auditors’ requests
• Assist with TCP fiscal year-end closeout duties and conduct a review and quality control
• Assist with preparing providers’ budget for issuing contracts, including contract numbers and accurate contract amounts
• Assist with budget and contract review, and contract closeout reconciliation
• Assist in preparing initial contract and grant budgets (e.g., MGMT, SS) and update as funding changes occur; analyze budget modifications for financial impact
• Assist in tracking the grant award process, update the grant execution status report promptly, and notify related parties
• Assist with quality control of DHS and HUD-COC biweekly payments
• Perform ADM spending analysis and reserve update
• Prepare invoices and Accounts Receivable (AR) for DHS management contract, Sole Source grant, HMIS, HPG, SPC, and ERAP Grant, COC Grants
• Review and coordinate to resolve TCP Timesheet issues
• Perform TCP payroll processing duties following the payroll schedule
• Update staff’s payroll and pension information in the ADP system
• Prepare bi-weekly pension invoice, submit pension transfers, and retain accurate pension records
• Prepare the year-end payroll close-out process, including W2 verification and health insurance reporting
• Perform ACH payments onboth Citibank and City First Bank
• Perform monthly bank reconciliation for selected accounts
• Assist with cash analysis and cash management, including cash transfer reconciliation and review
• Review CoC and DHS-funded financial, project/program, and grants accounting; ensure that expenditures are consistently aligned with grant and program budgets throughout the grant/fund period
• Prepare federal funding letters and prepare to send them out to providers on a quarterly basis
• Perform analysis and corrections of the quarterly Aged of Accounts Receivable
• Follow up with providers and the AP team to ensure all cost-related documentation is submitted and processed accurately for cost reimbursement
• Review monthly billing and payment reconciliation for ERAP, HMIS, SS, MGMT
• Assist with vendor data review and 1099 corrections
• Other duties assigned as deemed appropriate

MANDATORY REQUIREMENTS

EDUCATION AND EXPERIENCE

• Bachelor’s degree in business or accounting or minimum 2- 3 years of AR and financial analysis or related accounting experience. CPA preferred; Experience with federal contracts and familiarity with Uniform Guidance regulations preferred.
• Experience with federal contracts and familiarity with Uniform guidance a plus.
• Bilingual in English and Spanish is a plus.

REQUIRED SKILLS AND ABILITIES:

• Advanced computer literacy and expertise with software used in a typical office environment, e.g., Microsoft suite of office products, Excel, Outlook, Word, and PowerPoint to create and maintain reports and logs
• Excellent communication skills, to include ability to communicate clearly in writing and verbally to a wide range of audiences (customers, co-workers, managers, the public, stakeholders, etc.) face-to-face, virtually, or via telephone or other communication devices to elicit information
• Advanced understanding of accounting principles and procedures.
• Strong data entry and knowledge of accounts payable, financial accounting and budget analysis
• Ability to operate basic office equipment
• Outstanding organizational skills and ability to effectively prioritize and multi-task
• Must be able to identify and resolve problems in a timely manner
• Must be able to gather and analyze information skillfully
• Must have great listening skills and the ability to work with well with people at various levels inside and outside of TCP
• Ability to work independently and function well as part of a team

WORKING CONDITIONS AND PHYSICAL REQUIREMENTS:

• Ability to exhibit manual dexterity to dial a telephone, operate a computer keyboard, and handle paper documents
• Ability to enter data and/or information into a computer
• Ability to understand written and/or oral instructions
• Ability to read a computer screen and printed materials with or without vision aids
• Physical ability to bend, stoop, climb stairs, and reach overhead
• Prolonged periods of sitting at a desk and working on a computer

The above statements are intended to describe the general nature and level of work performed by people assigned to this classification. They are not intended to be a complete list of duties.

• Your response to this job announcement may be considered for other similar available positions within The Community Partnership.
• Bilingual candidates are encouraged to apply.

TCP has a mandatory COVID19 Vaccination (and booster) Policy. On your first day on site, you will be required to produce a COVID19 Record of Vaccination or other documentation to prove to TCP that you have been fully vaccinated from the coronavirus. Further, TCP contractors must also follow all health and safety protocols established by TCP to help maintain a safe workplace and healthy environment.

The Community Partnership for the Prevention of Homelessness is an equal opportunity employer, committed to nondiscrimination in recruitment, selection, hiring, pay, promotion, retention, or other personnel actions affecting contractors, employees or applicants for employment. Personnel or selection decisions shall be based on merit and the ability to perform the essential functions of the work, with or without reasonable accommodation.

If you have any questions about our company policies or your rights as an applicant or require a reasonable accommodation, please contact our Office of the General Counsel at 202.543.5298 (ext. 305).