University of Utah Jobs

Search for careers

Job Information

University of Utah Database Analyst in Salt Lake City, Utah

Open Date 10/12/2020

Requisition Number PRN24509B

Job Title Database Analyst

Working Title Database Analyst

Job Grade F

FLSA Code Computer Employee

Patient Sensitive Job Code? No

Standard Hours per Week 40

Full Time or Part Time? Full Time

Shift Day

Work Schedule Summary

weekdays

VP Area U of U Health - Academics

Department 00263 - Surgery Research

Location Campus

City Salt Lake City, UT

Type of Recruitment External Posting

Pay Rate Range 47600 to 79699

Close Date

Open Until Filled Yes

Job Summary

Reviews, evaluates, designs, implements and maintains company

database[s]. Identifies data sources, constructs data decomposition

diagrams, provides data flow diagrams and documents the process. Writes

codes for database access, modifications, and constructions including stored

procedures.

Responsibilities

• Design and organize a data warehouse for efficiency and scalability

• Expertly script regular processes using Python, SQL , and R

• Database programming working with Microsoft SQL Server and other

database and ETL tools

• Experience with data mining and statistical analysis tools and

methodologies

• Work collaboratively in a team environment

This job description has been designed to indicate the general nature and

level of work performed by employees within this classification. It is not

designed to contain or be interpreted as a comprehensive inventory of all

duties, responsibilities and qualifications required of employees assigned to

the job.

Comments

Familiar with standard concepts, practices, and procedures within a

particular field. Relies on experience and judgment to plan and accomplish

goals. Performs a variety of tasks. Works under general supervision; typically

reports to a project leader or manager. A certain degree of creativity and latitude is required.

Work Environment and Level of Frequency typically required

Nearly Continuously: Office environment.

Physical Requirements and Level of Frequency that may be required

Nearly Continuously: Sitting, hearing, listening, talking.

Often: Repetitive hand motion (such as typing), walking.

Seldom: Bending, reaching overhead.

Minimum Qualifications

Requires a bachelor’s degree in a related area or equivalency and 2-4 years of experience in the field or in a related area.

Preferences

• A master’s degree is preferred with a focus in Computer Science, Data

Science or a closely related field is required.

• Strong experience in Database Administration in SQL Server

• Ability to detect and trouble shoot SQL Server related CPU , memory, I /O,

disk space and other resource contention

• Strong SQL and stored procedure programming skills

• Experience with data profiling technologies, techniques and approaches for

upfront analysis and production control operations

• Experience as a data architect, ETL engineer or closely related field

preferred

• Experience developing PostgreSQL solutions in an enterprise environment

is preferred

• At least 2 years of experience in dimensional model for data warehousing is

preferred

• Experience processing large amounts of structured and unstructured data

• Excellent oral and written communication skills

• Highly motivated and self-directed.

• Strong planning and time management skills.

• Excellent analytical and problem-solving skills.

• Team player who will enjoy working in a continual learning and growing

atmosphere

• Capacity to effectively present results at conferences and meetings, to stakeholders and peers

Type Benefited Staff

Special Instructions Summary

Additional Information

The University of Utah is an Affirmative Action/Equal Opportunity employer and is committed to diversity in its workforce. In compliance with applicable federal and state laws, University of Utah policy of equal employment opportunity prohibits discrimination on the basis of race or ethnicity, religion, color, national origin, sex, age, sexual orientation, gender identity/expression, veteran’s status, status as a qualified person with a disability, or genetic information. Individuals from historically underrepresented groups, such as minorities, women, qualified persons with disabilities, and protected veterans are strongly encouraged to apply. Veterans’ preference is extended to qualified applicants, upon request and consistent with University policy and Utah state law.

To inquire about this posting, email: employment@utah.edu or call 801-581-2300. Reasonable accommodations in the application process will be provided to qualified individuals with disabilities. To request an accommodation or for further information about University AA/EO policies, please contact the Office of Equal Opportunity and Affirmative Action, 201 S. Presidents Cr., Rm 135, (801) 581-8365 (V/ TDD ), email: oeo@umail.utah.edu .

The University is a participating employer with Utah Retirement Systems (“URS”). Eligible new hires with prior URS service, may elect to enroll in URS if they make the election before they become eligible for retirement (usually the first day of work). Contact Human Resources at (801) 581-7447 for information. Individuals who previously retired and are receiving monthly retirement benefits from URS are subject to URS’ post-retirement rules and restrictions. Please contact Utah Retirement Systems at (801) 366-7770 or (800) 695-4877 or University Human Resource Management at (801) 581-7447 if you have questions regarding the post-retirement rules.

This position may require the successful completion of a criminal background check and/or drug screen.

The University is a participating employer with Utah Retirement Systems (“URS”). Eligible new hires with prior URS service, may elect to enroll in URS if they make the election before they become eligible for retirement (usually the first day of work). Contact Human Resources at (801) 581-7447 for information. Individuals who previously retired and are receiving monthly retirement benefits from URS are subject to URS’ post-retirement rules and restrictions. Please contact Utah Retirement Systems at (801) 366-7770 or (800) 695-4877 or University Human Resource Management at (801) 581-7447 if you have questions regarding the post-retirement rules.This position may require the successful completion of a criminal background check and/or drug screen.

University of Utah logo
University of Utah logo
DirectEmployers