Developer - Analytics Engineer Department of Pharmacy

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.

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 Health hospitals with 1062 patient beds, it features comprehensive diagnostic and therapeutic facilities, including a regional emergency/trauma center, an endo-surgery center, and more.

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.

• 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.

• 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 Dev Ops (ADO), Git, Git Lab, 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.

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.

• 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…