Grants Administrative Analyst (37397)

Agua Caliente Casinos; Palm Springs (CA); On-site; USD 65,000 - 90,000; Full time

Job summary

The Agua Caliente Band of Cahuilla Indians is seeking a Grants Administrative Analyst to support financial analysis, reporting, and data management within the Grants Department in Palm Springs, CA. The role bridges Grants and Accounting to ensure accurate, reconciled grant data and IDC recovery support.

Ideal candidates will have foundational accounting knowledge, 2+ years in financial analysis or grants management, and proficiency with Microsoft Office and grants platforms.

Qualifications

• Bachelor’s degree preferred; equivalent experience considered.
• Minimum two years of experience in financial analysis, accounting support, grants financial management, or related field.
• Working knowledge of 2 CFR Part 200 cost principles and federal grant requirements preferred.
• Experience with fund accounting software; familiarity with Abila MIP or similar systems a plus.
• Strong analytical and data management skills; ability to reconcile financial records.
• Proficiency in Microsoft Office Suite, including advanced Excel.
• Experience in tribal government, public sector, or nonprofit grant-funded environments preferred.
• High degree of accuracy and integrity in financial record-keeping and reporting.

Responsibilities

• Reconcile grant award accounts and allocate expenditures per budgets and 2 CFR Part 200 requirements.
• Process Abila financial system entries for grant transactions (budgets, IDC allocations, expenditures).
• Coordinate with Accounting to reconcile accounts and resolve coding discrepancies.
• Support cost recovery tracking and allocation reports.
• Generate and distribute monthly grant reports; flag variances or compliance concerns.

Skills

Analytical abilities

Data management

Education

Bachelor’s degree in accounting, finance, business administration, public administration, or related field

Tools

Microsoft 365 Co-Pilot

Euna Grants

Abila MIP

Excel

Microsoft Office Suite

Job description

Come work for the leading employer in the Coachella Valley. Agua Caliente offers a comprehensive benefit and compensation package that includes rich medical and dental benefits, a 401k plan with employer match, more than 3 weeks of paid time off per year for newly hired employees, and other great benefits like food and beverage discounts at our three casinos, fuel discounts, tuition and wellness reimbursement, plus much, more.

WHO ARE WE:

The Agua Caliente Band of Cahuilla Indians is a federally recognized Indian Tribe located in Palm Springs, California, with 34,000 acres of reservation lands that spread across Palm Springs, Cathedral City, Rancho Mirage, and into the Santa Rosa and San Jacinto mountains. The Tribe currently owns and operates two 18-hole championship golf courses, 3 casinos located in Cathedral City, Rancho Mirage, and downtown Palm Springs, two world class spas, and 3 fuel stations. For more information about the Tribe, visit www.aguacaliente-nsn.gov.

Job Description Summary

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.

Essential Duties And Responsibilities

The following duties are representative but not exhaustive. Other duties may be assigned.

• 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.

Supervisory Responsibilities

This position does not carry direct supervisory responsibility. The incumbent works collaboratively within the Grants Department under the direction of the Director of Grants Management and contributes to team-based coordination across tribal departments.

ACCESS TO SENSITIVE AREAS AND INFORMATION

Confidential and sensitive information, including grant award details, federal agency correspondence, financial data, and compliance documentation.

KEYS

Grants Office

Department Files

SIGNATORY ABILITY

HR Related Forms

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

QUALIFICATIONS

Must be computer literate in Microsoft 365 Co-Pilot or equivalent software. Familiarity with grants management software (e.g., Euna Grants or similar platform) preferred.

EDUCATION And/or EXPERIENCE

• 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.

WORKING CONDITIONS/PHYSICAL DEMANDS

To perform this job successfully, the individual must be mobile, be able to sit, use hands to type, reach, talk and hear. Typically, the individual will be housed in an office environment. The noise level in the work environment is usually moderate. Must possess a valid Driver’s License. Must be able to travel in and out of Palm Springs, California area as needed.