Campus Pride Jobs

Mobile Campus Pride Logo

Job Information

University of Minnesota - 15th Ave IT Pro 2-Database Design in Minneapolis, Minnesota

Job ID360008 LocationTwin Cities Job FamilyInformation Technology Full/Part TimeFull-Time Regular/TemporaryRegular Job Code9702DD Employee ClassAcad Prof and Admin About the Job This position will be responsible for understanding and maintaining a large number of complex data tables. These tables are the core of the proprietary Laboratory Information Management System (LIMS) to manage and automate VDL operations. The Data Analyst will utilize their extensive knowledge of the LIMS data and database to interface with other IT professionals and lab professionals to aid in VDL daily operations, ranging from testing to billing. This position reports directly to the VMC IT Director, with a dotted reporting line to the VDL Director, and will have significant visibility within VDL and the broader college. Job Responsibilities: Understand data requirements and create / manage an efficient database structure that meets present and future needs. Create data models that define the structure of the database, including tables, relationships, and constraints. Manage and support integrations to other databases and applications. Author and review functional design documents used to communicate business requirements to the technology development team. Build, execute, and support comprehensive test plans. Create and maintain documentation for database structures, configurations, and procedures. Collaborate with other IT professionals, including system administrators, network administrators, and application developers to ensure a smooth and integrated IT environment. Proactively develop relationships and partner with internal stakeholders - scientists, laboratory technicians, veterinarians, administrative staff, and accounting staff. Collaborate with external partners to meet their reporting requirements, develop system messages, and interface with lab equipment. Ensure data integrity in alignment with required database constraints and logic. Qualifications Required Qualifications: BA/BS plus at least two years of work experience in the areas of database design and administration, or master's degree. Experience with data warehousing and manipulation/ETL including PostgreSQL, MS SQL, and/or MySQL. Proficiency in conducting analysis of business processes and recommending improvements or efficiencies. Excellent communication skills with the ability to work as part of a multidisciplinary team. Preferred Qualifications: Ability to write and maintain large SQL packages. Experience with database-related Linux administration Experience with application integration, including third party systems. Experience with integration and reporting tools. Examples include Tableau, XML, SQL, DB2 databases, and familiarity with legacy programming languages. Experience with implementation tools and methodologies. Examples include Agile, prototyping versus formal systems analysis and design, entity relationship diagrams, process flows, and data flows. The University of Minnesota is committed to fostering local talent through employment opportunities. While this position utilizes a hybrid modality, prospective applicants must be located either in the state of Minnesota or near the Wisconsin border or otherwise open to relocation. About the Department The University of Minnesota Veterinary Diagnostic Laboratory (VDL) is a national leader in providing rapid diagnosis of animal diseases, identifying emerging diseases, developing new diagnostic methods, and training diagnosticians and veterinarians. The VDL serves the interests of the livestock and poultry industry, animal research scientists and educators, and companion animal owners and provides support to the state as the official laboratory of the Minnesota Board of Animal Health as well as supporting national animal and human health systems. The laboratory is a part of the University of Minnesota College of Veterinary Medicine and serves as Minnesota's only full service laboratory for animal health diagnostics and surv illance. Benefits Working at the University At the University of Minnesota, you'll find a flexible work environment and supportive colleagues who are interested in lifelong learning. We prioritize work-life balance, allowing you to invest in the future of your career and in your life outside of work. The University also 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 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) Financial counseling services Employee Assistance Program with eight sessions of counseling at no cost with free or reduced rates in the Twin Cities metro area Please visit the for more information regarding benefits. How To Apply 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. 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 at the U: 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 the U of M 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,... For full info follow application link. 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.

DirectEmployers