Estimated salary range: $80,000 - $90,000 (depending on qualifications)
Consider a career with the University of Minnesota -- rated as a Star Tribute 2021 top workplace with previous awards from Forbes as one of America's best employers! Within the Office of Information Technology (OIT), we currently seek a Business Intelligence (BI) Developer to support and grow our enterprise data and analytics environment. This position will be focused on creating and maintaining the data models (conceptual, logical and physical) for the University’s enterprise data warehouse and creating associated semantic models providing non-IT professionals access to enterprise information. The BI Developer will serve as a member of one or more development or enhancement teams providing a common business vocabulary, capture data requirements, create integrated designs to meet these requirements, and align those designs with enterprise data strategy. Ideal candidates will have excellent technical and interpersonal skills as well as a passion for the University’s mission of research, education, and outreach.
University paid contribution (10% of your salary) to your retirement account - vested immediately.
22 paid vacation days per year, in addition to sick leave and 11 paid holidays.
Reduced tuition opportunities covering 75% - 100% of eligible tuition.
Excellent and affordable health care benefits.
Wellness program with opportunity to earn lower health care rates.
Free disability insurance.
Annual merit increase program.
Flexible work location options, including hybrid and remote work arrangements.
Create conceptual, logical, and physical data models for our enterprise data warehouse.
Create user semantic layer structures to provide end users with efficient access to transformed data.
Implement data architecture and data governance standards to ensure consistency across subject areas and models.
Perform data analysis activities to capture data requirements clearly, completely, and correctly, and represent them through a logical data model.
Coordinate with clients, data users and key stakeholders to develop and achieve long- term objectives for data architecture and data quality.
Bachelor’s degree and 2 years of relevant work experience or a comparable combination of education, training, and/or experience.
Experience with data modeling and database design (preferably Oracle 19c or compatible versions).
Strong SQL (Structured Query Language) skills.
Experience working with data in an enterprise data and analytics environment.
Ability to work independently or in a group setting.
Strong interpersonal skills with an ability to provide constructive feedback to stakeholders.
Experience working with dimensionally and relationally modeled data.
Experience working with Oracle RPD or similar tools.
Experience with Idera ER Studio or similar tools.
Experience working in an agile (e.g. Scrum) environment.
The University of Minnesota, founded in the belief that all people are enriched by understanding, is dedicated to the advancement of learning and the search for truth; to the sharing of this knowledge through education for a diverse community; and to the application of this knowledge to benefit the people of the state, the nation, and the world.