Developer ETL - Cloud Data Engineer - Level 2

Developer ETL
- Cloud Data Engineer
- Level 2

Work Arrangement:
Regular

Location:

Durham, NC, US, 27710 Personnel Area: HEALTH SYSTEM

At Duke Health, we're driven by a commitment to compassionate care that changes the lives of patients, their loved ones, and the greater community. Join us and discover how we can advance health together.

About Duke Health Technology Solutions Pursue your passion for caring and innovation with Duke Heath Technology Solutions, which is dedicated to the transformation, development, and management of enterprise information technology solutions across Duke Health. By harnessing the power of innovative technologies like cloud computing and artificial intelligence — and pairing them with a forward-thinking approach — Duke Health Technology Solutions is revolutionizing the future of health care at Duke Health and beyond.

The ETL Developer will be responsible for designing, developing, testing, and maintaining ETL processes to support data integration and data warehousing needs within the organization. This role requires a deep understanding of ETL best practices, strong analytical and problem-solving skills, and the ability to work collaboratively in a fast-paced environment.

Meets all competencies in Level 1 AND:

• Works with new hires/Level I team members to train on use of tools and technologies to accomplish job duties
• Demonstrates advanced knowledge of the assigned domain/role
• Demonstrates ability to work with stakeholders to understand business needs and perform business analysis independently >75% of the time
• Develop technical requirements from business requirements independently >75% of the time
• Can write/modify accurate SQL queries independently > 90% of the time
• Ability to optimize SQL queries, stored procedures and scripts for performance reliability
• Can write complex SQL inclusion/exclusion criteria for cohort development
• Ability to troubleshoot and resolve data integrity issues
• Mentors team members with SQL questions/tuning
• Ability to locate data elements independently > 75% of the time
• Knowledge/utilization of basic data design and infrastructure
• Participates in team code review
• Actively participates/contributes to database QA/submit requests for new database tables/attributes
• Actively seeks out participation in Special Projects and is able to effectively accomplish project assignments with minimal supervision
• Ability to manage multiple projects to completion in a timely manor
• Ability to develop and present topics as assigned/needed by customer and/or ACE team
• Active participation in Duke Analytic Community or other networking forums applicable to job functions

Advancement to the level 3 or above requires employee, at a minimum, successfully attain the following:

• Proven ability to work at the next level
• Potential to serve beyond the next level
• Consistently demonstrates a values-based approach in how they work
• Is considered one of the top performers at their level across the organization

Required Qualifications at this Level Education/Training Bachelor's degree in a related field, or four years of equivalent technical experience required. LICENSURE/CERTIFICATION:
None required. Preferred certification in development technologies, as appropriate for the position. Experience Level 2 - Two years of directly related experience is required.

Duke is an Equal Opportunity Employer committed to providing employment opportunity without regard to an individual's age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex (including pregnancy and pregnancy related conditions), sexual orientation or military status. Duke aspires to create a community built on collaboration, innovation, creativity, and belonging.