Data Warehouse Admin III

Learn more and apply here

Description

 

About UAB Medicine

Located in Birmingham, UAB Medicine is one of the top academic medical centers in the United States and Alabama’s largest single-site employer. In addition to providing health care services for more than 1.6 million patients annually, we are committed to educating medical professionals and advancing medical science through research. UAB Medicine is anchored by UAB Hospital, which has been named one of U.S. News & World Report's Best Hospitals, ranked as America’s No. 1 Best Large Employer in 2021 by Forbes magazine, and among the 150 Top Places to Work in Healthcare by Becker’s Hospital Review, and we received a Top Ten Consumer Choice Award from National Research Corp.

A team of more than 400 professionals, Health System Information Services (HSIS) works to keep UAB Medicine’s IT systems and infrastructure running smoothly to deliver quality care to our patients. Join our nationally ranked team at UAB Medicine, the No. 1 Best Large Employer in 2021 as ranked by Forbes magazine.

UAB Medicine was recognized as a Magnet-designated organization for the fifth consecutive time by the American Nurses Credentialing Center Magnet Recognition Program® and is only the 21st hospital worldwide to receive this designation five consecutive times. UAB Medicine also was designated a Health Care Equality Leader by the Human Rights Campaign Foundation for demonstrating leadership in LGBTQ health care and employment. We offer a competitive benefits package, 100% tuition assistance at UAB, and an exciting atmosphere for starting or growing your career.

Under supervision, to work in the data warehouse environment which includes data design, database architecture, metadata, and repository creation to develop, maintain and support an enterprise data warehouse system and corresponding data sources, including SAP Business Objects and Informatica. To troubleshoot and tune existing data warehouse applications. To assist in creating new or enhanced components of data warehouse. May need to instruct and guide those with less experience.

Key Job Duties/Responsibilities

  • Monitors daily Informatica ETL jobs, checking and resolving errors and assist in identifying and resolving issues
  • Develops IICS Task Flows as needed to assist in the transmission of data throughout UAB Medicine.
  • Provides assistance to end users and programmers regarding data warehouse related problems and issues
  • Monitors Tableau and BusinessObjects server environments to ensure the maximum uptime and performance of the tool sets
  • Adds new users to BI tools according to the EDW security policy to new projects
  • Develops monitoring mechanisms in their responsible environment to prevent unnecessary downtime
  • Acts as team lead for environment upgrades in Tableau, BusinessObjects, and Informatica
  • Effectively communicates pending system changes to user community in a clear and concise manner
  • Monitors scheduled BusinessObjects and Tableau extracts / reports and notifies developers
  • Takes on-call responsibility one week per month or according to the rotation determined by the manager.
  • Performs exhaustive troubleshooting for system related issues.
  • Oversee the promotion of code in the various environments of the UAB Medicine Enterprise Data Warehouse.

Salary range:  $85,600 - $139,100

 

Qualifications

 

Minimum Requirements Bachelor's degree in Information Systems or a related field and six (6) years of related experience required. Work experience may NOT substitute for education requirement.

Preferred Skills

This position is primarily focused on Informatica IICS.  Experience in other systems such as Business Objects, Tableau, and Snowflake are not required, but preferred.  The candidate will be cross trained in tools they are not familiar with. 

  • Experience with Informatica’s IICS, a cloud based ETL tool developing and administering data workflows.  Experience in one or more of the cloud services tools:

      • Mass Ingestion
      • Data Integration
      • API Portal
      • Administrator
  • Experience writing SQL as needed to support the movement of data.
  • Preferred experience administering SAP Business Objects and Tableau Business Intelligence tools in a Windows environment, including user and group security and writing batch scripts as needed.
  • Preferred experience administering Snowflake or Oracle APEX.
  • Preferred experience with skills administering Linux, writing shell scripts, and Git and Jenkins administration.
 

Primary Location

: UAB Health System

Job Category

: Information Technology

Organization

: 702150000 Health System Information Services

Employee Status

: Regular

Job Level

: Mid-Level
Shift: Day/1st Shift
Powered By GrowthZone