DescriptionUniversity of Colorado Denver l Anschutz Medical Campus
Office of Grants and Contracts
Reporting & Data Analyst
Position #728340 – Requisition 21655
* Applications are accepted electronically ONLY at www.cu.edu/cu-careers
*The Office of Grants and Contracts has an opening for a full-time University Staff (unclassified) Reporting & Data Analyst position.
The University of Colorado Denver | Anschutz Medical Campus is a public research university serving more than 18,000 students. We award nearly 4,000 degrees each year, including more graduate and professional degrees than any other Colorado institution. With our solid academic reputation, award-winning faculty and renowned researchers, we offer more than 140 highly rated degree programs through 13 schools and colleges. The university receives over $400 million in research awards each year. In addition to the wide array of health-related programs and facilities offered at CU Anschutz in Aurora, Colo. a significant number of undergraduate and graduate degree programs are taught at CU Denver, our comprehensive campus in the heart of downtown Denver—one of America’s most vibrant urban centers. CU Denver is located steps from the Denver Center for Performing Arts and the LoDo District affording our students, faculty and staff access to a broad array of academic, professional, community, recreational and cultural outlets.A national leader in health care and life sciences, CU Anschutz is the only comprehensive academic health sciences center in Colorado and the largest in the Rocky Mountain region. Located in Aurora, Colo., it is one of the newest education, research and patient care facilities in the world. With six schools and colleges, CU Anschutz trains the health sciences workforce of the future by blending education, research and clinical care all in one place. This strategic collaboration among diverse health care fields allows knowledge to travel directly from the research bench to the patient’s bedside. Read CU Anschutz Quick Facts here. CU Anschutz
The University of Colorado Anschutz Medical Campus ranks among the top institutions nationally in clinical care, education and research. Its 230-acre campus, designed to enhance collaboration and interprofessional education, hosts the College of Nursing; the Schools of Dental Medicine, Medicine, Pharmacy, and Public Health; the Graduate School; a Health Sciences Library; and two hospitals. Strategically located contiguous to the campus are a biosciences research park and the soon-to-be-completed Veterans Hospital. CU Anschutz offers two undergraduate degrees, 35 graduate degrees, and five first-professional programs. More than 4,000 students learn alongside faculty members who also make meaningful medical discoveries and provide expert clinical care through 1.5 million patient-visits annually. A hub for research and innovation, CU Anschutz receives over $400 million in research awards each year and has filed 1,300 patent applications and formed 53 new companies since 2002. Position Emphasis
The Reporting and Analysis Unit within Financial Services is responsible for preparing sponsored project financial reports that are available to faculty and staff in the management of sponsored research. This position also prepares performance metrics to evaluate whether or not the Office of Grants and Contracts (OGC) is meeting performance goals with respect to award processing, contract reviews, and sponsored programs closeouts.This position supports data quality and reporting of the PeopleSoft and eRA applications. This includes providing data analysis, reporting, research, and rollout of reporting tools to OGC and departments while providing process automation within OGC.This position serves as the primary resource for data and reporting needs for sponsored projects to assist department/grant administrators and Principal Investigators with grants management including compliance with federal and sponsor policies. In addition, this position will assist with the creation of automated tools to assist the PostAward unit in performance of their oversight and job responsibilities for grant management. Duties and responsibilities of this position include, but are not limited to:
- Collaborate with internal OGC team to develop automated tools, metrics, and reports to streamline processes, increase efficiencies, and provide compliance oversight.
- Provide data for ongoing metrics for the department and subunits within OGC. Develop a dashboard that can be used by the team to manage their processes. The position needs to understand the data processes to ensure the numbers/metrics are accurate within that context.
- Understand and interpret federal (Uniform Guidance) and university policies and procedures to develop and implement automated processes to ensure compliance and appropriate oversight.
- Develop and deliver University and Agency required reports to provide statistics on campus sponsored project activity (examples: NSF Herd Report, US News & World report).
- Process ad-hoc reporting requests from University Counsel, campus departments, Vice Chancellor of Research and others within OGC. Must understand the data and processes as well as how to extract the data to ensure the data provided is accurate and appropriate.
- Obtain business need (functional) specifications from users, and then interpret them into efficient data delivery solutions utilizing the University’s enterprise systems (e.g., eRA, CIW, PeopleSoft and COGNOS).
- Review existing reports, improve performance and visual representation of analytics.
PLEASE NOTE: Candidates will be responsible for travel expenses related to the interview process and any relocation expenses, if applicable.Salary and Benefits:
The approximate salary range is $50,315 - $65,000 per year.The salary of the finalist(s) selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, specialty and training.The above salary range (or hiring range) represents the University’s good faith and reasonable estimate of the range of possible compensation at the time of posting.The University of Colorado offers a full benefits package. Information on University benefits programs, including eligibility, is located at https://www.cu.edu/employee-services
- Bachelor’s degree from an accredited institution of higher education in business administration, finance, accounting or related field
- 2 years of experience in a database, reporting or information technology related role.
Substitution: A combination of education and related technical/paraprofessional experience may be substituted for the bachelor’s degree on a year for year basis.Preferred Qualifications
- Experience with the InfoEd electronic research administration application.
- Experience in sponsored project grant management.
- Experience with the University’s PeopleSoft and CIW tables and development of queries.
- Ability to effectively communicate, in writing and verbally, including presentation skills. Ability to establish and maintain effective working relationships with employees at all levels throughout the institution.Outstanding customer service skills.Demonstrated commitment and leadership ability to advance diversity and inclusion.
- Extremely organized and detail oriented
- High competency in utilizing database query tools such as Oracle SQL Developer, COGNOS, SQL Query Tools (e.g., Toad) and MS Access
- Knowledge of the InfoEd eRA, CIW, and PeopleSoft databases and structures
- Ability to define functional specifications and business case usage of data, followed by interpretation into technical specifications and coding
Finance and AccountingPrimary Location:
Jun 11, 2021Unposting Date: