Grants Analyst - Non Profit

The Grants Analyst is responsible for supporting the Director of Accounting & Compliance, Grants & Contracts, on several collaborative efforts and special projects, creating financial models, forecasts, preparing budget-to-actual reports, and analyzing key financial metrics, and will be a subject matter expert for data acquisition, manipulation, and maintenance.

They will also coordinate and guide the implementation and close-out of assigned grant coordination with various program staff to ensure proper financial and programmatic reporting, timely and accurate expenditure of funds, compliance with the funder's requirements, and addressing grant
implementation challenges, reconciliations of programmatic and financial data, grant/program implementation as it relates to data collection and reporting.

Key Responsibilities

o Understand and track the full financial picture of key programs (i.e. incoming revenue and cash, procurement and payables)
o Attend weekly, monthly, and/or quarterly collaboration meetings with external and internal stakeholders to understand specific program requirements
o Collaborate with external stakeholders on status of contracts, spend downs, or other financial/compliance items as needed
o Collect, process, and analyze large datasets to identify trends and patterns and collaborate with cross-functional teams to translate data findings into actionable insights
o Provide clear and meaningful status updates to the Director of Accounting & Compliance, Grants & Contracts, and to external stakeholders as needed
o Analyze specific programs or fundraising efforts and revenue streams, including workplace campaigns, grants, and events
o Collaborate with budget owners monthly to review their financial dashboard
o Work in conjunction with contracts and grant managers and provide budget and other financial information as needed
o Collaborate with IT/Business Success to work through system limitations or errors, including but not limited to Stratus Live, Financial Edge, and the internal financial dashboard

Award and Portfolio Management:
o Manage a portfolio of low to medium risk awards from start- up ( award kickoff) through close-out in compliance with donor guidelines and United Way.
o Serve as the main point of contact for the assigned awards, liaising with donors, program staff, and relevant stakeholders.
o Monitor budget vs actual expenditures and level of effort (LoE%), identifying discrepancies and ensuring corrective actions.
o Prepare and document agency match required per funder agreements.

Donor Compliance and Reporting
o Coordinate timely and high-quality donor financial reports, ensuring all backup documentation is maintained and auditable.
o Flag compliance risks promptly and assess with donor waiver or amendment requests as needed.

Partnerships
o Oversee sub- award processing, including legal vetting, capacity assessments, and donor compliance monitoring.
o Provide training and capacity building on award procedures to internal teams and partner organizations.
o Cost proposal developments and funding strategy
o Support proposal development processes- managing budget and budget narratives and other application materials
o Partner with Philanthropy and Program staff to produce cost proposals and pipeline analysis.

Monitoring, Analysis, and Knowledge Management
o Analyze key performance indicators, budgets vs actuals, and provide regular reporting to Senior Management and other stakeholders
o Maintain knowledge management systems- ensuring files, past reports, proposals, and operating procedures are accessible and updated.

Competencies:

o Excellent communication skills
o Customer service focused
o Effective relationship management
o Adaptability
o Drives for results
o Tenacity
o Continuous learning
o Excellent problem solver and critical thinker

Qualifications:

o Ability to set priorities, take initiative, manage multiple tasks and meet deadlines independently
o Strong project management skills and experience convening with cross-functional teams to achieve a common goal
o Very detail oriented and effective ability to work independently
o Ability to analyze and solve complex business processes and data sets

o Possess a deep understanding and advanced capabilities of Microsoft Office 365, including advanced excel, database queries, Power Automate, etc. and BI tools tools such as Power BI, Tableau, etc.
o Willingness to pick up new tasks and procedures

Education & Experience Requirements:

o A bachelor's degree in Accounting, Finance, Economics, Business Administration, or related concentration
o 2-5 years of experience in budgeting, forecasting, financial modeling, variance analysis, data structure, and working with business stakeholders within and across functions