Job description
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 a non-profit, local community healthcare system serving an area of 1.6 million people in the greater Phoenix area. The network encompasses six acute-care hospitals, an extensive medical group, outpatient surgery centers, a cancer care network, clinical research, medical education, a foundation, and community services with approximately 13,100 team members, 3,500 affiliated providers and nearly 700 volunteers. HonorHealth was formed by a merger between Scottsdale Healthcare and John C. Lincoln Health Network. HonorHealth’s mission is to improve the health and well-being of those we serve. Qualifications: Education
Bachelor's Degree Computer Science or related field Required
Experience
3 years experience as an implementor of ETL software (like Talend or Informatica) Required
2 years Data Warehouse Experience Required
2 years Database development (SQL, PL/SQL, MySQL, Oracle) Required
Responsibilities: Job Summary
The Application Systems Data Engineer II designs, develops, codes, implements, and supports ETL processes and Data Warehouse activities. Data Engineer II works closely with the business and translates the requirements into technical specifications to deliver a robust scheduled job to ingest and disseminate the information. Data Engineer II possesses programming skills to develop, customize and manage integration tools, databases, warehouses, and analytical systems. Data Engineer II monitors, troubleshoots and supports the production data pipeline jobs that transfer data to and from the databases. Data Engineer II mentors' other junior members on best practices and design patterns.
- Code, test, and implement integration software to ETL solution. Develop efficient mappings for data extraction/transformation/loading (ETL) from different sources to a target data warehouse. Schedule and integrate application/software logs to monitoring application. Implement stored procedures and effectively query the RDMS (MySQL, Oracle, SQL Server) database.
- Debug and troubleshoot errors and provide required support to the production jobs.
- Produce in-depth documentation of all development, policies and procedures.
- Participate in development planning sessions, weekly team status meetings and create/update appropriate project management documentation as required.
- Available for occasional off-hours emergencies.
- Maintain current knowledge in new and existing software to ensure productivity, capability, and return on investment.
- Performs other duties as assigned.