Business Intelligence & Data Analyst (Business Intelligence Developer 2)

Summary
This position serves as a Business Intelligence & Data Analyst (Business Intelligence Developer 2). This role works within our student data team to design, develop, deploy and support reports and data warehouse solutions mainly in our Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Analytics Cloud (OAC) environments. We support data modeling, architecting, ETL development, RPD development, and data analysis to advance our enterprise data warehouse. We will create and support data warehouse subject areas that support the user community in their reporting needs.

Primary Responsibilities:

• Develop data warehouse subject areas.
• Support end users in the use of data warehouse and BI platform.
• Write and validate test scripts.
• Design, document, develop, and test reports.
• Maintain and support existing reports.
• Analyze and interpret data.
• Work with team members and stakeholders to understand business needs and business rules.
• Serve as an ASR developer and partner with the Office of Information Technology (OIT) on enterprise-wide Student projects.

Academic Support Resources supports hybrid and flexible working arrangements. Work arrangements are determined in coordination with supervisors depending on the nature of the unit and position. The arrangement for this position will be determined upon hire between employee and supervisor.

Functions
Data Analysis and Reporting (70%)

• Design, build, test, document, deploy, and maintain operational and strategic reports.
• Support development of business intelligence solutions and underlying student data warehouse subject areas.
• Collaborate with stakeholders to understand business logic and ensure its accurate representation in data analysis.
• Analyze data to identify trends and develop data-driven stories that positively impact student success.
• Communicate data findings and insights to diverse stakeholders and provide strategic business recommendations.
• Create and maintain user documentation and training resources for BI solutions.

Production and Operations Support (20%)

• Contribute to continuous improvements in the data and analytics strategy and processes.
• Engage the student data user community to promote the 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.
• Maintain and support existing reports.

Professional Development (10%)

• 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 to this position as long as the changes and/or additions are consistent with the job classification.

Required Qualifications

• 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.

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

The mission of Academic Support Resources (ASR) is to positively impact students' lives, with a commitment to diversity, equity, and inclusion. ASR values differences and individuality, strengthening its ability to serve the University community. ASR's key units include the Office of Student Finance, Office of Classroom Management, Office of the Registrar, One Stop Student Services, ASR-Information Technology (ASR-IT), and Strategic Initiatives and Operations.

ASR-IT, a unit of 40+ FTE, is the primary IT unit in the Office of Undergraduate Education. This unit supports the University's strategic mission and vision by providing enterprise systems support to the University community. Key business functions include stewardship of critical student finance, financial aid, admissions, student records data, systems, integrated solutions, and processes.

Pay Range: $69,396 - $74,414 annually, depending on education/qualifications/experience

Time Appointment: 100% Appointment

Position Type: Faculty and P&A Staff

Please visit the Office of Human Resources website for more information regarding benefit eligibility.

The University offers a comprehensive benefits package that includes:

• Competitive wages, 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

Applications must be submitted online. To be considered for this position, please click the Apply button and follow the instructions. You will be given the opportunity to complete an online application for the position and attach a cover letter and resume.

Additional documents may be attached after application by accessing your "My Job Applications" page and uploading documents in the "My Cover Letters and Attachments" section.

To request an accommodation during the application process, please e-mail employ@umn.edu or call (612) 624-8647.

The University recognizes and values the importance of diversity and inclusion in enriching the employment experience of its employees and in supporting the academic mission. The University is committed to attracting and retaining employees with varying identities and backgrounds.

The University of Minnesota provides equal access to and opportunity in its programs, facilities, and employment without regard to race, color, creed, religion, national origin, gender, age, marital status, disability, public assistance status, veteran status, sexual orientation, gender identity, or gender expression. To learn more about diversity at the U: http://diversity.umn.edu

Any offer of employment is contingent upon the successful completion of a background check. Our presumption is that prospective employees are eligible to work here. Criminal convictions do not automatically disqualify finalists from employment.

The University of Minnesota, Twin Cities (UMTC)

The University of Minnesota, Twin Cities (UMTC), is among the largest public research universities in the country, offering undergraduate, graduate, and professional students a multitude of opportunities for study and research. Located at the heart of one of the nation's most vibrant, diverse metropolitan communities, students on the campuses in Minneapolis and St. Paul benefit from extensive partnerships with world-renowned health centers, international corporations, government agencies, and arts, nonprofit, and public service organizations.

At the University of Minnesota, we are proud to be recognized by the Star Tribune as a Top Workplace for 2021, as well as by Forbes as Best Employers for Women and one of America's Best Employers (2015, 2018, 2019, 2023), Best Employer for Diversity (2019, 2020), Best Employer for New Grads (2018, 2019), and Best Employer by State (2019, 2022).