Developer - BI/Data Warehouse
Salary undisclosed
Apply on
Original
Simplified
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 ways 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 the 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.
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 about 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 extraction 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 the manager
Maintains ongoing communications (timely, clear, concise, and accurate) with a 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 the use of tools and technologies to accomplish job duties
Demonstrates advanced knowledge of the assigned domain/role. Understands data, workflows, and tools related to the 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
Participate 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 competition promptly
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
Meets all Competencies in Level 2 AND:
Demonstrates expertise in systems and software related to the 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 in 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
Demonstrates proficiency with basic ETL procedures and tasks including the use of tools such as SSIS, IWS, Python
Knowledge of and appropriate usage of fundamental statistics (effective communications with statisticians and development of visualization)
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 needs or problem to address independently >95% of the time
Leads Projects with minimal supervision
Change agent about team processes, and workflows when issues/gaps are found
Expert in a given area, both in the data model and the business workflow
Serves as moderator, leader, or channel owner for a forum such as Duke Analytics Community or other professional networking 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 1 - No experience is 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 Affirmative Action/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, sexual orientation, or veteran 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 essentialjob 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.
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 ways 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 the 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.
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 about 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 extraction 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 the manager
Maintains ongoing communications (timely, clear, concise, and accurate) with a 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 the use of tools and technologies to accomplish job duties
Demonstrates advanced knowledge of the assigned domain/role. Understands data, workflows, and tools related to the 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
Participate 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 competition promptly
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
Meets all Competencies in Level 2 AND:
Demonstrates expertise in systems and software related to the 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 in 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
Demonstrates proficiency with basic ETL procedures and tasks including the use of tools such as SSIS, IWS, Python
Knowledge of and appropriate usage of fundamental statistics (effective communications with statisticians and development of visualization)
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 needs or problem to address independently >95% of the time
Leads Projects with minimal supervision
Change agent about team processes, and workflows when issues/gaps are found
Expert in a given area, both in the data model and the business workflow
Serves as moderator, leader, or channel owner for a forum such as Duke Analytics Community or other professional networking 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 1 - No experience is 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 Affirmative Action/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, sexual orientation, or veteran 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 essentialjob 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job Similar Jobs
