This is a level 2 business analyst position responsible for the business process analysis, design, testing, and implementation of the compliance activities of the Research Compliance Office (RCO). This position works under the direction of the Director of RCO.
The RCO serves the Vice President for Research and supports the research community by developing and managing research compliance monitoring systems, investigating research compliance concerns, overseeing research ethics and compliance education, and assisting other ethics, regulatory, and financial compliance programs across the University.
RCO manages the Certified Approver Community of Practice. Certified approvers are responsible for ensuring that expenditures are consistent with University policy, sponsor requirements, and applicable law.
Data Queries and Reports (40%)
Works with RCO staff to determine research needs and documents the business requirements.
Uses system knowledge to develop, evolve, and manage relational databases, the formatting of data fields, and the reporting of data limitations.
Writes data queries and tests data to ensure it meets the business need. Develops knowledge of the underlying process to ensure the correct data has been captured and reported.
Confirms data points and changes in business processes with business owners to ensure underlying assumptions are correct.
When necessary, acts as liaison to the Information Technology unit of the Office of the Vice President for Research.
Conducts trending analysis and generates reports on data from a variety of sources including transaction reviews, risk summary reports, unit, process and/or ad hoc reviews. Also included are data collected as part of the Research Compliance Committee (RCC) data repository
Compiles, merges, and processes data from a wide range of sources to provide analysis of compliance breakdowns, identification of whether a given breakdown is related to an individual, a unit, or a college, and if it is systemic and pertains to more than one aspect of the research process (for example issues with consenting and financial management or clinicaltrials.gov registration).
Creates data queries on Research Assistant compensation cap.
Research Education Management (15%)
Manages interfaces between data warehouse and research proposal routing form (PRF) reporting and email notifications.
Manages queries related to RCO-managed reporting of Responsible Conduct of Research (RCR) and Student Sponsored Research Ethics (SSRE).
RCO Website Lead (5%)
Works with staff to determine business needs of website.
Documents the business requirements and develops an accountability matrix for website content.
Works with communications area on correct appearance.
Develops a plan for website content maintenance.
RCO Business and Data Requirements (35%)
Evaluates business and data requirements based on RCO’s compliance heat map and other needs determined by management.
Works with other areas of the University, when needed, to determine correct data and to avoid duplication by using what already exists within the University.
Creates reports that help the RCO monitor research compliance. Examples are trending reports, data requests to other offices to ensure their compliance, reports showing key data points, etc.
Re-evaluates reports yearly to ensure they continue to meet RCO’s needs.
Other duties as assigned (5%)
BA/BS degree required.
Two years of work experience in the areas of business or systems process analysis with a related degree or four years of work experience in the areas of business or systems process analysis with a non-related degree.
Working knowledge of project management techniques.
Experience with SQL and working knowledge of relational databases.
Experience with Microsoft Suite, particularly good skills with Excel and Access.
Understanding of basic statistical terms (e.g., mean, median, mode, variance)
Excellent understanding of information needed to support business processes and decision-making.
Strong documentation skills.
Ability to make presentations to internal and external audiences.
Excellent business and statistical analysis skills and ability to identify innovative solutions to operational issues.
Strong analytical, organizational, time management, and problem solving skills.
Excellent written and verbal communication skills.
Attention to detail.
Ability to work on teams and independently in a task-based environment.
Ability to contribute to a collaborative work group environment.
Ability to interact professionally with diverse groups, across disciplines, and with executives, managers, and subject matter experts.
Utilize reporting tools for enterprise-level data or tools within current business applications for department-level data to inform decision-making. Experience with EFS, HR, student, and grants and contracts data, OnCore, ETHOS, UM Analytics or other databases.
Ability to sufficiently understand and analyze data to recognize anomalies and problems and suggest corrective actions.
Ability to learn new databases not listed above and to collaborate with other data analysts as needed.
Familiarity with Stata, SAS, and/or R.
Previous employment experience in higher education, government, or a public entity is a plus.
Ability to communicate technology concepts effectively with technically proficient and non-technically proficient individuals.
Internal Number: 333673
About University of Minnesota, Twin Cities
The University of Minnesota, founded in the belief that all people are enriched by understanding, is dedicated to the advancement of learning and the search for truth; to the sharing of this knowledge through education for a diverse community; and to the application of this knowledge to benefit the people of the state, the nation, and the world.