Lead Data Analytics Analyst Associate (Grants Management) - 90333256 - Washington

Date: Jun 23, 2022

Location: Washington, District of Columbia, US, 20002

Company: Amtrak

Your success is a train ride away.

Amtrak connects businesses and communities across the country and we move America’s workforce toward the future. We employ more than 20,000 diverse, energetic professionals in a variety of career fields throughout the United States. The safety of our passengers, our employees, the public and our operating environment is our priority and the success of our railroad is the result of our employees.

Are you ready to join our team?

SUMMARY OF DUTIES:


Reporting to the Senior Director, Grants Management, this position provides support to the fund source management process, including determinations of funding sources for a multi-billion portfolio of activities, reporting, complex data analysis and reconciliations as well as systems updates.  This position also provides budgeting, financial analysis, and grants management support to project managers across the organization to ensure projects are being delivered in accordance with federal regulations and grants requirements. This position is responsible for maintaining consistent processes for pre and post award activities for a portfolio of grants and to help Amtrak meet reporting and compliance requirements of its grant agreements and promote best practices for the administration and use of grant funds. 

 

 

ESSENTIAL FUNCTIONS:

 

  • Update fund sources information in systems.
  • Fund Source data analysis and reconciliations.
  • Work with various departments to ensure grants are set up correctly in the financial systems.
  • Preparation of internal and external reporting of expenditures by fund source
  • Provide data support related to internal and external audits.
  • Support the pre-award application and post-award processes of federal grants.
  • Gather and analyze financial and narrative data, prepare and submit periodic reports to fulfill grantor requirements and provide context for management decisions.
  • Prepare and track required payment requests using SAP, MS Excel and other tools as required.
  • Support project managers to ensure projects funded by single use grants are being completed in accordance with the provisions of the grants.
  • Maintain detailed files and electronic records of grant documents according to generally accepted best practices for grants management.
  • Document compliance and administrative requirements of grant awards.
  • Create and maintain schedules of deadlines and work with program staff to ensure and maintain compliance.
  • In support of grant requirements, monitoring and oversight, plan and implement outreach and meetings with program staff and grantors, and prepare and maintain related documentation.
  • Analyze grant expenditures and activities to ensure they are allowable according to agreements, solve any deficiencies and propose corrective actions to avoid unallowable activities to be posted against the grants.
  • Other tasks, as assigned, to support the Office of Grant Management.

 

 

MINIMUM QUALIFICATIONS:

 

  • Demonstrated skills and experience in financial analysis and reporting using budgeting software and spreadsheets (Microsoft Excel).
  • Prior experience with direct responsibility for pre-award application and post-award administrative processes for federal grants, including audits;
  • Bachelor’s Degree in Accounting, Business Administration, or related field, or equivalent combination of education, training, and work experience;
  • Excellent math, written and verbal communication skills;
  • Demonstrated attention to detail in work products and document management
  • Proficiency in using general office software applications including Microsoft Excel, Word and PowerPoint.
  • Demonstrated knowledge of federal grant regulations and requirements;
  • Prior satisfactory job performance
  • Demonstrated PC software skills (Outlook, Excel, Word, PowerPoint, etc.);
  • Excellent math, analytical, written and verbal communications skills; 
  • Ability to work in a fast paced environment and multi-task
  • Ability to manage time and complete tasks with minimum supervision

 

 

PREFERRED QUALIFICATIONS:

 

  • Experience working with SAP Software or other ERP system
  • Working knowledge of 2 CFR 200 grant requirements
  • Previous experience with funds management systems
  • Previous experience working with transportation grant programs
  • Knowledge of transportation infrastructure, national transportation funding priorities and resources for transportation funding
  • Understanding of transportation planning and capital program development

 


COMMUNICATIONS AND INTERPERSONAL SKILLS:

 

  • Must have excellent oral and written communication skills.

Requisition ID:104201
Posting Location(s):District of Columbia
Job Family/Function:Finance 
Relocation Offered:No 
Travel Requirements:Up to 25% 

Amtrak employees power our progress through their performance.
 

We want your work at Amtrak to be more than a job – we want it to be a fulfilling experience where you find challenging and rewarding opportunities, respect among colleagues, competitive pay, benefits that protect you and your family and a high performance culture that recognizes and values your contributions and helps you reach your career goals.


All positions require pre-employment background check verification, a pre-employment drug screen and proof of full vaccination against COVID -19. Amtrak is committed to a safe workplace free of drugs and alcohol and performs pre-employment substance abuse testing. Marijuana, notwithstanding any statute, ordinance, regulation, or other law that legalizes or decriminalizes the use or possession of marijuana, whether for medical, recreational, or other use.  Candidates who engage in the usage of marijuana will not be qualified for hire.   Successful applicants for employment with Amtrak must be fully vaccinated against COVID-19 by the date of hire as a condition of employment, subject to requests for accommodation.  Fully vaccinated means 14 days have elapsed since receiving the second dose of the Pfizer or Moderna vaccine or 14 days since receiving the Johnson & Johnson vaccine.


In accordance with DOT regulations (49 CFR § 40.25), Amtrak is required to obtain prior drug and alcohol testing records for applicants/employees intending to perform safety-sensitive duties for covered Department of Transportation positions. If an applicant/employee refuses to provide written consent for Amtrak to obtain these records, the individual will not be permitted to perform safety-sensitive functions.


Note that any education requirement listed above may be deemed satisfied if you have an equivalent combination of education, training and experience.


Amtrak is an EOE/Affirmative Action Minority/Female employer, and we welcome all to apply. We consider candidates regardless of race/color, religion, sex (including pregnancy, childbirth and related conditions), national origin/ethnicity, age, disability (intellectual, mental and physical), veteran status, marital status, ancestry, sexual orientation, gender identity and gender expression, genetic information, citizenship or any other personal characteristics protected by law.



POSTING NOTES: Finance || Corporate Jobs