School of Medicine Established in 1930, Duke University School of Medicine is the youngest of the nation's top medical schools. Ranked sixth among medical schools in the nation, the School takes pride in being an inclusive community of outstanding learners, investigators, clinicians, and staff where interdisciplinary collaboration is embraced and great ideas accelerate translation of fundamental scientific discoveries to improve human health locally and around the globe. Composed of more than 2,500 faculty physicians and researchers, more than 1,300 students, and more than 6,000 staff, the Duke University School of Medicine along with the Duke University School of Nursing, Duke University Health System and the Private Diagnostic Clinic (PDC) comprise Duke Health. a world-class academic medical center. The Health System encompasses Duke University Hospital, Duke Regional Hospital, Duke Raleigh Hospital, Duke Primary Care, Duke Home and Hospice, Duke Health and Wellness, and multiple affiliations.Analyst IT, Sr. (Developer) 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. 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 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: Work with new hires/Level I team members to train on use of tools/technologies to accomplish job 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 is able to 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 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 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 use of tools such as SSIS, IWS, Python Knowledge of and appropriate usage of fundamental statistics (effective communications with statistician and development of visualization) Demonstrate ability to work independently to solve problems, complete 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 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 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. Minimum Qualifications Education Refer to Job Description 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.
