Grants Analyst - Non Profit

United Way for Southeastern Michigan•Detroit, MI

About The Position

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.

Requirements

Ability to set priorities, take initiative, manage multiple tasks and meet deadlines independently
Strong project management skills and experience convening with cross-functional teams to achieve a common goal
Very detail oriented and effective ability to work independently
Ability to analyze and solve complex business processes and data sets
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.
Willingness to pick up new tasks and procedures
A bachelor's degree in Accounting, Finance, Economics, Business Administration, or related concentration
2-5 years of experience in budgeting, forecasting, financial modeling, variance analysis, data structure, and working with business stakeholders within and across functions

Responsibilities

Understand and track the full financial picture of key programs (i.e. incoming revenue and cash, procurement and payables)
Attend weekly, monthly, and/or quarterly collaboration meetings with external and internal stakeholders to understand specific program requirements
Collaborate with external stakeholders on status of contracts, spend downs, or other financial/compliance items as needed
Collect, process, and analyze large datasets to identify trends and patterns and collaborate with cross-functional teams to translate data findings into actionable insights
Provide clear and meaningful status updates to the Director of Accounting & Compliance, Grants & Contracts, and to external stakeholders as needed
Analyze specific programs or fundraising efforts and revenue streams, including workplace campaigns, grants, and events
Collaborate with budget owners monthly to review their financial dashboard
Work in conjunction with contracts and grant managers and provide budget and other financial information as needed
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
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.
Serve as the main point of contact for the assigned awards, liaising with donors, program staff, and relevant stakeholders.
Monitor budget vs actual expenditures and level of effort (LoE%), identifying discrepancies and ensuring corrective actions.
Prepare and document agency match required per funder agreements.
Coordinate timely and high-quality donor financial reports, ensuring all backup documentation is maintained and auditable.
Flag compliance risks promptly and assess with donor waiver or amendment requests as needed.
Oversee sub- award processing, including legal vetting, capacity assessments, and donor compliance monitoring.
Provide training and capacity building on award procedures to internal teams and partner organizations.
Support proposal development processes- managing budget and budget narratives and other application materials
Partner with Philanthropy and Program staff to produce cost proposals and pipeline analysis.
Analyze key performance indicators, budgets vs actuals, and provide regular reporting to Senior Management and other stakeholders
Maintain knowledge management systems- ensuring files, past reports, proposals, and operating procedures are accessible and updated.