Salt River Pima-Maricopa Indian Community

Scottsdale, Arizona, United States

Grant Analyst

Posted over 1 month ago

Sorry, this job has expired.

Job Description

Definition

Under general supervision of the Grants Division Manager and partners directly with the Grant Administrators, Grant Analyst, Grant Programs Manager, Controller, and Program Managers to ensure that SRPMIC manages awarded grants and contracts within the laws, regulation, terms and conditions, and provisions of grant agreements and contracts. Provides oversight on all post-award aspects of grant management throughout lifecycle of grants and contracts. Provide regular communication, review, analysis, technical assistance and information to Program Managers about active grants and contracts to assist in meeting all requirements related to the performance of the grant/contract. Analyze financial and operational contract and grant data. Responsible for the grant post-award management of $50 million in funding. This job class is treated as FLSA Exempt.

Essential Functions: Essential functions may vary among positions and may include the following tasks, knowledge, skills, abilities and other characteristics. This list of tasks is ILLUSTRATIVE ONLY and is not intended to be a comprehensive listing of tasks performed by all positions in this classification.

Examples of Tasks

1. Pre-award . Assist Grant Administrator and department personnel by reviewing the pre-award application to confirm SRPMIC can meet all program and reporting requirements.

2. Post award setup
  • Communicate project number assigned to the award.
  • Developing a chartfield strategy to assist with project-specific management requirements for budgeting and expenses and create combination rules within the accounting system.
  • Submit an accurate budget within the prescribed time period. Create or review all proposed funding budgets prior to submission to ensure consistency with proposal requirements; accuracy in the calculation of salaries, direct and indirect expenses; makes recommendations to program staff for revisions when appropriate.
  • Enter award information, financial and program reporting due dates, notes and other funding information into the project costing module in the accounting system.
  • Store all documents related to each grant, contract and MOA in the project costing module in the accounting system.
  • Critical review of each funding award document to identify key differences between this funding source and all other funding. Identify the purpose of the grant, program details that will help the Accountant identify allowable expenses, and budget details that will help the Program Manager understand how this funding will support their program. Enter all above information into the Notice of Award Summary template for each grant award.
  • Coordinate with Controller, Program Manager and Payroll to assign/allocate salaries, wages and benefits approved in funding agreement.
  • Communicate funding information using the Notice of Award Summary which includes the project number, project name, assignment of project duties, and funding/reporting requirements. Schedule and facilitate Kick off meetings/Resource Meetings with Program Managers to communicate all award elements.


3. Post award oversight
  • Communicate frequently with Controller, Program Manager and Grant Analyst to assist them in the administration of awards. This includes reviewing monthly expenditure reports for underspent/overspent projects and meet with departments as appropriate to assist with resolving challenges.
  • Review and test project expenditures, including encumbrances and purchasing card charges on a routine basis to ensure accuracy.
  • Monitor encumbrances on a regular basis to confirm compliance with applicable procurement regulations.
  • Review and test transactions to ensure compliance with transaction approvals in accordance with SRPMIC policies and that transactions are properly documented.
  • Ensure the project operates in accordance with its budget and, if required, assist Program Manager to prepare budget adjustments or amendments.
  • Ensure compliance with financial and program reporting due dates and reporting data entry is correct in accounting system.
  • Develop trainings and provides oversight to facilitate the preparation of reports and documentation required by funding agency.
  • Verify personnel costs are mapped and allocated to appropriate projects, including time studies are completed per applicable grant requirements.
  • Coordinate with Program Manager and Purchasing to provide sound advice and recommendations regarding procurement actions.


4. Award closeout
  • Prepare financial closeout checklist using a timeline approach. Identify tasks that must be reviewed and completed 120, 90, 60 and 30 days before funding expires.
  • Advises and assists the Program Manager in fulfilling the departmental award closeout requirements, ensuring expenses do not exceed the award amount.

5. Post award audit
  • Ensuring project records are kept in good order and are readily available for review and audit.
  • Assists the Controller and other Grant Analyst with all internal and external auditors.
  • Reviews all documents submitted by the Accountants and program Manager before the Controller submits the information to auditors.
  • Responsible for all funding agency audits. Notify Assistant Finance Directors, by email, of all audit requests, issues, and the final outcome of the agency audit.

6. Post award compliance management
  • Adhere to 2 CFR part 200 appendix that contains the compliance supplement and the reference laws, regulations, and OMB Circulars/Uniform Guidance in determining compliance requirements.
  • Have complete understanding of the 12 areas of federal grant compliance.
  • Review SRPMIC policies and procedures to ensure compliance with all funding requirements.
  • Provide direct assistance in the formulation and implementation of Community policies and procedures in accordance with government regulations and organizational needs and objectives.
  • Monitor budgets for proper use of funds. Ensure compliance with agency requirements regarding purchasing regulations, equipment inventory, and closing documents.
  • Analyze, interpret and apply Federal, State Local Government, and private funder's statues, rules and regulations.
  • Works with Finance team and program staff to ensure that key processes and systems are in place to manage grant risk assessments, donor financial compliance, and reporting management processes.

7. Management Reporting
  • Post project information in a central location that can be accessed by internal customers.
  • Report funding metrics in the quarterly and annual management reports.
  • Create ad hoc funding reports for management.

8. Performs other duties as assigned to maintain and enhance program and agency operations.

Knowledge, Skills, Abilities and Other Characteristics:
  • Knowledge of the culture, customs, traditions, history and government of the Salt River Pima-Maricopa Indian Community.
  • Knowledge of general accounting, auditing and budgeting principles and practices.
  • Knowledge of generally accepted accounting practices for governments (GASB/Fund Accounting).
  • Knowledge of the financial reporting requirements of the Federal and State programs with which the Salt River Pima-Maricopa Indian Community is involved.
  • Knowledge of PeopleSoft software.
  • Knowledge of 2 CFR Part200

  • Skill establishing and maintaining effective working relationships with Federal and State representatives, regulatory agencies, Tribal Officials, Community Members, SRPMIC department directors and co-workers and the public.
  • Skill reviewing and evaluating a variety of financial and budgetary records.
  • Skill understanding and applying complex rules, regulations, procedures, and guidelines.
  • Skill preparing a variety of computerized financial and budgetary records and reports.
  • Skill applying strong analytical and interpersonal abilities.

  • Ability to communicate effectively both orally and in writing.
  • Ability to prepare and maintain accurate and timely records of financial transactions.
  • Ability to utilize the personal computer and related software including, but not limited to, MS Office.
  • Ability to operate a variety of standard office equipment including adding machines, scanners, calculators, typewriters, photocopiers, and FAX machines.
  • Up to date knowledge and understanding of the Uniform Grant Guidance and related requirements.
  • Ability to lift up to 45 lbs. (stored audit/research documents)

Minimum Qualifications

Education: A Bachelor's degree from an accredited college or university in Finance, Accounting, Public Finance Administration, Business Administration or closely related field; AND

Experience:
  • A minimum of five (5) years of continuous experience in financial management, financial analysis or grant compliance in a Tribal government; OR
  • A minimum of seven (7) years continuous full time experience working in the financial management, financial analysis or administration, including working with financial regulations, grants and contracts.

Preferred:
  • Master's degree
  • CPA
  • Three (3) years Project Management experience
  • PeopleSoft software


Equivalency : Any equivalent combination of experience and education that will allow the applicant to satisfactorily perform the duties of the job may be considered when filling the position.

Underfill Eligibility: An enrolled Community Member whom closely qualifies for the minimum qualifications for a position may be considered for employment under SRPMIC Policy 2-19, Underfill.

Special Requirements
  • May be required to work beyond normal work hours including nights, weekends and holidays.

Prior to hire as an employee, applicants will be subject to drug and alcohol testing. Will be required to pass a pre-employment background/fingerprint check. Employees are subject to random drug and alcohol testing.

"SRPMIC is an Equal Opportunity/Affirmative Action Employer" Preference will be given to a qualified : Community Member Veteran, Community Member, Spouse of Community Member, qualified Native American, and then other qualified candidate.

In order to obtain preference, the following is required: 1) Qualified Community Member Veteran (DD-214) will be required at the time of application submission 2) Qualified Community Member (must provide Tribal I.D at time of application submission),3) Spouse of a Community Member (Marriage License/certificate and spouse Tribal ID or CIB is required at time of application submission), and 4) Native American (Tribal ID or CIB required at time of application submission).

Documents may be submitted by one of the following methods:

1) attach to application

2) fax (480) 362-5860

3) mail or hand deliver to Human Resources.

Documentation must be received by position closing date.

The IHS/BIA Form-4432 is not accepted .

Your Tribal ID/CIB must be submitted to HR-Recruitment-Two Waters.
b986682de4a3939e752ad20395203e8f