Ability to design and develop ETL processes under guidance of senior team members
Ability to execute ETL jobs and monitor their performance
Ability to translate business and technical requirements into assigned deliverables such as data extract or report
Basic knowledge of SQL and relational databases
Follows all policies and procedures set forth by DUHS/DHTS/ACE as pertains to role
Responds to customer requests for assistance as assigned and prioritized by manager
Participates in code review and learning best practices in ETL development
Maintains ongoing communications (timely, clear, concise, and accurate) with manager or business analyst keeping them apprised of request status
Maintains appropriate project documentation as assigned such as GITLAB or data dictionary
Level 2 Work Performed at a minimum
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. Understands data, workflows, and tools related to 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
Level 3 Work Performed at a minimum
Meets all Competencies in Level 2 AND
Demonstrates expertise in systems and software related to project area to accomplish job duties (e.g. SSIS, Azure Data Factory, etc..)
Resolves escalated issues/incidents to ensure high availability and performance of ETL processes
Expert and team resource with SQL development
Expert locating data elements as required. Assists team in locating data elements as needed.
Works with team members to train on advanced skills in using tools and technologies to accomplish job duties
Leads the design and architecture of complex ETL solutions across multiple projects
Defines standards and best practices for ETL development and data integration
Demonstrates ability to work independently to solve problems and complete assigned work >95% of the time
Demonstrates ability to work with customers to understand business need or problem to address independently >95% of the time
Leads Projects with minimal supervision
Change agent with regard to team processes, workflows when issues/gaps are found
Collaborates with data architect and data engineers on design and implementation of data solutions (lakehouse, data warehouse, etc.)
Serves as moderator, leader or channel owner for a forum such as Duke Analytics Community or other professional networking organization
Behaviors/Soft Competencies
Advancement to the level 3 or above requires employee, at a minimum, successfully attain the following:
The following measures can help create a fair and comprehensive evaluation process for promotions, ensuring that the most deserving employees are recognized and given opportunities to advance.
Proven ability to work at the next level: This involves demonstrating the skills and competencies required for the next level of responsibility. Employees should have demonstrated that they can handle tasks and challenges that are typically associated with a higher position.
Potential to serve beyond the next level: This measure looks at the employee's long-term potential and their ability to grow within the organization. The employee should have the vision, ambition, and capability to take on even greater responsibilities in the future.
Consistently demonstrates a values-based approach in how they work: Employees should consistently exhibit behaviors and decision-making processes that align with DUHS values. The exhibited values are integrity, teamwork, diversity excellence and safety. Patient-focused is also critical to success.
Is considered one of the top performers at their level across the organization: This measure evaluates the employee's overall performance and reputation within DHTS. Top performers are often recognized for their exceptional contributions, reliability, and ability to exceed expectations. We will select the best and not the best available.
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 1 - No experience required beyond the minimum education (or equivalency) requirement.
Level 2 - Two years of directly related experience is required.
Level 3 - Four 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. Our collective success depends on the robust exchange of ideas—an exchange that is best when the rich diversity of our perspectives, backgrounds, and experiences flourishes. To achieve this exchange, it is essential that all members of the community feel secure and welcome, that the contributions of all individuals are respected, and that all voices are heard. All members of our community have a responsibility to uphold these values.
Essential Physical Job Functions
Certain jobs at Duke University and Duke University Health System may include essential job functions that require specific physical and/or mental abilities. Additional information and provision for requests for reasonable accommodation will be provided by each hiring department.
Nearest Major Market: Durham
Nearest Secondary Market: Raleigh
Apply now »
Find similar jobs
Opens in a new tab.
Opens in a new tab.
Opens in a new tab.
Read more about Duke’s commitment to affirmative action and nondiscrimination at hr.duke.edu/eeo.
