UAB Medicine Data Warehouse Administrator II – Enterprise

Information Technology Healthcare


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.

Salary Range

$77,640 – $126,170

Job Description

Under supervision, to work in the enterprise 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, Tableau and Informatica (IICS & Power Center).

To troubleshoot and tune existing data warehouse applications. To assist in creating new or enhanced components of data warehouse. The candidate will be working in a collaborative team environment consisting of local and remote employees.

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

Job Requirements

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

Required & Preferred Skills

  • This position is primarily focused on Informatica IICS, which is a required skillset. 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 required with Informatica’s IICS, a cloud based ETL tool developing and administering data workflows. 
  • Experience in one or more of the cloud services tool is required - Mass Ingestion, Data Integration, API Portal, Administrator
  • Experience required 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.

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.

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.

Powered By GrowthZone