Financial Analyst

Financial AnalystThe Financial Analyst with the Community Partnership for the Prevention of Homelessness (TCP) has primary responsibilities involving 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 documentTrack actual spending for key programs (e.g., MGMT, SS, ERAP), reconcile expenditures, and ensure alignment with approved budgetsPrepare monthly/quarterly revenue vs. expense financial reports (e.g., MGMT, SS, ERAP); identify spending trends or issues and report findings to managersMaintain detailed site-level budgets by expense category, including operating, food, security, janitorial, and maintenance costsPerform ADM spending analysis, revenue adjustments, and reserve updatePerform TCP audit-related duties and assist with auditors' requestsAssist with TCP fiscal year-end closeout duties and conduct a review and quality controlAssist with preparing providers' budget for issuing contracts, including contract numbers and accurate contract amountsAssist with budget and contract review, and contract closeout reconciliationAssist in preparing initial contract and grant budgets (e.g., MGMT, SS) and update as funding changes occur; analyze budget modifications for financial impactAssist in tracking the grant award process, update the grant execution status report promptly, and notify related partiesAssist with quality control of DHS and HUD-COC biweekly paymentsPerform ADM spending analysis and reserve updatePrepare invoices and Accounts Receivable (AR) for DHS management contract, Sole Source grant, HMIS, HPG, SPC, and ERAP Grant, COC GrantsReview and coordinate to resolve TCP Timesheet issuesPerform TCP payroll processing duties following the payroll scheduleUpdate staff's payroll and pension information in the ADP systemPrepare bi-weekly pension invoice, submit pension transfers, and retain accurate pension recordsPrepare the year-end payroll close-out process, including W2 verification and health insurance reportingPerform ACH payments on both Citibank and City First BankPerform monthly bank reconciliation for selected accountsAssist with cash analysis and cash management, including cash transfer reconciliation and reviewReview 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 periodPrepare federal funding letters and prepare to send them out to providers on a quarterly basisPerform analysis and corrections of the quarterly Aged of Accounts ReceivableFollow up with providers and the AP team to ensure all cost-related documentation is submitted and processed accurately for cost reimbursementReview monthly billing and payment reconciliation for ERAP, HMIS, SS, MGMTAssist with vendor data review and 1099 correctionsOther duties assigned as deemed appropriateMandatory RequirementsEducation and ExperienceBachelor'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 AbilitiesAdvanced 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 logsExcellent 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 informationAdvanced understanding of accounting principles and procedures.Strong data entry and knowledge of accounts payable, financial accounting and budget analysisAbility to operate basic office equipmentOutstanding organizational skills and ability to effectively prioritize and multi-taskMust be able to identify and resolve problems in a timely mannerMust be able to gather and analyze information skillfullyMust have great listening skills and the ability to work with well with people at various levels inside and outside of TCPAbility to work independently and function well as part of a teamWorking Conditions and Physical RequirementsAbility to exhibit manual dexterity to dial a telephone, operate a computer keyboard, and handle paper documentsAbility to enter data and/or information into a computerAbility to understand written and/or oral instructionsAbility to read a computer screen and printed materials with or without vision aidsPhysical ability to bend, stoop, climb stairs, and reach overheadProlonged periods of sitting at a desk and working on a computerThe 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.Application ProcessApply for this position through the TCP career center Recruitment (adp.com)Your response to this job announcement may be considered for other similar available positions within The Community Partnership.Bilingual candidates are encouraged to apply.No phone calls.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 View phone number on click.appcast.io (ext. 305).