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.
Qualifications:
- Bachelor's degree in Computer Science, Information Systems or a related discipline or four (4) years equivalent experience
- 3 years of experience in database or data warehouse, or Lakehouse administration
- 1 year in a MS SQL Server or Cloud Platform environment
- 1 year experience developing and maintaining ETL/ELT processes
- Remote, but must reside in Arizona
All IN FOR YOUR CAREER:
- Competitive pay and incentives
- $5,000 sign-on bonus *
- Tuition assistance up to $5,250* per year
- Comprehensive medical, dental and vision insurance with domestic partner coverage
- 403(b) retirement savings plan that provides immediate vesting and dollar-dollar match up to 4%
- On-site child and elder care centers
- Employee assistance program
- Free parking, discounted bus passes, fitness facilities
*terms and conditions apply
To learn more about the opportunity and to apply online visit:
https://jobs.honorhealth.com/jobs/82773?lang=en-us
HonorHealth System Overview:
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 nine 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 approximately 17,000 team members, 4,000+ affiliated providers and over 2,000 volunteers, HonorHealth seamlessly blends collaborative care and approachable expertise to improve health and well-being. People often say care feels different here because it does. Learn more at HonorHealth.com.
Job Type: Full-time
Benefits:
- 401(k)
- Dental insurance
- Employee assistance program
- Employee discount
- Flexible schedule
- Flexible spending account
- Health insurance
- Life insurance
- Paid time off
- Parental leave
- Professional development assistance
- Referral program
- Relocation assistance
- Tuition reimbursement
- Vision insurance
Experience:
- Microsoft SQL Server: 1 year (Required)
- developing ETL processes: 1 year (Required)
- database or data warehouse administration: 3 years (Required)
Location:
Work Location: Remote
