Business Intelligence & Data Analyst

The University of Minnesota in Minneapolis offers a hybrid work arrangement for professionals joining the student data team as a Business Intelligence and Data Analyst. This role centers on building and maintaining reports and data warehouse solutions using OBIEE and Oracle Analytics Cloud, with a focus on data modeling, ETL, and RPD development to translate data analysis into actionable insights that support enterprise reporting for student data.

Responsibilities

• Develop data warehouse subject areas to enable robust business intelligence.
• Support end users in the use of the data warehouse and BI platform.
• Write and validate test scripts to ensure data integrity and report accuracy.
• Design, document, develop, and test reports to meet stakeholder needs.
• Maintain and support existing reports to ensure ongoing reliability.
• Analyze and interpret data to derive meaningful conclusions.
• Collaborate with team members and stakeholders to understand business needs and rules.
• Serve as an ASR developer and coordinate with the Office of Information Technology on enterprise-wide student projects.
• Design, build, test, document, deploy, and maintain operational and strategic reports.
• Support the development of BI solutions and underlying student data warehouse subject areas.
• Work with stakeholders to capture business logic and ensure its accurate representation in data analyses.
• Analyze data to identify trends and develop data-driven narratives that support student success.
• Communicate data findings and insights to diverse stakeholders and provide strategic recommendations.
• Create and maintain user documentation and training resources for BI solutions.
• Contribute to continuous improvements in the data and analytics strategy and processes.
• Engage the student data user community to promote effective use of Student Data Analytics solutions.
• Ensure the availability and quality of data and reports to meet service expectations.
• Assist in the rapid resolution of production issues.
• Develop and maintain subject matter expertise in student data.
• Stay current on data, visualization, and analytics trends, topics, and technologies.
• The employer reserves the right to change or add duties consistent with the job classification.

Requirements

• BA/BS degree with two years of work experience or a master’s degree.
• Understanding of relational databases and programming experience.
• Intermediate SQL proficiency.
• Experience working with complex data sets from multiple sources.

Technologies

• OBIEE (Oracle Business Intelligence Enterprise Edition)
• Oracle Analytics Cloud (OAC)
• SQL
• RPD

Preferred Qualifications

• Ability to engage stakeholders in data analysis and interpretation in meaningful and effective ways.
• Advanced SQL proficiency, including Common Table Expressions (CTEs), window functions, query optimization, and indexing, with a focus on data warehousing principles.
• STAR data modeling experience.
• Demonstrated ability to translate technical data findings into actionable insights for non-technical stakeholders.
• Experience working in higher education.