Database Warehouse Analyst jobs in Sandy, UT

Database Warehouse Analyst designs and supports data warehouse systems, maintenance processes, and projects. Designs and writes code for ETL data solutions. Being a Database Warehouse Analyst plans and executes data warehouse implementations following system requirements and anticipated usage. Performs data extraction, ensures data accuracy, troubleshoots, and resolves bugs during data warehouse operations. Additionally, Database Warehouse Analyst analyzes business intelligence data and designs and generates reports. Understands and utilizes ETL tools like Informatica and programming languages like Python. Acts as liaison between information technology and business units. Requires a bachelor's degree. Typically reports to a manager. The Database Warehouse Analyst work is closely managed. Works on projects/matters of limited complexity in a support role. To be a Database Warehouse Analyst typically requires 0-2 years of related experience. (Copyright 2024 Salary.com)

U
Database Analyst
  • University of Utah Healthcare
  • Salt Lake, UT FULL_TIME
  • Details

    Open Date 12/18/2023

    Requisition Number PRN37217B

    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 90400

    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. Salary will be commensurate with experience.

    0 – 2 years of experience: ~60 k

    2\ – 4 years of experience: ~70 k 4 \ years of experience: ~ 80k

    Responsibilities

    • Design and organize a data warehouse for efficiency and scalability

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

    • Database programming work experience with Microsoft SQL Server and

    other database and ETL tools

    • 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.

    Preferences

    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

    • 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 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 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. The University does not discriminate on the basis of sex in the education program or activity that it operates, as required by Title IX and 34 CFR part 106. The requirement not to discriminate in education programs or activities extends to admission and employment. Inquiries about the application of Title IX and its regulations may be referred to the Title IX Coordinator, to the Department of Education, Office for Civil Rights, or both.

    To request a reasonable accommodation for a disability or if you or someone you know has experienced discrimination or sexual misconduct including sexual harassment, you may contact the Director/Title IX Coordinator in the Office of Equal Opportunity and Affirmative Action ( OEO /AA). More information, including the Director/Title IX Coordinator’s office address, electronic mail address, and telephone number can be located at: https://www.utah.edu/nondiscrimination/

    Online reports may be submitted at oeo.utah.edu

    https://safety.utah.edu/safetyreport This report includes statistics about criminal offenses, hate crimes, arrests and referrals for disciplinary action, and Violence Against Women Act offenses. They also provide information about safety and security-related services offered by the University of Utah. A paper copy can be obtained by request at the Department of Public Safety located at 1658 East 500 South.

  • 1 Month Ago

A
Amazon XL Warehouse Associate
  • Amazon Warehouse
  • Salt Lake, UT PART_TIME,OTHER
  • Shift: Flexible Shifts Duration: Seasonal Start Date: 2024-04-10 Amazon XL Warehouse Associate Job Overview You’ll be part of the Amazon warehouse team that handles the big stuff – those unique custom...
  • 3 Days Ago

A
Warehouse Worker - Anytime Pay
  • Amazon Warehouse
  • Salt Lake, UT FULL_TIME
  • Amazon Sortation Center Warehouse Associate Job Overview You’ll be part of the dedicated Amazon team that is the first stop on the journey from the warehouse. Our fast-paced, physical roles take place...
  • 7 Days Ago

A
Warehouse Worker - Anytime Pay
  • Amazon Warehouse
  • West Jordan, UT FULL_TIME
  • Amazon Fulfillment Center Warehouse Associate Job Overview You’ll be part of the Amazon warehouse team that gets orders ready for customers relying on Amazon services. Our fast-paced, physical roles t...
  • 10 Days Ago

A
Amazon Delivery Station Warehouse Associate
  • Amazon Warehouse
  • North Salt Lake, UT FULL_TIME
  • Amazon Delivery Station Warehouse Associate Job Overview You’ll be part of the dedicated Amazon team at the delivery station – the last stop before we deliver smiles to customers. Our fast-paced, phys...
  • 25 Days Ago

A
Amazon Warehouse Worker - Anytime Pay
  • Amazon Warehouse
  • West Jordan, UT FULL_TIME
  • Shift: Sun, Mon, Tue, Wed, Thu 06:30am - 11:30am Duration: PART_TIME Start Date: 2023-06-25 Amazon Delivery Station Warehouse Associate Job Overview You’ll be part of the dedicated Amazon team at the ...
  • 2 Days Ago

Filters

Clear All

Filter Jobs By Location
  • Filter Jobs by companies
  • More

0 Database Warehouse Analyst jobs found in Sandy, UT area

V
REMOTE Workday Developer w/Integration experience - W2 ONLY
  • Vector Talent Resources
  • Salt Lake City, UT
  • ***WE ARE NOT ABLE TO WORK C2C OR C2H ON THIS OPPORTUNITY*** Role Title: Workday Developer w/Integration experience Loca...
  • 3/28/2024 12:00:00 AM

D
Inventory Control Analyst ll - 2nd Shift
  • Duluth Trading Company
  • West Jordan, UT
  • ** Inventory Control Analyst ll - 2nd Shift** **Job Category****:** Distribution, Contact Center, and Operations **Requi...
  • 3/28/2024 12:00:00 AM

B
Inventory Control Analyst II
  • Biomerieux
  • Salt Lake City, UT
  • **Inventory Control Analyst II** Localisation: Salt Lake City, UT, tats-Unis Type de Contrat: Unfixed Term Fonction: Sup...
  • 3/28/2024 12:00:00 AM

C
Data & Analytics Clinical Product Manager
  • Cambia Health Solutions
  • Salt Lake City, UT
  • Data & Analytics Outreach Product Manager Remote within OR, WA, ID or UT Job Description: The Data & Analytics Outreach ...
  • 3/27/2024 12:00:00 AM

S
Business Intelligence Analyst
  • SafeStreets
  • Lehi, UT
  • We are looking for a Business Intelligence Analyst with an emphasis on FP&A to join our team. The ideal candidate will b...
  • 3/27/2024 12:00:00 AM

B
Inventory Control Analyst II
  • bioMrieux Inc.
  • Salt Lake City, UT
  • **Inventory Control Analyst II** Location: Salt Lake City, UT, United States Position Type: Unfixed Term Job Function: S...
  • 3/25/2024 12:00:00 AM

Sandy is a city in Salt Lake County, Utah, United States. The population was 87,461 at the 2010 census, making it the sixth-largest city in Utah. The population is currently estimated to be about 96,145 according to the July 1, 2017 United States Census. Sandy is home to the Shops at South Town shopping mall; the Jordan Commons entertainment, office and dining complex; and the South Towne Exposition Center. It is also the location of the soccer-specific Rio Tinto Stadium, which hosts Real Salt Lake and Utah Royals FC home games, and opened on October 8, 2008. The city is currently developing ...
Source: Wikipedia (as of 04/11/2019). Read more from Wikipedia
Income Estimation for Database Warehouse Analyst jobs
$64,069 to $82,162
Sandy, Utah area prices
were up 2.3% from a year ago