The URA Reporting & Data Analyst position is a professional position at the University of Chicago University Research Administration (URA) office. Primarily, this position will support the reporting needs of the URA Office, and broader campus community, with a special emphasis placed on Post-Award (Financial/Payroll) reporting. This position will utilize existing stock reports to provide data, as requested, and design new reports to meet more sophisticated data requests â“ often time sensitive in nature. This position will work independently to conduct requirements gathering sessions with reporting users (as necessary) to enhance reporting practices and make recommendations for improvements to the overall reporting architecture. This position will develop strategic plans for enhancing our data capturing and reporting practices.
The Reporting & Data Analyst will lead the process of cross-checking, cleaning, reorganizing and modeling data for leadership and arrive at meaningful conclusions â“ providing expert guidance when data driven decisions are required, quickly visualizing data in charts/tables to specifications. This position will implement innovative reporting strategies that contribute to the overall success of the research community, as well as demonstrate expert knowledge in all research administration/finance systems on campus (AURA, FAS, Business Objects, Tableau, ACCTS, PETS, GEMS, e-Payments, et al.).
This position will be responsible for development and regular updates of training materials for reporting users. Conduct campus sessions and meet with users individually, as requested, to ensure users can access the information they need to make data driven decisions. This position will ensure users have proper access and training to run reports on sponsored funding (currently via the application SAP Business Objects); expertise on all standard UCDW reports, the Research Data Dashboard â“ which includes proposal, award, and expenditure data in one dynamic report with options to drill into data by multiple variables including Division, Department, Funding Agency, and Principal Investigator â“ as well as other ad hoc reports. The position will have the ability to create new reports (or modify existing) as requested.
This position will be instrumental in assuring the campus community has a positive experience when interacting with the sponsored programs database, feels supported and receives fast, accurate responses to data/reporting needs.
Prior experience in Research Administration, Business Objects, Tableau, AURA, PETS, GEMS, e-Payments, Grants.gov and other agency systems strongly preferred.
Responsible for Refreshing, designing and developing new reports with special emphasis placed on providing Post-Award (Financial/Payroll) data to key leadership within the URA Office
Manipulate and translate data once exported from Business Objects/Tableau to create spreadsheets, graphs, and other visually compelling diagrams to assist users in understanding complex data sets; write formulas to summarize data into user-friendly reports for presentations or staff meetings
Responsible for gathering technical reporting requirements when stock reports do not meet the needs of reporting requests/users; provide creative solutions in the interim with data that is available/accessible.
Analyze large volumes of data, be it structured or unstructured, and provide meaningful conclusions to functional/business owners
Research, review, and analyze the effectiveness and efficiency of existing reporting procedures; develop strategies for enhancing or leveraging these processes and systems for the benefit of campus users. Work directly with users to understand, define, and document current and possible future reporting goals, needs, and requirements
Provide Help Desk Support/Coverage within the URA eRA Group for AURA, eRA Commons, NSF Research.gov and other research administration systems/portals in use across campus (including websites)
Responsible for development and regular updates of training materials for reporting users. Conduct campus sessions and meet with users individually, as requested, to ensure users can access the information they need to make data driven decisions
The position will help support the URA Training Group in the management of all current educational programs/initiatives along with any future expansions. This position will help develop specific training and educational materials for research administration on campus, meet with new/novice administrators, and provide resources and opportunities for one-to-one training as requested.
Strong technical skills including the ability to merge data from various sources/data universes, write formulas to summarize data, translate data into a user-friendly reports, and data mine for necessary drill-down metrics
Proficiency in Microsoft Office Suite, especially Excel (VlookUps, Index Match, Pivot Tables, custom formulas, etc.)
Experience and advanced level proficiency working in Business Objects. Able to quickly comprehend current reporting practices, troubleshoot issues, develop/create complex reports, and translate data once exported
Ability to work independently while being able to prioritize and accomplish objectives in a timely manner
Demonstrated ability to work in a high volume and stressful environment
Excellent organizational skills with demonstrated ability to prioritize and efficiently manage multiple tasks
Excellent written and oral communication skills
Ability to pay close attention to detail and provide reports with essentially no errors
Must be mature, self-motivated, responsible individual who is able to initiate and complete routine and non-routine tasks unassisted
Ability to work effectively with individuals at various organizational levels, using tact, courtesy, and maintaining confidentiality
Education, Experience or Certifications:
Bachelor's degree, in related field of study required, advanced degree preferred
Minimum requirements include knowledge and skills developed through 2-5 years of work experience in a related job discipline
Experience in information system technologies/reporting required
Experience working in a sponsored programs research administration office, or in an academic environment preferred
Experience with University of Chicago systems such as AURA, FAS, Business Objects, Tableau, ACCTS, PETS, GEMS, e-Payments preferred
Note: When applying, all required documents MUST be uploaded under the Resume/CV section of the application.
The University of Chicago is an Affirmative Action/Equal Opportunity/Disabled/Veterans Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national or ethnic origin, age, status as an individual with a disability, protected veteran status, genetic information, or other protected classes under the law. For additional information please see the University's Notice of Nondiscrimination.
Staff Job seekers in need of a reasonable accommodation to complete the application process should call 773-702-5800 or submit a request via the Applicant Inquiry Form.
The University of Chicago's Annual Security & Fire Safety Report (Report) provides information about University offices and programs that provide safety support, crime and fire statistics, emergency response and communications plans, and other policies and information. The Report can be accessed online at: securityreport.uchicago.edu. Paper copies of the Report are available, upon request, from the University of Chicago Police Department, 850 E. 61st Street, Chicago, IL 60637.
Internal Number: JR03960
About University of Chicago
One of the world's premier academic and research institutions, the University of Chicago has driven new ways of thinking since our 1890 founding. Today, UChicago is an intellectual destination that draws inspired scholars to our Hyde Park and international campuses, keeping UChicago at the nexus of ideas that challenge and change the world.