Grants Administrative Analyst (37397)

Agua Caliente Casinos•Palm Springs, CA

6d•Onsite

About The Position

The Agua Caliente Band of Cahuilla Indians (ACBCI) seeks a Grants Administrative Analyst to support financial analysis, reporting, and data management functions within the Grants Department. The Grants Administrative Analyst serves as a critical bridge between the Grants Department and the Accounting Department, ensuring that grant-related financial data is accurately recorded, reconciled, and reported. This position supports the tribe’s indirect cost (IDC) recovery processes, assists with financial system entries, and provides data analysis to inform the department’s grant strategy and performance reporting.

Requirements

Must be computer literate in Microsoft 365 Co-Pilot or equivalent software.
Bachelor’s degree in accounting, finance, business administration, public administration, or a related field preferred; equivalent combination of education and experience will be considered.
Minimum two (2) years of experience in financial analysis, accounting support, grants financial management, or a closely related field.
Working knowledge of 2 CFR Part 200 (Uniform Guidance) cost principles and federal grant financial requirements preferred.
Experience with fund accounting software; familiarity with Abila MIP or similar government/nonprofit accounting systems a plus.
Strong analytical and data management skills; demonstrated ability to identify discrepancies and reconcile financial records accurately.
Proficiency in Microsoft Office Suite, including advanced Excel skills for financial analysis and reporting.
Excellent written and verbal communication skills; ability to present financial data clearly to non-financial audiences.
Experience working in tribal government, public sector, or nonprofit grant-funded environments preferred.
High degree of accuracy and integrity in financial record-keeping and reporting.
Must possess a valid Driver’s License.
Must be able to travel in and out of Palm Springs, California area as needed.

Nice To Haves

Familiarity with grants management software (e.g., Euna Grants or similar platform) preferred.
Working knowledge of 2 CFR Part 200 (Uniform Guidance) cost principles and federal grant financial requirements preferred.
Experience with fund accounting software; familiarity with Abila MIP or similar government/nonprofit accounting systems a plus.
Experience working in tribal government, public sector, or nonprofit grant-funded environments preferred.

Responsibilities

Perform financial reconciliation of grant award accounts, ensuring expenditures are accurately recorded and allocated in accordance with award budgets and 2 CFR Part 200 requirements.
Prepare and process Abila financial system entries for grant-related transactions, including budget modifications, IDC allocations, and expenditure coding.
Monitor and reconcile accounts in coordination with the Accounting Department; assist in identifying and resolving coding discrepancies.
Support the department’s cost recovery tracking, including monitoring accruals and assisting in the preparation of allocation reports.
Generate and distribute monthly grant account reports, flagging budget variances, unallowable costs, or compliance concerns to the Director of Grants Management.
Coordinate with Accounting to ensure grant award letters and close-out documentation are properly received and processed at award initiation and completion.
Assist in preparing financial data for federal and state grant reports, ensuring figures are accurate, reconciled, and supported by documentation.
Maintain accurate financial records and supporting documentation for all active and closed grant awards in audit-ready condition.
Analyze grant portfolio data to support the Director of Grants Management in performance tracking, ROI reporting, and strategic planning.
Support the Euna Grants platform data integrity, ensuring financial data and award information is accurately entered and maintained.
Assist in developing and refining financial procedures for grant account management in coordination with Accounting and the Director.
Other duties as assigned.