Job Listing
|
|
| Job ID: 13970797 |
|
| |
| Job Location: |
|
| |
|
|
| |
| How to Apply: | To see employer contact information, log in or register. |
| |
| Job Title: | IT Pro 2-Database Design |
| Work Type: | Work Days: Work Vary: Yes , Shift: Other, Hours Per Week: 40, Work Type: Regular |
| |
| Salary Offered: | Unspecified |
| Benefits: | Unspecified. |
| |
| Physical Required: | Unspecified |
| Drug Testing Required: | Unspecified |
| Education Required: | Bachelor's Degree |
| |
| Experience Required: | Unspecified |
| |
| Required Skills: | Please see the job description for information about required job skills. |
| Preferred Skills: |
|
| |
| |
| |
|
| Job Description: |
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 surveillance.
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.
Refer to ID 78570774 when applying |
|