What are the responsibilities and job description for the Data Engineer II (ICP) position at 74 Innovation Care Partners?
Primary City/State: Virtual - Arizona Category: IT Database Administration Shift: Day Department: Information Technology Hybrid Must reside in Arizona 3-days in office: Scottsdale, Arizona Great care starts with great people. (Like you.) At HonorHealth, you’ll find something special. From humble beginnings in 1927 to one of Arizona’s largest nonprofit healthcare systems, our culture is built on warmth and neighborly kindness. Behind every smile is a highly skilled professional with deep expertise and an unwavering dedication to what matters most — caring for the health and well-being of people and communities across the greater Phoenix area. Responsibilities: JOB SUMMARY The Data Engineer II ICP designs, develops, codes, implements, and supports Integration 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. Experience in utilizing data Ingestion, data transformation and data quality tools, leveraging tools such as the Unified Catalog or Microsoft Purview, will be highly valued and differentiated. ESSENTIAL FUNCTIONS 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 lake house/warehouse. Schedule and integrate application/software logs to monitoring application. Implement stored procedures and effectively query the Storage systems (Data Lakehouse/Data Warehouse, 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. support activities related to on call procedures. Maintain current knowledge in new and existing software to ensure productivity, capability, and return on investment. Performs other duties as assigned. EDUCATION Bachelors Computer Science or related field Required Masters Computer Science or related field Preferred EXPERIENCE 2 years, Data Lake House or Enterprise Data Required 2 years, Database development (Python, SQL, PL/SQL, Bash) Required 2 years, Experience Big Data (Data Bricks or Apache Spark or similar) Required 3 years, Data Engineering experience with any integration/ETL tool/Application. Required 1 year, Experience with cloud technologies such as Azure or AWS Preferred 2 years, Healthcare or related experience Preferred LICENSE AND CERTIFICATIONS We're all in for your career. Expert care from experts who care. At HonorHealth, you’ll find something special. Our culture is built on warmth and neighborly kindness, but behind every smile is a highly skilled professional with deep expertise and unwavering dedication. We’re delivering a healthcare experience that simply feels better through: • Nine acute-care hospitals • Over 200 primary, specialty and urgent care centers • More than 17,000 team members and 4,000 medical staff Since 1927, we’ve been focused on doing what matters most — caring for people and communities across the greater Phoenix area. From humble beginnings to one of Arizona’s largest nonprofit healthcare systems, we’re just as driven as we were a century ago. Come join us and go all in for your career. 🔗 Helpful links 💼 Benefits 🖥️ Career site 🤝 Culture 📄 Hiring Process 🏥 Locations 🖥️ HonorHealth.com Join our talent community here! Stay connected with HonorHealth careers: • Get updates on hiring events • Be the first to know about new roles • Connect with our recruiters IMPORTANT: HonorHealth is committed to providing an excellent candidate experience for candidates interested in our job opportunities. We also care about the online safety of our job seekers. Please note the following: HonorHealth employee emails come from HonorHealth (i.e hr@honorhealth.com) not a generic email address, such as gmail or yahoo. If you are suspicious of a job posting, or if you receive any email from an HonorHealth employee that you believe to be fictitious, please contact us EmploymentOffice.HR@HonorHealth.com. HonorHealth does not use Google Hangouts to conduct interviews or conversations. HonorHealth will not ask you to provide any personal information (i.e. drivers license, bank account, credit card information, passwords, social security number) outside of our Applicant Tracking Software before a job offer is extended. If you believe that HonorHealth has violated your civil rights or believe you have experienced discrimination, please click the link to obtain information on your rights to file a complaint. For more information, please click here.