Address
Form of work
Salary- BA/BA plus at least 4 years of experience or master’s plus at least 2 years of 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.
- Experience with SAP Business Objects (BO) BI and Webi
Preferred Qualifications:
- Experience working with dimensionally and relationally modeled data.
- Experience working with Oracle RPD OBIEE or similar tools.
- Experience working with Oracle databases.
- Experience working with tools like Toad and SQL Developer.
- Experience working with ETL tools such as SAP Data Services (ETL), SSIS, Data stage.
- Experience working with reporting tools (Crystal Reports and Tableau).
- Experience with Dimensional Modeling.
***Please note, this position is not eligible for H-1B or Green Card sponsorship.
Position Overview:
At the University of Minnesota, University Services, our vision is to provide exceptional and welcoming campuses that are safe and reliable for all who learn, live, work, and visit. Apply today to join our IT team as a Database and System Administrator, where you'll be at the forefront of shaping our enterprise services through effective database infrastructure. As a key player in our cross-functional teams, you'll enjoy the autonomy to craft and evolve diverse environments and architectures with a mix of responsibilities including maintaining systems, embracing new technologies, and managing multiple projects with precision and skill. Our opportunity will allow you to flex both your technical muscles and interpersonal savvy as you bridge the gap between deep technical details and user-friendly communication. We value learning, innovation, and professional growth and are here to support you in your next endeavor.
At the University of Minnesota, University Services, our vision is to provide exceptional and welcoming campuses that are safe and reliable for all who learn, live, work, and visit. The BI ETL Developer will be responsible for designing, building, implementation and maintenance data processing channels for data extraction, transformation, and loading (ETL) to connect large data sets from a variety of sources. The role will develop, maintain, and use infrastructure solutions (e.g., data warehouses, data lakes) including data access APIs that transform data into a usable format enabling users to consume and analyze data more efficiently. The role prepares and manipulates data using tools, languages, data processing frameworks, and databases, providing non-IT professionals access to enterprise information. Ideal candidates will have excellent technical and interpersonal skills as well as a passion for the University’s mission of research, education, and outreach.
Job Responsibilities:
- Create conceptual, logical, and physical data models for various data sets.
- 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.
- Ability to reverse engineer existing ETL code.
- Takes responsibility of etl and BI related migration.
- Administer the SAP BI environment. This will include providing user access, changing/updating passwords, troubleshooting performance issues, being accountable for migrations and software upgrade activities.
Compensation: $105,000 - $120,000 (depends on qualifications)
Work Environment: This is a hybrid position, sharing time between on-site and remote work. On-site expectations are approximately twice per week, but can vary depending on business needs. Hours are generally 8:00 am – 4:30 pm.
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).
