"Alerted.org

Must reside in the state of Arizona

$5,000 New Hire Sign-On Bonus!

Overview

Looking to be part of something more meaningful? At HonorHealth, you’ll be part of a team, creating a multi-dimensional care experience for our patients. You’ll have opportunities to make a difference. From our Ambassador Movement to our robust training and development programs, you can select where and how you want to make an impact. HonorHealth offers a diverse benefits portfolio for our full-time and part-time team members designed to help you and your family live your best lives. Visit honorhealth.com/benefits to learn more. Join us. Let’s go beyond expectations and transform healthcare together. HonorHealth is one of Arizona’s largest nonprofit healthcare systems, serving a population of five million people in the greater Phoenix metropolitan area. The comprehensive network encompasses six acute-care hospitals, an extensive medical group with primary, specialty and urgent care services, a cancer care network, outpatient surgery centers, clinical research, medical education, a foundation, an accountable care organization, community services and more. With nearly 17,000 team members, 3,700 affiliated providers and close to 2,000 volunteers dedicated to providing high quality care, HonorHealth strives to go beyond the expectations of a traditional healthcare system to improve the health and well-being of communities across Arizona. Learn more at HonorHealth.com.

Responsibilities

Job Summary

As a member of the Data Management team, the Database & ETL Admin II is responsible for data integration into the organizations reporting databases and enterprise data warehouse. The Database & ETL Admin III develops and maintains Extract Transform Load (ETL) scripts and database objects, and performs scheduling, upgrades, troubleshooting and monitoring of systems. The Database & ETL Admin III assists Business Intelligence (BI) developers in resolving data query and data quality issues, implements metrics to track data quality improvements over time, enhances current processes and systems, and provides guidance, mentoring, and training. The Database & ETL Admin III participates in a support on-call rotation facilitating off-hour work functions in support of incidents, upgrades, patches, and project task fulfillment.

Essential Functions

+ Develops, maintains and monitors ETL processes to integrate data into BI data stores. Administers user access to databases, data warehouse and ETL tools, and maintains environment security. Creates database tables, OLAP Cubes, functions, views, queries, scripting, indexes as necessary for data integration and performance. Ensures proper system monitoring is in place to validate and report the reliability of data loaded to the BI data stores. Creates and maintains documentation representing the current BI database and data warehouse environment specifications and architecture, and develops future-state requirements for each environment.

+ Completes Governance & project job assignments to ensure achievement of established project milestones.

+ Communicates, prioritizes and responds promptly based on severity levels to needs of the customer. Proactively or timely recognizes opportunities for service recovery and acts to resolve issues.

Education

+ Bachelor's Degree - Preferred

+ Associate's Degree or 2 years' work related experience - Required

Experience

+ 1 year in a MS SQL Server environment - Required

+ 1 year experience developing and maintaining Extract Transform Load (ETL) processes - Required

+ 2 years of experience developing ETL processes - Preferred

+ 3 years of experience in database or data warehouse administration - Required

+ 4 years of experience in database or data warehouse administration in a MS SQL Server environment - Preferred

Licenses and Certifications

+ Other Microsoft Certified Solutions Associate: SQL Server - Preferred