The Analytics Engineer serves as a trusted analytics partner to Nursing and Case Management leadership, supporting operational, quality, patient safety, and performance improvement initiatives through the development of reporting, analytics, and decision support solutions. This role requires strong business partnership skills, technical expertise, and the ability to translate complex data into actionable insights that drive operational excellence and improve patient outcomes.
Key Responsibilities:- Partner closely with Nursing and Case Management leaders to understand business needs, prioritize initiatives, and develop data-driven solutions that support strategic and operational objectives.
- Serve as a trusted advisor by proactively communicating project progress, risks, dependencies, and opportunities to stakeholders.
- Design, develop, validate, document, and maintain reporting and analytics solutions that deliver accurate, timely, and actionable information.
- Own recurring reporting processes, ensuring data integrity, consistency, thorough documentation, and reliable delivery of performance metrics and scorecards.
- Translate complex data and analytical findings into clear, meaningful insights for audiences ranging from frontline operational teams to senior executive leadership.
- Support quality improvement, operational excellence, and performance improvement initiatives through project participation, analytical consultation, and data-driven recommendations.
- Collaborate with multidisciplinary teams to identify opportunities for improved data collection, reporting efficiency, and operational performance.
Work PerformedLevel 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 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)
- 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
- 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 LevelEducation/TrainingBachelor'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.
ExperienceLevel 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.
Preferred Qualifications:- Experience working in a healthcare environment with an understanding of clinical, nursing, case management, quality, and patient safety operations.
- Experience with Epic Clarity and/or Caboodle data models.
- Experience with Microsoft Fabric, Power BI, and Tableau.
- Strong SQL development, data modeling, and analytical problem-solving skills.
Work Location Requirement:- This is a hybrid position that requires a minimum of two days per week onsite to support collaboration with Nursing and Case Management leadership.
