Financial Research Administrator II
Financial Research Administrator II
Job no: 498204
Position Type: Staff Full Time
Campus: UMass Boston
Department: Research & Sponsored Programs
Pay Grade: 30
Date opened: 07 Mar 2019 Eastern Standard Time
Applications close: 08 Apr 2019 Eastern Daylight Time
Reporting to the Assistant Vice Provost, Research Accounting and Financial Compliance in the Office of Research and Sponsored Programs (ORSP), the Financial Research Administrator II will be responsible for a portfolio of less complex awards from various funding agencies and multiple contract types with major duties to include award/project set-up; bill plan set-up; billing; payment processing; accounts receivable; post-award management; subrecipient monitoring; financial reporting; and close-out of sponsored funding awards.
The Financial Research Administrator II will also be responsible for providing comprehensive post-award management of sponsored funding that supports university policies, fairly applies rules and regulations of all sponsors and the university, supports and improves the financial expertise of ORSP and builds processes to support ORSP and the research community.
Examples of Duties:
- Responsible for timely set-up of sponsored awards, contracts, projects including all milestones within portfolio; create and maintain research accounts in central financial systems on a current basis;
- Responsible for timely set-up of bill plans within portfolio; utilize standardized reporting queries to effectively maintain bill plan information in PeopleSoft financial system for all sponsored research awards; review and implement approved bill plan updates;
- Responsible for timely billing of sponsored research awards within portfolio; create and generate invoices to sponsors for all sponsored contracts, including letter or credit (LOC) cost, prepaid and other scheduled invoices, and mail, e-mail, and/or upload invoices to ensure timely payment of such invoices for all non-LOC awards; research and obtain information required for invoices; communicate with sponsor contacts on a regular basis to ensure the delivery and receipt of invoices; run, review and analyze queries and reports to ensure that all invoices agree with the prebill report;
- Provide analytical reports and/or analysis to management, as needed; identify any patterns or discrepancies within data;
- Responsible for timely processing of payments received for sponsored research invoices within portfolio; prepare deposit slips for payments received, deliver deposit package to Bursar’s Office daily, and receive deposit records from Bursar’s Office for all funds deposited; record deposits in PeopleSoft grants module and apply payments to accounts receivable items; ensure that payments are deposited and applied to the correct sponsored award; maintain accurate reconciliation records to track the application of each accounts receivable item;
- Responsible for the timely monitoring of accounts receivable of sponsored research invoices within portfolio; utilize PeopleSoft reports to review and analyze accounting data and unidentified accounts receivable billing and/or payment discrepancies; prepare and distribute reminder letters to sponsor contacts regarding outstanding receivables: contact sponsors on outstanding accounts receivable and past due invoices; process all accounts receivable transfer requests related to sponsored research contracts; determine when additional action is required to ensure payment is received;
- Reconcile all accounts receivable items to the general ledger on a bi-monthly and annual basis;
- Responsible for award management of sponsored research projects within portfolio; utilize PeopleSoft reports to review and analyze accounting data to identify errors or areas of concern, and develop recommendations for solutions; monitor over expenditures, both billed and unbilled accounts receivable, deferred revenue, allowance for doubtful accounts and grants unapplied deposits to ensure monthly values are within target ranges; research cost transfers and expenditures for research projects to ensure allowability and allocability;
- Provide assistance to Principal Investigators (PIs) and Grant/Business Managers in interpreting award terms and conditions and maintaining best financial practices;
- Work collaboratively with all administrative departments to resolve issues related to budgets, date ranges, expenditures, invoicing, financial reporting, other reporting, and closeout as needed;
- Work closely with senior-level administrators and departmental staff to ensure compliance with sponsor requirements;
- Responsible for timely subrecipient monitoring of sponsored research awards; record new fully-executed subcontracts in PeopleSoft; distribute new fully-executed subcontracts to PI and Department; produce a report for ORSP management monthly on the status of items;
- Responsible for timely approval of grant-related sub-recipient items, including sub-recipient purchasing (in BuyWays, new sub-recipient requisitions, change orders, etc.); responsible for timely approval of grant-related purchasing (in BuyWays - new requisitions, changes, etc.); responsible for cost transfers (AP vouchers, journals, ProCard journals, etc.) for items within portfolio;
- Responsible for timely financial reporting of sponsored research awards within portfolio;
- Responsible for close-out of expired sponsored research awards within portfolio; prepare sponsor refund requests related to grants and contracts; prepare all credit billing and small balance write-offs; utilize un-posting/posting functionality to correct deposit applications; work with PI to transfer over expenditures to non-sponsored projects;
- Work with Financial Administrator IV to provide supporting documentation, and/or status updates for audit items within portfolio;
- Participate in specialized training activities related to sponsored programs;
- Participate in developing documentation related to sponsored programs;
- Participate in improving university business processes related to the conduct of sponsored programs;
- Perform other duties as assigned.
Bachelor’s Degree in business, finance or a closely related field and a minimum of three to five (3-5) years of work experience in accounting or finance field, which must include a minimum of three (3) years of experience directly related to sponsored research administration in an academic or equivalent setting, is required. An additional four years of the required work experience can be substituted for the required Bachelor’s Degree.
Demonstrated proficiency with PeopleSoft Financial and Grants Module or similar enterprise-wide accounting system (Oracle, SAP, Banner, Workday, etc.) required. Demonstrated proficiency in identifying, interpreting, communicating, and applying federal financial reporting requirements, including OMB Uniform Guidance (previously A-133, A-21, A-110) PHS Grants Policy Statement, FAR Clauses required. Demonstrated proficiency in comprehending, interpreting, communicating, and applying grant recipient and granting agency policies, procedures and regulations pertaining to grants, contracts, cooperative agreements, and sub-awards required.
- Demonstrated intermediate-level proficiency in identifying, interpreting, communicating, and applying federal financial reporting requirements, including OMB Uniform Guidance (previously A-133, A-21, A-110) PHS Grants Policy Statement, FAR Clauses.
- Demonstrated intermediate-level proficiency in comprehending, interpreting, communicating and applying grant recipient and granting agency policies, procedures and regulations pertaining to grants, contracts, cooperative agreements, and sub-awards.
Knowledge, Skills, and Abilities:
- Demonstrated intermediate-level knowledge of common desktop database and spreadsheet applications (Microsoft Office, FileMaker, BrioQuery, Lotus, Google docs, etc.);
- Demonstrated intermediate-level knowledge of general ledger accounting/financial systems (Quickbooks, Sage, etc.);
- Demonstrated intermediate-level knowledge of business intelligence tools (SUMMIT, etc.);
- Demonstrated intermediate-level proficiency with automated billing, accounts receivable and/or cash management systems and processes;
- Demonstrated intermediate-level use creating and using complex mathematical calculations and formulas in Excel to solve accounting problems;
- Demonstrated intermediate-level proficiency in reading, analyzing, and interpreting documents such as financial reports, accounts, and ledgers;
- Demonstrated intermediate-level proficiency in analyzing accounting data, identifying errors and/or areas of concern, and making appropriate recommendations to resolve issues;
- Ability to develop self-audit skills to ensure accuracy of billing, deposit and collection functions;
- Ability to work in a deadline-driven environment, while prioritizing competing deliverables on time in a fast-paced environment;
- Ability to give and follow written and verbal instructions in a precise, understandable manner;
- Ability to maintain accurate records;
- Ability to work independently and as part of a team;
- Strong oral and written communication skills;
- Strong analytical, organizational and problem-solving skills;
- Strong interpersonal skills;
- Strong commitment to customer service.
Please apply online with your resume, cover letter, and list of three professional references.
Review of candidates will begin following the application closing date.
Only Internal candidates in the Professional Staff Bargaining Unit will be considered during the first 7 business days of the posting. All other candidates will be considered after that period.
Salary Ranges for the appropriate Pay Grade can be found at the following link:
Grade 30 position, salary associated to Grade 32.
Applications close: 08 Apr 2019 Eastern Daylight Time