University of Utah
Database Analyst
University of Utah, Salt Lake City, Utah, United States, 84193
Hybrid work is possible, but some on-site work is required. Thus, residence within Salt Lake valley/area is also required.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.Applicants must demonstrate the potential ability to perform the essential functions of the job as outlined in the position description.Huntsman Cancer Institute is committed to cancer prevention, care, and survivorship for all communities within the area we serve – which includes Idaho, Montana, Nevada, Utah, and Wyoming – with impact worldwide.In your cover letter or during your interview process, we invite you to share how your professional experiences have prepared you to serve as a member of our team as we work to reduce the cancer burden experienced by all people and communities. This may include description of your prior experiences related to research, prevention, clinical care, community engagement/outreach, training, administration, or other areas relevant to Huntsman Cancer Institute’s mission and this position.Responsibilities
Disclaimer:
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.Minimum Qualifications
Requires a bachelor’s degree in a related area or equivalency (one year of education can be substituted for two years of related work experience) and 2-4 years of experience in the field or in a related area.Preferences
Experience in a relational database environment, with proven knowledge of SQL statement syntax, functions, and procedures.A major focus of this position will be loading large, statewide datasets (close to 1 billion records) into the Utah Population Database architecture. Familiarity with loading large data sets preferred.Knowledge of SQL utilities used to import data files.Experience using SQL stored procedures to profile, transform, and load records into a database.Ability to modify SQL stored procedures to match current record sets.Experience with Microsoft SQL Server preferred.Expected to communicate with data providers to coordinate data delivery and quality assurance.Additional Information
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.This position may require the successful completion of a criminal background check and/or drug screen.The University of Utah values candidates who have experience working in settings with students and patients from all backgrounds and possess a strong commitment to improving access to higher education and quality healthcare for historically underrepresented students and patients.All qualified individuals are strongly encouraged to apply. Veterans’ preference is extended to qualified applicants, upon request and consistent with University policy and Utah state law. Upon request, reasonable accommodations in the application process will be provided to individuals with disabilities.The University of Utah is an Affirmative Action/Equal Opportunity employer and does not discriminate based upon race, ethnicity, color, religion, national origin, age, disability, sex, sexual orientation, gender, gender identity, gender expression, pregnancy, pregnancy-related conditions, genetic information, or protected veteran’s status.Posting Specific Questions
Required fields are indicated with an asterisk (*).* Do you have a related Bachelor's degree or equivalency? (2 years related work experience may be substituted for 1 year of education)
YesNo
* How many years of database related work experience do you have?
Less than 1 year1 year or more, but less than 2 years2 years or more, but less than 4 years4 years or more, but less than 6 years6 years or more
Will you now or in the future require sponsorship for employment visa status (e.g., H-1B status)?
YesNo
Are you legally authorized to work in the United States?
YesNo
Required Documents
ResumeOptional Documents
Cover LetterAppropriate discharge document (such as a DD-214 – Member Copy 4) – Veteran Only – Call 801.581.2169Addendum to the University of Utah - Veteran Only - Call 801.581.2169 after submissionUniversity Human Resource Management250 East 200 South, Suite 125 Salt Lake City, UT 84111Contact us: (801) 581-2169 By Email: employment@utah.edu
#J-18808-Ljbffr
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.Applicants must demonstrate the potential ability to perform the essential functions of the job as outlined in the position description.Huntsman Cancer Institute is committed to cancer prevention, care, and survivorship for all communities within the area we serve – which includes Idaho, Montana, Nevada, Utah, and Wyoming – with impact worldwide.In your cover letter or during your interview process, we invite you to share how your professional experiences have prepared you to serve as a member of our team as we work to reduce the cancer burden experienced by all people and communities. This may include description of your prior experiences related to research, prevention, clinical care, community engagement/outreach, training, administration, or other areas relevant to Huntsman Cancer Institute’s mission and this position.Responsibilities
Disclaimer:
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.Minimum Qualifications
Requires a bachelor’s degree in a related area or equivalency (one year of education can be substituted for two years of related work experience) and 2-4 years of experience in the field or in a related area.Preferences
Experience in a relational database environment, with proven knowledge of SQL statement syntax, functions, and procedures.A major focus of this position will be loading large, statewide datasets (close to 1 billion records) into the Utah Population Database architecture. Familiarity with loading large data sets preferred.Knowledge of SQL utilities used to import data files.Experience using SQL stored procedures to profile, transform, and load records into a database.Ability to modify SQL stored procedures to match current record sets.Experience with Microsoft SQL Server preferred.Expected to communicate with data providers to coordinate data delivery and quality assurance.Additional Information
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.This position may require the successful completion of a criminal background check and/or drug screen.The University of Utah values candidates who have experience working in settings with students and patients from all backgrounds and possess a strong commitment to improving access to higher education and quality healthcare for historically underrepresented students and patients.All qualified individuals are strongly encouraged to apply. Veterans’ preference is extended to qualified applicants, upon request and consistent with University policy and Utah state law. Upon request, reasonable accommodations in the application process will be provided to individuals with disabilities.The University of Utah is an Affirmative Action/Equal Opportunity employer and does not discriminate based upon race, ethnicity, color, religion, national origin, age, disability, sex, sexual orientation, gender, gender identity, gender expression, pregnancy, pregnancy-related conditions, genetic information, or protected veteran’s status.Posting Specific Questions
Required fields are indicated with an asterisk (*).* Do you have a related Bachelor's degree or equivalency? (2 years related work experience may be substituted for 1 year of education)
YesNo
* How many years of database related work experience do you have?
Less than 1 year1 year or more, but less than 2 years2 years or more, but less than 4 years4 years or more, but less than 6 years6 years or more
Will you now or in the future require sponsorship for employment visa status (e.g., H-1B status)?
YesNo
Are you legally authorized to work in the United States?
YesNo
Required Documents
ResumeOptional Documents
Cover LetterAppropriate discharge document (such as a DD-214 – Member Copy 4) – Veteran Only – Call 801.581.2169Addendum to the University of Utah - Veteran Only - Call 801.581.2169 after submissionUniversity Human Resource Management250 East 200 South, Suite 125 Salt Lake City, UT 84111Contact us: (801) 581-2169 By Email: employment@utah.edu
#J-18808-Ljbffr