Please note, we are not offering H-1B or Green Card sponsorship for this position. 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. Salary: $76,038 - $85,000 Position Overview:
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. 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 University of Minnesota Twin Cities
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.
Connections working at University of Minnesota Twin Cities
