Developer - Analytics Engineer - Level 2
Duke University14 days ago
Durham, NC, USAMid Level
Responsibilities
- Partner with clinical, operational, business, and quality stakeholders to understand needs and deliver data-driven analytics solutions.
- Design, develop, validate, document, and maintain reports, dashboards, semantic models, data transformations, and governed analytics assets.
- Write and modify SQL queries, including complex inclusion and exclusion criteria for cohort development, and perform basic query performance tuning.
- Develop and support data pipelines, data models, semantic models, and Power BI solutions as part of the Microsoft Fabric transition.
- Translate business requirements into technical, data, and semantic model requirements independently.
- Participate in peer reviews, data quality assurance, documentation, source control, deployment, and ongoing solution support.
- Mentor Level 1 team members and new hires on analytics tools, SQL, and query tuning.
- Manage multiple projects, complete assignments with minimal supervision, and communicate progress, risks, dependencies, and opportunities.
- Present analytics topics and participate in the Duke Analytics Community or other relevant professional forums.
Requirements
- Bachelor’s degree in a related field or four years of equivalent technical experience.
- Two years of directly related experience for Level 2.
- Advanced knowledge of an assigned healthcare analytics domain, including related data, workflows, tools, and semantic models.
- Ability to perform business analysis and translate business requirements independently more than 75% of the time.
- Ability to write and modify accurate SQL queries independently more than 90% of the time, including complex cohort criteria.
- Knowledge of data design and infrastructure, SQL performance tuning, data quality assurance, and semantic modeling.
- Preferred experience in healthcare, clinical operations, quality improvement, patient safety, regulatory reporting, or performance improvement.
- Preferred Epic certification or proficiency with Epic Clarity, Caboodle, Cogito, or other Epic data models.
- Preferred experience with Microsoft Fabric, Power BI, Tableau, ETL/ELT processes, data pipelines, Git, GitLab, Azure DevOps, source control, peer review, or CI/CD deployment practices.
- Preferred certification in Epic Cogito, a Cogito data model, Microsoft Fabric, or another analytics engineering technology.
About Duke University
Duke University is a private research university in Durham, NC, that also operates an academic medical center. Its IT organizations build and run clinical information systems, campus learning platforms, research computing, and enterprise applications for faculty, students, clinicians, and staff. Founded in 1838, Duke is funded by tuition, research grants, healthcare services, and philanthropy, and includes Duke University Health System as an affiliated enterprise.