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.
A fully remote work situation (100%) is available.
Being part of something greater, of serving a larger mission of discovery and care — that's the heart of what drives people to work at Michigan. In some way, great or small, every person here helps to advance this world-class institution. It's adding a purpose to your profession. Work at Michigan and become a victor for the greater good.
The Office of Research and Sponsored Projects (ORSP) safeguards and advances U-M’s research enterprise by providing its partners with effective and efficient pre-award and non-financial post-award services for the compliant administration of externally sponsored grants, contracts, and ancillary agreements.
The Business Intelligence Analyst Intermediate position supports external sponsor systems (*** please see below), including the creation and management of institutional accounts, development of documentation, and technical support. The Business Intelligence Analyst Intermediate will be responsible for the design, development and implementation of a system to track and manage access to external sponsor systems for UM central offices and campus users. The Business Intelligence Analyst Intermediate also supports sponsored research data reporting and analytics with application tools, including but not limited to, U-M’s Business Objects, Oracle, SQL, Tableau, and other application tools. The best candidate is responsive to end user needs, and has the ability to work with and communicate effectively with technical and non-technical colleagues and customers.
***An external sponsor is any granting agency outside the University. It includes both governmental and non-governmental (private) sponsors. An external sponsor system is a web-based grant management service/user interface. These are sponsor-specific electronic systems or portals for proposal preparation and/or submission. Examples of sponsor-specific systems include FastLane/Research.gov Systems, and Proposal Central.
Setup and manage institutional accounts in sponsor systems. Research and document appropriate user access and roles in a sponsor systems database. Design and document business processes for accessing sponsor systems used by ORSP staff for proposal submissions and award management. (35%)
Design, develop, implement, and maintain a database application to manage access across central offices and UM research community to sponsor systems. Coordinate with other UM central office stakeholders to ensure continuity of managed sponsor systems. (15%)
Analyze and determine informational needs; and data output and reporting capabilities from sponsor systems in order to combine reports from sponsor systems and UM systems. Reporting from sponsor systems. (15%)
Develop, customize and revise sponsored research custom reports, eResearch data integrity reports, scheduled reports, and dashboards for ORSP and the research community. (20%)
Sponsor code and eResearch data audits. (15%)
BA or BS degree in a quantitative field or combination of education and relevant experience.
3 to 5 years related experience.
Knowledge of query tools such as SAP Business Objects, Oracle SQL, and Tableau.
Experience with database software including design, implementation, maintenance, and reporting.
Demonstrated ability to input and manage data with a high degree of accuracy.
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.
Knowledge of sponsor systems such as eRA Commons, Proposal Central, ARIBA, etc.
Demonstrated project management skills and ability to deliver reporting on time.
Familiarity with U-M policies and procedures related to research administration (including, but not limited to, accounting, purchasing, personnel, and regulatory compliance).
Benefits at the University of Michigan
In addition to a career filled with purpose and opportunity, The University of Michigan offers a comprehensive benefits package to help you stay well, protect yourself and your family and plan for a secure future. Benefits include:
Generous time off
Many choices for comprehensive health insurance
Long-term disability coverage
Flexible spending accounts for healthcare and dependent care expenses and parental leave options
Remote and hybrid working arrangements available as well as flexible scheduling
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 are performed in compliance with the Fair Credit Reporting Act.
Job openings are posted for a minimum of seven calendar days. The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled anytime after the minimum posting period has ended.
The University of Michigan is an equal opportunity/affirmative action employer.
U-M COVID-19 Vaccination Policy
COVID-19 vaccinations, including boosters when eligible, are required for all University of Michigan students, faculty and staff across all campuses, including Michigan Medicine. This includes those working remotely. More information on this new policy is available on the Campus Blueprint website or the UM-Dearborn and UM-Flint websites.
A great university is made so by its faculty and staff, and Michigan is recognized as one of the best universities to work for in the country. The Michigan culture is known for engaging faculty and staff in all facets of the university to create a workplace that is vibrant and stimulating.For two consecutive years, the Chronicle of Higher Education has placed U-M in its "Great Colleges to Work For" survey. In particular, the university earns high marks for strong relations between faculty and administrators, a collaborative system of governance, strong pay and benefits, and a healthy work/life balance.