<p><meta charset="utf-8" /></p><p>Consider an opportunity to join the Office of Information Technology (OIT), the central IT unit at the University of Minnesota. Our organization values its employees and invests time and resources into staff through certifications, training, conferences and other professional development opportunities. We offer work-life balance and an environment of collaboration and open communication across leadership, teammates, and customers. We seek an experienced Data Modeler/Architect who will have a commitment to investing themselves in the work, creating strong professional relationships, and promoting a respectful, inclusive and collaborative climate.</p><p>This position will support and grow our enterprise data management environment within a matrix organization. The individual in this role will be primarily focused on creating conceptual and logical models as well as serving as a team lead to other modelers in support of our application integration and data warehousing needs. This position will also work with our growing real-time integration platforms.</p><p><em>We Offer:</em></p><ul><li>University paid contribution (10% of your salary) to your retirement account - vested immediately.</li><li>22 paid vacation days per year, in addition to sick leave and 11 paid holidays.</li><li>Reduced tuition opportunities covering 75% - 100% of eligible tuition.</li><li>Excellent and affordable health care benefits.</li><li>Wellness program with opportunity to earn lower health care rates.</li><li>Free disability insurance.</li><li>Annual merit increase program.</li></ul><p><em>Job Responsibilities: </em></p><p>Data Modeling</p><ul><li>Create conceptual, logical, and physical data models.</li><li>Analyze information flow and recommend appropriate technological solutions.</li><li>Perform data analysis activities to capture data requirements.</li><li>Ensure that ETL design and development efforts support business rules.</li><li>Perform physical database design tasks (e.g. performance tuning).</li><li>Administer our ER Studio environment. </li></ul><p>Leadership & Consultation</p><ul><li>Create and maintain data modeling, design and implementation standards.</li><li>Lead modeling team meetings.</li><li>Work with the Enterprise Data Architect and governance groups to develop standards for the naming, description, governance, management, modeling, storing, cleansing, and transformation of data within the enterprise.</li><li>Provide procedural and technical guidance to teammates.</li><li>Coordinate with clients, data users and key stakeholders to develop and achieve long term objectives for data architecture and data quality.</li></ul>
<p><em>Required:</em></p><ul><li>Bachelor’s degree in a related field and 4 or more years of hands on data modeling experience in an enterprise environment or a comparable combination of education, experience, and/or training.</li><li>Strong SQL (Structured Query Language) and data extraction skills.</li><li>Experience designing dimensional models.</li><li>Experience optimizing physical designs for effective ETL and maximum query performance. Experience with ETL best practices.</li><li>Ability to work independently or in a group setting.</li><li>Strong interpersonal skills with an ability to provide feedback and consultation to leadership.</li></ul><p><em>Preferred:</em></p><ul><li>Experience with ER Studio.</li><li>Experience with PeopleSoft.</li><li>Experience with Oracle 12 database design and implementation.</li><li>Experience working in an agile (e.g. Scrum) environment.</li></ul>
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.