Developer - Analytics Engineer Department of Pharmacy

Work Arrangement:

Requisition Number: 274981

Regular or Temporary: Regular

Location:

Durham, NC, US, 27710

Personnel Area: DUKE HOSPITAL

Date: Sep 17, 2026

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 University Hospital

Pursue your passion for caring with Duke University Hospital in Durham, North Carolina, which is consistently ranked among the best in the United States. The largest of the four Duke Healthhospitals with 1062 patient beds, it features comprehensive diagnostic and therapeutic facilities, including a regional emergency/trauma center, an endo-surgery center, and more.

Analytics Engineer (Department of Pharmacy)

The Analytics Engineer serves as a trusted analytics partner to Department of Pharmacy leadership, supporting medication use, pharmacy operations, quality, patient safety, regulatory reporting, 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 healthcare data into actionable insights that drive operational excellence, improve patient outcomes, and support informed decision making.

Key Responsibilities:

Partner closely with Pharmacy leadership and subject matter experts 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, semantic modeling, and analytics solutions that deliver accurate, timely, and actionable information.
Develop and maintain SQL queries, data transformations, and governed analytics assets that support pharmacy operations, quality initiatives, and regulatory reporting.
Translate complex data and analytical findings into clear, meaningful insights for audiences ranging from frontline operational teams to senior executive leadership.
Support quality improvement, patient safety, medication stewardship, and operational excellence initiatives through project participation, analytical consultation, and data-driven recommendations.
Collaborate with multidisciplinary teams to identify opportunities for improved data collection, reporting efficiency, data quality, and operational performance.
Participate in analytics engineering best practices, including documentation, source control, peer review, testing, and deployment processes.

Preferred Qualifications:

Experience working in a healthcare environment with an understanding of clinical operations, pharmacy workflows, quality improvement, patient safety, and healthcare regulatory reporting.
Epic certification or demonstrated proficiency with Epic Clarity, Caboodle, Cogito, or other Epic clinical and operational data models.
Experience with Microsoft Fabric, including semantic models, Power BI, Lakehouse, Data Warehouse, Dataflows, Pipelines, or related analytics capabilities.
Experience developing Power BI and Tableau dashboards, scorecards, reports, and self-service analytics solutions.
Experience with Azure DevOps (ADO), Git, GitLab, source control, and CI/CD deployment practices.
Strong SQL development, dimensional modeling, semantic modeling, and analytical problem-solving skills.
Experience developing ETL/ELT processes, data pipelines, or other modern data engineering solutions.

Work Location Requirement:

This position offers a flexible hybrid work arrangement. While routine onsite presence is not required, candidates should expect periodic onsite attendance to support collaboration, relationship building, requirements gathering, project work, and stakeholder engagement with Department of Pharmacy leadership and staff. The frequency of onsite participation will vary based on business needs, project activities, and customer engagement requirements.

Level 1 Work Performed at a minimum

	Individual contributor works under the direct supervision of level 3 or above and collaborates as a member of a team
	Basic understanding of core data platforms (Clarity, Caboodle) and underlying data structures pertaining to role/domain
	Basic understanding of analytics and BI technologies and terminology related to role
	Ability to transform data into meaningful deliverables using analytics and BI tools
	Ability to translate business and technical requirements into assigned deliverables such as data extracts or reports
	Basic knowledge of SQL query debugging
	Follows all policies and procedures set forth by DUHS/DHTS/ACE as they pertain to the 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 analytics engineering documentation and metadata, such as GitLab artifacts or data dictionaries, as assigned

Level 2 Work Performed at a minimum Meets all Competencies in Level 1 AND:
Works with new hires/Level 1 team members to train on use of tools and technologies to accomplish job duties
Demonstrates advanced knowledge of the assigned domain, including related data, workflows, tools, and semantic models.
Demonstrates ability to work with stakeholders to understand business needs and perform business analysis independently >75% of the time.
Translates business requirements into technical, data, and semantic model 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 peer review of SQL, data transformations, and semantic model design
Actively participates in data quality assurance and submits requests for new or enhanced data structures, tables, and 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 manner
Ability to develop and present topics as assigned/needed by customer and/or ACE team
Active participation in Duke Analytics 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 analytics engineering platforms, data models, and tools related to the project area to accomplish job duties (e.g. Microsoft Fabric, Tableau or Power BI with multiple data sources or environments, semantic model development, Caboodle, advanced RW SQL, UNIX, OMOP, PCORnet, UNOS...)
Expert and team resource in SQL, data modeling, and semantic modeling
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 ETL processes, data pipelines, transformation workflows, and source control/deployment practices, including use of tools such as SSIS, ADF, SQL Server Agent, Python, GitLab, and CI/CD
Knowledge of and appropriate use of fundamental statistics to support data interpretation, stakeholder communication, and effective visualization design
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
Serves as a change agent for team processes and workflows when issues or gaps are identified
Expert in a given area, including the data and semantic 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 analytics engineering 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. Prior experience with Microsoft Fabric, GitLab, and CI/CD practices is preferred.

Level 3 - Four years of directly related experience is required. Prior experience with Microsoft Fabric, GitLab, and CI/CD practices is preferred.

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.