Sponsor Research Analyst

Donald Danforth Plant Science Center, Inc; St. Louis (MO); On-site; USD 70,000 - 95,000; Full time

Job summary

Donald Danforth Plant Science Center, Inc seeks a Sponsor Research Analyst to manage the financial administration of sponsored awards from setup through closeout. You will build budget models, track expenditures, and provide forecasting and variance analysis to support PIs with compliant financial data.

The role requires a 4-year degree in accounting with 3–5 years’ experience in post-award grants administration or sponsored research, and advanced Excel skills for dashboards and reporting.

Qualifications

• Knowledge of accounting principles and practices.
• Familiarity with Uniform Guidance (2 CFR 200).
• Familiarity with post-award requirements.
• Familiarity with effort reporting and certification requirements.
• Familiarity with subrecipient monitoring.

Responsibilities

• Builds award budget models and dashboards, tracks costs by category.
• Leads portfolio management meetings with PIs to discuss spending.
• Reconcile award activity to the general ledger monthly.
• Prepare budget revisions and rebudgeting requests.
• Coordinate effort reporting and certification processes.
• Prepare sponsor financial reports and reminders for PIs.
• Analyze subrecipient invoices for allowability and compliance.
• Manage closeout of awards and final financial reports.
• Other duties as assigned.

Skills

Accounting principles

Uniform Guidance (2 CFR 200)

Post-award requirements

Effort reporting

Subrecipient monitoring

Advanced Excel

Financial analysis

Budget forecasting

Variance/burn-rate analysis

Financial reporting

General ledger reconciliation

Accounting systems

Data-driven recommendations

Stakeholder communication

Education

Bachelor's degree in accounting

Tools

Excel

Accounting software

Job description

Job Details:

Job Location: Saint Louis - Saint Louis, MO 63132, Position Type: Full Time, Education Level: 4 Year Degree

Description: The Sponsor Research Analyst manages the financial administration of a portfolio of sponsored awards from setup through closeout. This role brings the financial skills needed to support overall financial accountability for the Center's sponsored research portfolio and to serve the scientific enterprise with financial management that is compliant, accurate, and gives Principal Investigators (PIs) the information they need to make sound decisions about their research financials. This role builds and maintains budget models and spending forecasts, performs variance and burn-rate analysis, reconciles award activity to the general ledger and prepares sponsor financial reports. The position oversees effort reporting and subrecipient financial monitoring and serves as a financial advisor to PIs, translating portfolio data into actional recommendations. The Sponsor Research Analyst ensures awards are managed in compliance with sponsor terms, federal regulations, and Center policies.

Responsibilities:

• Builds award budget models and financial dashboards at setup, establishing budget-to-actual tracking by cost category and update them monthly with expenditures, encumbrances and forecasted spending through the end of the award. Performs monthly variance and burn-rate analysis, projecting end-of-period balances, identifying over and under spending trends and modeling scenarios (e.g. personnel changes and no-cost extensions).
• Leads in-person portfolio management meetings with PIs to communicate analysis, forecast and discuss spending strategy.
• Reconcile award activity to the general ledger monthly, identifying and correcting misallocated charges and communicating with Grant Specialists to ensure well-documented, timely cost transfers are prepared and submitted.
• Prepare and process budget revisions and rebudgeting requests, determining when sponsor prior approval is required and preparing those requests.
• Coordinate the effort reporting and certification process, reconciling certified effort to payroll distributions and cost share commitments, and analyzing and resolving discrepancies with appropriate adjustments.
• Prepare and submit sponsor financial reports on schedule and send reminders to PIs for technical and progress reports.
• Analyze subrecipient invoices against approved budgets for allowability, allocability, and reasonableness; and monitor ongoing financial compliance and reporting.
• Manage the financial closeout of awards, including final expenditure analysis and reconciliation, resolution of outstanding charges and residual balances, and preparation of final financial reports.
• Other duties as assigned.

Required knowledge, skills, and abilities:

• Knowledge of accounting principles and practices, including reconciliations and financial reporting.
• Familiarity with Uniform Guidance (2 CFR 200) cost principles, including allowability, allocability, and reasonableness.
• Familiarity with post-award requirements, including sponsor prior-approval rules, rebudgeting authority, and closeout procedures.
• Familiarity with effort reporting and certification requirements for federally funded personnel.
• Familiarity with subrecipient monitoring requirements, including pass-through entity obligations.
• Advanced Excel skills, including building and maintaining dashboards, budget trackers, and financial projections and forecasts.
• Strong analytical skills for reviewing expenditures, identifying variances, and projecting burn rates.
• Ability to prepare accurate, timely financial reports and budget revision requests.
• Proficiency with accounting and financial systems.
• Strong attention to detail and accuracy in financial data.
• Ability to manage a portfolio of awards independently from setup through closeout.
• Ability to identify financial risks and compliance issues early and recommend corrective action.
• Ability to make sound judgments on cost allowability and when to expand issues.
• Ability to build productive working relationships with investigators, subrecipients, and sponsors.
• Ability to meet recurring monthly and sponsor-driven deadlines consistently.
• Ability to maintain confidentiality of financial and personnel information.

Qualifications: Qualifications:

• Bachelor's degree in accounting with 3-5 years’ experience, ideally in post-award grants administration or sponsored research.