Database and ETL Administrator II
US-AZ
(Attract) Careers
Req #: 82773
Type: Full-Time
|
|
|||||||||||
|
||||||||||||
Overview: Technical Skills: * Advanced understanding of Microsoft SQL Server Enterprise and Microsoft SQL Server Integration Services (SSIS). * Strong expertise in SQL, Python for data processing and analytics. * Experience with ETL development and administration using Microsoft SSIS. * Experience with Google Cloud Platform (GCP) data services such as BigQuery, Cloud Composer, Dataflow, Dataproc and with Apache Airflow. * Experience mapping and ingesting data from databases, files, API calls, and cloud platforms. * Experience optimizing queries in reporting tools such as SQL Server Management Studio and BigQuery. * Ability to analyze and tune ETL/ELT, database and Lakehouse environments for optimal performance and cost efficiency. * Experience in a Healthcare IT or Analytics environment. * Experience with Epic Clarity database and Epic Cogito Data Warehouse. * Advanced understanding of columnar databases, relational database normalization, and Snowflake schema. * Basic knowledge of backups, restores, recovery models, database shrink operations, Clustering, Database mirroring, Replication, implementing operational automation. * Ability to detect and troubleshoot Server related CPU, memory, I/O, disk space and other resource contention, understand complex data models from relational and non-relational data stores. * Strong creative thinking and critical problem-solving skills. Communication: * Effective written & verbal communications skills, strong customer service skills, collaborate with team members and customers and effectively set expectations. * Contribute to technical discussions and present data architecture diagrams and process documents for validation. Time Management: * Self-motivated * Ability to work independently under general guidance Licenses/Certification: Google Professional Data Engineer (Preferred) Microsoft Certified Solutions Associate: SQL Server (Preferred) Epic Cogito Clarity ETL Administrator (Preferred) 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 Qualifications: Education Bachelor's Degree in Computer Science, Information Systems or a related discipline or four (4) years equivalent experience Required Experience 3 years of experience in database or data warehouse, or Lakehouse administration. Required 1 year in a MS SQL Server or Cloud Platform environment. Required 1 year experience developing and maintaining ETL/ELT processes. Required
Share this job:
