Business Intelligence and Data Analyst

*Please note, we are not offering H-1B or Green Card sponsorship for this position. This position does not offer a STEM OPT training program.

The Business Intelligence and Data Analyst plays a crucial role in leveraging data to drive informed business decisions and optimize performance. This position involves extracting, analyzing, and interpreting large datasets to provide actionable insights, contributing to strategic planning and decision-making processes across the organization. This individual will be a key contributor in transforming raw data into meaningful intelligence, helping departments understand trends, identify opportunities, and mitigate risks.

In the College of Continuing and Professional Studies (CCAPS) you'll find a flexible, hybrid work environment and supportive colleagues who are committed to empowering lifelong learners to achieve their educational goals in a learner-centric environment where diverse ideas, backgrounds, and identities are embraced.

• Analyze and interpret complex data sets to identify trends, patterns, and insights.
• Develop and maintain reports, dashboards, and visualizations for key stakeholders.
• Collaborate with cross-functional teams to understand business requirements and translate them into analytical solutions.
• Design and implement business intelligence solutions using tools such as Tableau, Power BI, or similar platforms.
• Develop and optimize ETL (Extract, Transform, Load) processes for efficient data retrieval and transformation.
• Ensure data accuracy, consistency, and reliability in business intelligence solutions.

• Design and implement database structures based on business requirements.
• Develop efficient SQL queries, stored procedures, and triggers.
• Ensure data integrity, security, and availability.
• Monitor database performance, conduct regular maintenance, and optimize for efficiency.
• Implement backup and recovery plans to safeguard data.
• Install, configure, and upgrade database software and related tools.

• Manage virtual servers used for hosting the results of the data analysis and business intelligence solutions developed.
• Manage virtual servers used to run extract, transfer and load (ETL) operations that move data between systems.
• Manage other college servers as needed for things like website hosting and file storage.

• Stay current with industry trends and emerging technologies.
• Identify opportunities for process improvement and recommend system enhancements to drive efficiency and productivity.

*Please Document qualifications on resume*

1. BA/BS in relevant fields and at least four years of experience, OR master's degree and at least two years of experience.
2. Demonstrated ability to write complex SQL queries for data extraction, transformation, and analysis.
3. Hands-on experience building dashboards and reports in Tableau, Power BI, or Qlik.
4. Demonstrated experience using Python or R for data analysis, statistical modeling, and automation.
5. Familiarity with data warehousing concepts, dimensional modeling, and experience working with data warehouses (e.g., Snowflake, Amazon Redshift, Google BigQuery).
6. Proven experience using Microsoft Excel for data analysis, pivot tables, and charting.
7. Experience installing, configuring, administering Microsoft SQL Server and Microsoft SQL Server Reporting Services on Windows Server.

1. Proven experience (3+ years) in a Business Intelligence, Data Analyst, or similar role, demonstrating a strong track record of delivering actionable insights from complex datasets.
2. Experience creating data visualization workbooks and data sources using Tableau Desktop and Tableau Server.
3. Familiarity with basic server administration tasks in Linux and Windows environments.
4. Exceptional analytical and problem-solving skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
5. Experience designing and building desktop applications using Microsoft Access, Filemaker, Microsoft SQL Server, or similar platforms.
6. Experience using Git or GitHub for version control of scripts, queries, or analytics projects.

CCAPS has a large and diverse portfolio of program offerings, including bachelor's and master's degrees, professional development offerings for practitioners, pre-college programs for high school students, English language programs, and lifelong learning for personal enrichment. Across all the work done in and by CCAPS, we strive daily to live our core values of Access, Learning, Inclusivity, Collaboration, and Excellence.

Pay Range: $90,000-$100,000; depending on education/qualifications/experience

Time Appointment Category: 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.

For Priority consideration, please submit your application materials and resume by Friday, 7/25/2025

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