Developer ETL - Cloud Data Engineer - Level 2 (Cloud Data Engineering)

Location: Durham, North Carolina, United States

Company

hirify.global provides healthcare services and develops enterprise information technology solutions through Duke Health Technology Solutions.

What you will do

• Design, develop, test, execute, monitor, and maintain ETL processes supporting data integration and data warehousing.
• Translate business and technical requirements into data extracts, reports, and other assigned deliverables.
• Perform independent business analysis and develop technical requirements from business requirements.
• Write, modify, optimize, and tune SQL queries, stored procedures, and scripts, including complex cohort inclusion and exclusion criteria.
• Troubleshoot data integrity issues, participate in database QA, and submit requests for new tables and attributes.
• Collaborate with stakeholders, data architects, data engineers, and team members; participate in code reviews, documentation, mentoring, and special projects.

Requirements

• Bachelor's degree in a related field or four years of equivalent technical experience.
• Level 2 requires two years of directly related experience.
• Advanced knowledge of the assigned domain, including relevant data, workflows, and tools.
• Ability to write accurate SQL queries independently more than 90% of the time and optimize SQL queries, stored procedures, and scripts for performance and reliability.
• Ability to locate data elements independently, understand basic data design and infrastructure, and resolve data integrity issues.
• Ability to manage multiple projects to completion with minimal supervision and develop and present assigned topics.
• Basic knowledge of local databases such as Clarity and Caboodle and their underlying tables.
• Ability to work with stakeholders, train Level 1 team members, mentor colleagues on SQL questions and tuning, and communicate request status clearly.

Nice to have

• Certification in development technologies relevant to the position.
• Experience with technologies such as SSIS or Azure Data Factory.

Culture & Benefits

• Work within a healthcare technology organization focused on compassionate care, innovation, collaboration, diversity, excellence, safety, and patient-centered outcomes.
• Participate in the Duke Analytics Community or other professional networking forums.
• Follow DUHS, DHTS, and ACE policies and procedures.
• Equal employment opportunity and reasonable accommodation support are provided.