Business Intelligence & Data Analyst

About the Job This position serves as a Business Intelligence & Data Analyst (Business Intelligence Developer 2). The role works within the student data team to design, develop, deploy, and support reports and data warehouse solutions mainly in Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Analytics Cloud (OAC) environments. We support data modeling, architecting, Extract, Transform & Load (ETL) development, Repository Definition File (RPD) development, and data analysis to advance the enterprise data warehouse. The applicant will create and support data warehouse subject areas that support the user community in their reporting needs. Please note, this position is not eligible for H-1B or Green Card sponsorship. This position does not offer a STEM OPT training program. Primary Responsibilities Develop data warehouse subject areas. Support end users in 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 will be determined in coordination with supervisors. The arrangement for this position will be determined upon hire between employee and supervisor. The University of Minnesota is committed to fostering local talent. While the position utilizes a hybrid work modality, prospective applicants must be located in the state of Minnesota or near the Wisconsin border or otherwise open to relocation. Essential 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 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 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. Its 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 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 depending on education/qualifications/experience Time Appointment: 100% Appointment Position Type: Faculty and P&A Staff Details and benefit eligibility can be found on the Office of Human Resources website. Benefits include 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. 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 View email address on click.appcast.io or call View phone number on click.appcast.io. Diversity 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, visit Employment Requirements 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. About University of Minnesota 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 Forbes as a Best Employer for Company Culture (2026), Best Employer for Women (2023), and Best Employer by State (2022‑2026). In 2026, we also received Culture Excellence & Industry Awards recognition for employee appreciation and work‑life flexibility. #J-18808-Ljbffr