Research Administrator, Robotics Institute-2008217
The Robotics Institute seeks an energetic, flexible, and customer service oriented team member to support the operations of the institute. In this position, you are responsible for a broad range of post award grant and contract management (i.e. fiscal, compliance, reporting, award management) as well as other business functions supporting multiple faculty members and/or laboratories that have multiple moderately complex grants with different end dates. You will interpret regulations and guidelines for award management (both university and agency); consult with faculty on various options/scenarios that can be used in award execution; develop forecasts and budgets and oversees post-award management setup through close-out; collaborate with other university departments (OSP, SPA etc.) and sponsoring agencies; approve expenditures against sponsored projects and other accounts and regularly perform data queries, analyses, and forecasts in support of the Robotics Institute business office.
Your core responsibilities will include:
Post Award Administration - Act as RI Campus primary sponsored project post-award administrator. Work closely with SPA on sponsored project award management from account setup, ongoing management, and final award closeout. Establish accounts in financial systems, re-budgets, funds, and monitors or modifies awards and expenditures. Complete expense and labor re-distributions transactions. Create payroll distribution adjustments, feeder cost transfers, and accounts payable redistribution forms. Obtain needed signatures for completion and routes forms to appropriate department for processing and ensures financial posting of correcting transactions. Monitor and coordinate the subcontracting process and approves invoices or routes them for approval to Principal Investigator/s. Provide financial reporting to faculty or sponsors on various sponsored projects and for various programs on a monthly, quarterly or annual basis. Conduct variance analysis; research the causes of variances between planned and actual expenses. Work with other areas of the university (Office of Sponsored Projects, Sponsored Projects Accounting, Procurement, etc.) on a regular basis to solve complex problems related to labor allocation, accounting, and post-award related issues. Interprets regulations and guidelines for program funding (both university and agency) for multiple moderately complex grants. Provide monitoring of grants and contracts to ensure expenses are being paid according to contracts. Prepare reports for sponsoring agencies. Provide faculty members with various options and scenarios that can be used in award planning or during the execution of the work (i.e. assessing labor allocation and distribution across multiple awards, etc.). Develop forecasts, and budgets for faculty members and may on occasion assist in proposal creation and submission, including the preparation of proposal budgets, often with multiple subcontractors.
Expense Approvals – Review and approve RI's campus ER (primary) and PRC (secondary) expenses. Provide guidance on university's Business and Travel Expense and Purchasing Card policies. Act as "go to" resource for ER and P-Card questions and concerns. Work closely with institute's faculty, staff, and students to make certain ERs and PRCs and their business justifications meet published policies and guidelines. Answer all routine and most unique questions directly. Work closely with university's central administration; i.e., Oracle Help Desk, Accounts Payable, Procurement, Internal Audit etc. to aid in meeting university policies. Respond to ER and PRC audit requests from the Finance division. Actively mentor transaction preparers to create transactions in an efficient and compliant manner.
Query, Report Management, Data Analysis - Prepare various standard or custom financial queries on a monthly basis and actively works accounts for balancing and closing. Prepare monthly Budget Management Spreadsheet and distribute to business managers. Prepare monthly GM FY Funding Source Actuals and Forecast report. Prepare and manage monthly At-Risk query, analysis, and resolution. May perform data analysis and financial forecasting for various sponsored and non-sponsored funding sources.
Other – Other business duties as required in support of the operations of the Robotics Institute.
You should have excellent interpersonal, communication, and organizational skills, as well as good analytical and problem solving skills. Adaptability, excellence, and passion are vital qualities within the Robotics Institute. Inclusion, collaboration and cultural sensitivity are valued competencies at Carnegie Mellon University. Therefore, we are in search of a team member who is able to effectively interact with a varied population of internal and external partners with a high level of integrity. We are looking for someone who shares our values and who will support the mission of the university through their work.
Bachelor's degree in Accounting, Business/Business Administration, Finance or other relevant field required
Certified Research Administrator certification preferred
At least one year of relevant sponsored research administration or accounting experience required
Carnegie Mellon (www.cmu.edu) is a private, internationally ranked research university with programs in areas ranging from science, technology and business, to public policy, the humanities and the arts. More than 12,000 students in the university’s seven schools and colleges benefit from a small student-to-faculty ratio and an education characterized by its focus on creating and implementing solutions for real problems, interdisciplinary collaboration and innovation. A global university, Carnegie Mellon’s main campus in the United States is in Pittsburgh, Pa. It has campuses in California’s Silicon Valley and Qatar, and programs in Africa, Asia, Australia, Europe and Mexico.