Apply Now Clicking "Apply Now" opens the link in a new window.

How to Apply

A cover letter is required for consideration for this position and should be attached as the first page of your resume. The cover letter should address your specific interest in the position and outline skills and experience that directly relate to this position.

Job Summary

The Office of Research and Sponsored Projects (ORSP) is the University of Michigan (U-M) office responsible for the submission of proposals, negotiation and acceptance of awards, and non-financial management of grants and contracts.  ORSP enables and safeguards the conduct of research and other sponsored activity for the University of Michigan. We apply specialized regulatory, statutory, and organizational knowledge in a timely and professional manner in order to balance the University's mission, the sponsor's objectives, and the investigator's intellectual pursuits.

ORSP is seeking candidates for a Data and Reporting Assistant.  The Data and Reporting Assistant will report to the ORSP Data and Reporting Manager, and will help support sponsored research data reporting and analytics including U-M’s Enterprise Data Warehouse, Business Objects, SQL, Tableau, Lucid Charts, and other application tools. The Data and Reporting Assistant will also be charged with developing documentation of, and providing support to ORSP staff, of sponsor electronic systems for proposal submission and award management. The best candidate is concerned with accuracy, and data integrity, is responsive to end user needs, and has the ability to work with and communicate effectively with technical and non-technical colleagues and customers. A salary outside of the posted range will be considered for the exceptionally qualified candidate exceeding posting qualifications.

Key responsibilities of the ORSP Data and Reporting Assistant at U-M include:

  • In collaboration with U-M stakeholders, design and implement business processes in support of best practices for interacting with sponsor systems, most often used by ORSP staff related to proposal submissions and award management, and serve as a resource to ORSP staff regarding these systems;
  • Develop, customize and revise eResearch Custom reports, graphs and dashboards for the University of Michigan Office of Research, ORSP, and the research community;
  • Develop, monitor and support ORSP business processes such as eRPM inbound emails, sponsor codes requests, U-M cost share reports, and eResearch data integrity reports;
  • Attend weekly scheduled meetings with the ORSP Data and Reporting Manager;
  • Provide on-going documentation for job duties; and
  • Other duties as assigned, including collaboration with team members and customers in all aspects of eResearch systems (ie. Assist in the annual revisions of existing Lucid Charts transition maps, and assist in the design, and implementation of maps for new business processes).

Required Qualifications*

  • Bachelor’s degree or equivalent experience and education
  • 2 - 4 years of experience in a related role requiring confidentiality, timeliness, customer service, organization, prioritization, troubleshooting and working independently to successfully develop, maintain and support systems / applications
  • Excellent work ethic
  • Ability to work independently, prioritize work and multitask in a time sensitive, high volume work environment
  • Ability to maintain confidentiality in office operational transactions.
  • Excellent customer service skills
  • Excellent interpersonal skills, including strong active listening skills, highly developed emotional intelligence, ability to work well as a team member, and a positive attitude
  • Ability to input and manage data with a high degree of accuracy
  • A commitment to personal and professional integrity, and a strong sense of accountability
  • Strong proficiency of Microsoft Office (including MS Word, Excel, and PowerPoint), database, email and calendar-keeping software
  • Some programming knowledge
  • Demonstrated excellent organizational skills
  • Demonstrated ability to communicate clearly, correctly, knowledgeably, and effectively
  • Demonstrated ability to develop and maintain positive and cooperative relationships
  • U.S. Citizenship or Lawful Permanent Resident Status: ORSP deals with export controlled information, the handling of which is regulated by the U.S. Federal Government and access to which is restricted to U.S. Citizens and Lawful Permanent Residents

Desired Qualifications*

  • Significant knowledge of eResearch systems, in particular Proposal Management
  • Significant knowledge of Business Objects, and SQL, Tableau
  • Significant knowledge of Filemaker Pro
  • Experience with LucidCharts
  • Experience with Qualtrics
  • Experience with Google Suite of products

Underfill Statement

This position may be underfilled at a lower classification depending on the qualifications of the selected candidate.

Background Screening

The University of Michigan conducts background checks on all job candidates upon acceptance of a contingent offer and may use a third party administrator to conduct background checks. Background checks will be performed in compliance with the Fair Credit Reporting Act.

Application Deadline

Job openings are posted for a minimum of seven calendar days. This job may be removed from posting boards and filled anytime after the minimum posting period has ended.

U-M EEO/AA Statement

The University of Michigan is an equal opportunity/affirmative action employer.