Database and ETL Administrator II

1 week ago

Phoenix, AZ, United States HonorHealth Full time

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

  • Database/Web Administrator

    2 weeks ago

    Phoenix, AZ, United States Inficare Full time

    Role: Database/Web Administrator Location: Phoenix AZ Duration: Long term contract Skills: Data Analytics, ETL - Big Data/Data Warehouse, MS SQL, Python, SQL This role needs to oversee a data lake utilizing a Microsoft SQL Server. They will be responsible for creating queries to integrate a multitude of data sources on a regular basis, working with large...

  • Database/Web Administrator

    1 week ago

    Phoenix, AZ, United States Inficare Full time

    Role: Database/Web Administrator Location: Phoenix AZ Duration: Long term contract Skills: Data Analytics, ETL - Big Data/Data Warehouse, MS SQL, Python, SQL This role needs to oversee a data lake utilizing a Microsoft SQL Server. They will be responsible for creating queries to integrate a multitude of data sources on a regular basis, working with large...

  • Application Database Administrator

    4 days ago

    Phoenix, AZ, United States Computer Task Group Full time

    CTG is seeking to fill an Application Database Administrator - RDBMS position for our client in Phoenix, AZ.Duration: 12 months Duties: Manage, maintain, and optimize enterprise databases (Oracle, MS SQL Server, DB2, Teradata). Ensure high availability, performance tuning, and disaster recovery. Support ETL, data warehousing, and Big Data initiatives....

  • Senior Database Administrator

    2 weeks ago

    Phoenix, AZ, United States Verra Mobility Full time

    Who we are... Verra Mobility is a global leader in smart mobility. We develop technology-enabled solutions that help the world move safely and easily. We are fostering the development of safe cities, working with police departments and municipalities to install over 4,000 red-light, speed, and school bus stop arm safety cameras across North America. We are...

  • Senior Database Administrator

    4 days ago

    Phoenix, AZ, United States Verra Mobility Full time

    Who we are... Verra Mobility is a global leader in smart mobility. We develop technology-enabled solutions that help the world move safely and easily. We are fostering the development of safe cities, working with police departments and municipalities to install over 4,000 red-light, speed, and school bus stop arm safety cameras across North America. We are...

  • Senior Database Administrator

    1 week ago

    Phoenix, AZ, United States Verra Mobility Full time

    Who we are... Verra Mobility is a global leader in smart mobility. We develop technology-enabled solutions that help the world move safely and easily. We are fostering the development of safe cities, working with police departments and municipalities to install over 4,000 red-light, speed, and school bus stop arm safety cameras across North America. We are...

  • Sr Database Administrator

    1 week ago

    Phoenix, AZ, United States Fusion HCR Full time

    Fusion HCR | Job Description Position: Senior Database Administrator (DBA) Location: Hybrid - Candidate must reside in one of the following hub locations: Seattle, WA; Boston, MA; Phoenix, AZ; or San Francisco, CA The Senior Database Administrator (DBA) will play a critical role in building the foundation for the client's future data strategy. This is not...

  • Administrative Assistant II

    1 day ago

    Phoenix, AZ, United States ADVANCED DECISION VECTORS, LLC Full time

    Administrative Assistant II ADV is seeking an Administrative Assistant II in Phoenix, Arizona to provide comprehensive administrative and clerical support to the Federal Protective Service (FPS) Region 9. This position supports FPS leadership under the FPS Administrative Support Services contract, assisting with scheduling, correspondence, document and data...

  • Administrative Assistant II

    1 day ago

    Phoenix, AZ, United States ADVANCED DECISION VECTORS, LLC Full time

    Administrative Assistant II ADV is seeking an Administrative Assistant II in Phoenix, Arizona to provide comprehensive administrative and clerical support to the Federal Protective Service (FPS) Region 9. This position supports FPS leadership under the FPS Administrative Support Services contract, assisting with scheduling, correspondence, document and data...

  • Administrative Assistant II

    2 days ago

    Phoenix, AZ, United States ADVANCED DECISION VECTORS, LLC Full time

    Administrative Assistant II ADV is seeking an Administrative Assistant II in Phoenix, Arizona to provide comprehensive administrative and clerical support to the Federal Protective Service (FPS) Region 9. This position supports FPS leadership under the FPS Administrative Support Services contract, assisting with scheduling, correspondence, document and data...