Grants Analyst — Data-Driven Reporting & Compliance

Jobot; Los Angeles (CA); On-site; USD 48,000 - 69,000; Full time

Benefits offered by this job

Health insurance

401(k)

Paid sick leave

And more

Job summary

Jobot is seeking a Grants Analyst in Los Angeles, CA to support grant-funded programs through data analysis, reporting, compliance monitoring, and financial tracking. You will partner with finance, program, and leadership teams to ensure accurate reporting and timely grant administration.

Ideal candidates have 2+ years in grants administration, advanced Excel (PivotTables, XLOOKUP/VLOOKUP), and experience with government-funded programs. Harm reduction or SAPC grants are a plus.

Qualifications

• 2+ years of grants administration, grants analysis, program analysis, or related role.
• Advanced Microsoft Excel skills including PivotTables, XLOOKUP/VLOOKUP, reporting, and data analysis.
• Experience with government-funded programs, grants, or contracts.
• Background in harm reduction or SAPC grants preferred.

Responsibilities

• Monitor grant-funded program performance, expenditures, and compliance requirements.
• Prepare recurring and ad hoc reports for leadership, funding agencies, and internal stakeholders.
• Analyze programmatic and financial data to identify trends, variances, and opportunities for improvement.
• Maintain data integrity across multiple systems and reporting platforms.
• Assist with grant budgeting, forecasting, reimbursement requests, and contract reporting requirements.
• Support audits, monitoring reviews, and funding agency requests.
• Develop and maintain dashboards, spreadsheets, and reporting tools.
• Collaborate with finance, operations, and program teams to ensure accurate documentation and timely reporting.
• Perform data validation, reconciliation, and quality assurance activities.
• Support special projects related to grants management, program evaluation, and organizational reporting.

Skills

Advanced Excel

Data analysis

Grant administration

Program analysis

Tools

PivotTables

XLOOKUP/VLOOKUP

Job description

Jobot is seeking a Grants Analyst in Los Angeles, CA to support grant-funded programs through data analysis, reporting, compliance monitoring, and financial tracking. You will partner with finance, program, and leadership teams to ensure accurate reporting and timely grant administration.

Ideal candidates have 2+ years in grants administration, advanced Excel (PivotTables, XLOOKUP/VLOOKUP), and experience with government-funded programs. Harm reduction or SAPC grants are a plus.