"Business Intelligence & Data Analyst (Business Intelligence Developer 2)"

Job Details

About the Job

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.

Qualifications

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

About the Department

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 and Benefits

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

How To Apply

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.