Note: The job is a remote job and is open to candidates in USA. The University of Minnesota is seeking an IT Professional 2 – Business Intelligence & Data Analysis for its Office of Research Information Systems. The role analyzes institutional data from multiple University systems, develops reports and dashboards, and provides insights and recommendations to support research and executive decision-making.
Responsibilities
- Acquire, validate, analyze, measure, and interpret datasets for executive and management level decision making
- Write and optimize complex SQL queries to extract, transform, and aggregate data
- Conduct transaction trend analyses by data mining to identify patterns using business intelligence analytic tools and make sound recommendations
- Conduct data modeling and analyses using accounting, economic, financial, and statistical principles and practices
- Conduct ad-hoc data investigations to answer pressing operational and institutional questions from RIO and University leadership
- Work closely with RIO leadership, the Vice President for Research, and other UMN Senior Administration to meet the University’s institutional research data and analysis needs
- Design, develop, and maintain reports, interactive dashboards, and analytical models to support strategic decision-making across academic, administrative, and operational units
- Validate incoming and historical data to ensure high standards of accuracy, integrity, and reconciliation across disparate databases
- Work with University data exchange consortia to complete external ranking surveys
- Develop and maintain a taxonomy of reports and queries as well as a reporting procedures repository
- Provide timely and thorough documentation of requirements, dashboards, processes, best practices and essential domain knowledge to support continuity planning
- Remain current with higher education analytics trends, technological tools, and institutional reporting standards
- Develop and present reports demonstrating RIO and University benchmarks using sophisticated tables, charts, and graphics to help lay audiences correctly understand the meaning of the analyses
- Work with other data gathering and analysis units within the University, including but not limited to the ORIS Team, Office of Institutional Research, Libraries, Vice Provost for Faculty Affairs, University Services-Space Management, Office of Information Technology, system campuses, and collegiate units
- Participate in University-wide data governance committees, data architecture discussions, and analytics user groups
- Partner with functional units to refine their reporting requirements and translate operational needs into technical specifications
- Manage high-profile external data requests (FOI, press, community, and government) and work with the General Council’s office to determine how the data should be provided
- Creatively address opportunities to help advance research goals of the institution
- Other projects as assigned by supervisor
- Serve as RIO representative and participate in appropriate meetings, conferences, and training
Skills
- Bachelor's degree in Data Analytics, Computer Science, Information Systems, Statistics, Mathematics, higher education quantitative methods, or a related quantitative field, plus at least two years of progressively responsible professional experience in information technology involving data analysis, business intelligence, or reporting analytics; or a master's degree in a related field
- Proficiency in SQL and Excel for querying, cleaning, transforming, and analyzing data; experience with data visualization and business intelligence tools such as Power BI or Tableau and other reporting/analytics software identified as technology stack is updated; and familiarity with cloud data warehouses
- Experience with Python, STATA, or R for statistical analysis and automation
- Experience extracting, transforming, and organizing large data sets from relational database tables from multiple sources
- Experience using quantitative methodology, financial modeling, forecasting, or statistical principles to convert raw datasets into executive-level insights for decision makers
- Experience building and deploying production-level dashboards using major BI platforms
- Experience preparing reports and presenting findings and recommendations clearly and diplomatically, and in a variety of formats to a variety of audiences
- Skilled at evaluating operations holistically to identify key cross-functional relationships across academic, administrative, human resources, and financial domains and programs
- Advanced degree in a relevant field and more than four years experience
- Experience working with data regulated by federal, state, and/or local law, policy or agreement
- Familiarity with University of Minnesota data sources, policies, processes and operations
- Experience working in higher education and/or research institutions
- Strong critical thinking skills, including demonstrated ability to approach problems objectively, draw conclusions, and develop solid recommendations
- Demonstrated ability to work collaboratively and across disciplines with administrators, faculty, and staff from a wide range of programs and backgrounds
- Excellent oral and written communication skills and organizational skills
- Proficiency working with service request ticketing systems
Benefits
- Paid holidays and generous time off
- Continuous learning opportunities through professional training and degree-seeking programs supported by the Regents Tuition Benefit Program
- Low-cost medical, dental, and pharmacy plans
- Healthcare and dependent care flexible spending accounts
- University HSA contributions
- Disability and employer-paid life insurance
- Employee wellbeing program
- Excellent retirement plans with employer contribution
- Public Service Loan Forgiveness (PSLF) opportunity
- Financial counseling services
- Employee Assistance Program with eight sessions of counseling at no cost
- Employee Transit Pass with free or reduced rates in the Twin Cities metro area
- Fully remote work, with required attendance for on-site events and some on-site onboarding
Company Overview