BI/Data Warehouse Developer

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. No matter where your talents lie, 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

Primary Role 

The Developer functions as a data and reporting expert for the Duke Health System to understand the data needs and to provide expert consultation on available tools, design options, and relevant data elements.   Brainstorm with functional teams and recommend optimal way to collect, store, retrieve and analyze the data.  Able to translate business requirements, write SQL code and identify appropriate reporting tools. This person will be involved in selection, manipulation, integration and analysis of data from variety of data sources. 

The Developer builds and maintains custom data sets by translating data requirements into workable programming code. The Developer is involved in all aspects of the data development lifecycle, including designing, building, testing, implementing and supporting applications using programming languages and development tools, including automation tools such as Power BI or Tableau. 

Clarity/Caboodle epic Certification/Proficiency data model preferred. Health experience preferred. 

Work Performed 
Level 1
 
•    Individual contributor works under the direct supervision of level 3 or above and collaborates as a member of a team 
•    Basic understanding of local databases (Clarity; Caboodle) and underlying tables pertaining to role/domain
•    Basic understanding of analytical/BI technologies and terminology related to role
•    Ability to transform data into meaningful deliverables using reporting/visualization tools
•    Ability to translate business and technical requirements into assigned deliverables such as data extract or report
•    Basic knowledge of SQL query debugging
•    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 
•    Maintains ongoing communications (timely, clear, concise, and accurate) with manager or business analyst keeping them apprised of request status 
•    Maintains appropriate DWD project documentation as assigned such as GITLAB or data dictionary

Level 2

•    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
•    Basic knowledge of SQL query performance tuning
•    Can write complex SQL inclusion/exclusion criteria for cohort development
•    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 can effectively accomplish project assignments with minimal supervision 
•    Ability to manage multiple projects to competition 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
•    Performs other duties as assigned

Level 3

•    Meets all Competencies in Level 2 AND:
•    Demonstrates expertise in systems and software related to project area to accomplish job duties (e.g. Tableau with multiple data sources or environments, Caboodle development, advanced RW SQL, etc, UNIX, OMOP, PCORnet, UNOS...)   
•    Expert and team resource with SQL development
•    Expert locating data elements as