Key Responsibilities
Partner with clinical, operational, and business stakeholders to understand needs, establish priorities, and develop data-driven solutions supporting strategic and operational objectives.
Serve as a trusted analytics advisor by proactively communicating project progress, risks, dependencies, and opportunities to stakeholders.
Design, develop, validate, document, and maintain reporting, semantic models, dashboards, and analytics solutions that provide accurate, timely, and actionable information.
Develop and maintain SQL queries, data transformations, reusable data assets, and governed analytics solutions supporting clinical, operational, quality, patient safety, and performance improvement initiatives.
Contribute to the organization’s transition to Microsoft Fabric by developing and supporting modern data pipelines, data models, semantic models, and Power BI solutions.
Translate complex healthcare data and analytical findings into clear, meaningful insights for audiences ranging from operational teams to senior leadership.
Collaborate with multidisciplinary teams to improve data collection, reporting efficiency, data quality, governance, and operational performance.
Participate in analytics engineering best practices, including documentation, source control, peer review, testing, deployment, and ongoing solution support.
Manage multiple assignments and projects while maintaining clear communication and delivering solutions that meet customer and organizational needs.
Preferred Qualifications
Experience working in a healthcare environment with an understanding of clinical operations, quality improvement, patient safety, regulatory reporting, or performance improvement.
Epic certification or demonstrated proficiency with Epic Clarity, Caboodle, Cogito, or other Epic clinical and operational data models.
Experience with Microsoft Fabric and Power BI, including semantic models, Lakehouse, Data Warehouse, Dataflows, Pipelines, or related analytics capabilities.
Experience developing dashboards, scorecards, reports, and self-service analytics solutions using Power BI, Tableau, or similar business intelligence platforms.
Strong SQL development, dimensional modeling, semantic modeling, and analytical problem-solving skills.
Experience developing ETL/ELT processes, data pipelines, and modern analytics engineering solutions.
Experience with Git, GitLab, Azure DevOps, source control, peer review, or CI/CD deployment practices.
Strong communication skills and the ability to translate business and technical requirements into effective analytics solutions.
Level 1 Work Performed at a Minimum
Works as an individual contributor under the direct supervision of a Level 3 or above and collaborates as a member of a team
Demonstrates a basic understanding of core data platforms (Clarity and Caboodle) and the underlying data structures relevant to the assigned role or domain
Demonstrates a basic understanding of analytics and BI technologies and terminology relevant to the role
Transforms data into meaningful deliverables using analytics and BI tools
Translates business and technical requirements into assigned deliverables, such as data extracts or reports
Demonstrates basic knowledge of SQL query debugging
Follows all DUHS, DHTS, and ACE policies and procedures applicable to the role
Responds to customer requests for assistance as assigned and prioritized by the manager
Maintains timely, clear, concise, and accurate communication with the manager, business analyst, or analytics partner (customer) 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 and Level 1 team members to use the tools and technologies required to perform their job duties
Demonstrates advanced knowledge of the assigned domain, including related data, workflows, tools, and semantic models
Demonstrates the 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
Writes and modifies accurate SQL queries independently >90% of the time
Demonstrates basic knowledge of SQL query performance tuning
Writes complex SQL inclusion and exclusion criteria for cohort development
Mentors team members on SQL questions and query tuning
Locates data elements independently >75% of the time
Demonstrates knowledge and utilization of basic data design and infrastructure
Participates in peer reviews of SQL, data transformations, and semantic model designs
Actively participates in data quality assurance and submits requests for new or enhanced data structures, tables, and attributes
Actively participates in special projects and effectively completes project assignments with minimal supervision
Manages multiple projects to completion in a timely manner
Develops and presents topics as assigned or needed by the customer and/or ACE team
Actively participates in the Duke Analytics Community or other professional forums applicable to the role
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 (e.g., Microsoft Fabric, Tableau, Power BI, semantic model development, Caboodle, advanced RW SQL, UNIX, OMOP, PCORnet, and UNOS)
Serves as the team expert and resource in SQL, data modeling, and semantic modeling
Demonstrates expertise in locating required data elements and assists team members as needed
Trains team members in advanced skills for 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
Demonstrates knowledge and appropriate use of fundamental statistics to support data interpretation, stakeholder communication, and effective visualization design
Demonstrates the ability to work independently to solve problems and complete assigned work >95% of the time
Demonstrates the ability to work with customers to understand business needs or problems independently >95% of the time
Leads projects with minimal supervision
Serves as a change agent by improving team processes and workflows when issues or gaps are identified
Serves as an expert in a given area, including the data, semantic model, and business workflow
Serves as a moderator, leader, or channel owner for a forum such as Duke Analytics Community or another professional networking organization
Team Lead Work Performed at a Minimum
Meets all Competencies in Level 3 AND
Provides day-to-day leadership, guidance, and oversight for a team of Analytics Engineers across multiple experience levels
Aligns team priorities, project assignments, and resource utilization with departmental goals and the strategic objectives of the Chief Data and Analytics Officer (CDAO) organization
Provides technical leadership for the design, development, deployment, optimization, and support of enterprise data assets, data pipelines, semantic models, analytics solutions, and reporting platforms
Conducts regular one-on-one meetings, provides coaching and mentorship, completes performance reviews, and supports the professional development and career growth of assigned team members
Reviews and approves paid time off requests and monthly timecards while ensuring appropriate team coverage and operational continuity
Leads team meetings and serves as an escalation point for complex technical, operational, and customer issues, facilitating timely resolution and effective communication
Coordinates team workload and project assignments to support the successful delivery of analytics initiatives, operational commitments, and strategic objectives
Establishes and reinforces standards and best practices for analytics engineering, including data modeling, semantic modeling, documentation, quality assurance, source control, deployment, governance, and change management
Collaborates with business, clinical, operational, analytics, and technical stakeholders to ensure successful delivery of analytics solutions and exceptional customer service
Participates in candidate interviews as needed, provides input during the selection process, and recommends team members for promotion to the manager or director
Promotes accountability, innovation, collaboration, knowledge sharing, and continuous improvement while keeping leadership informed of project risks, staffing concerns, performance issues, and operational challenges
Behaviors and Soft Competencies
Advancement to Level 3 or above requires an employee, at a minimum, to successfully attain the following:
The following measures support a fair and comprehensive evaluation process for promotions and help ensure that employees are recognized and provided opportunities to advance.
Proven ability to work at the next level: This involves demonstrating the skills and competencies required for the next level of responsibility. Employees should have demonstrated that they can handle tasks and challenges that are typically associated with a higher position.
Potential to serve beyond the next level: This measure looks at the employees’ long-term potential and their ability to grow within the organization. The employee should have the vision, ambition, and capability to take on even greater responsibilities in the future.
Consistently demonstrates a values-based approach in how they work: Employees should consistently exhibit behaviors and decision-making processes that align with DUHS values. The exhibited values are integrity, teamwork, diversity, excellence, and safety. Patient focus is also critical to success.
Is considered one of the top performers at their level across the organization: This measure evaluates the employee's overall performance and reputation within DHTS. Top performers are often recognized for their exceptional contributions, reliability, and ability to exceed expectations. Selection is based on demonstrated readiness and merit.
Required Qualifications
Education and Training
Bachelor's degree in a related field or four years of equivalent technical experience is required.
Licensure and Certification
None required. Certification in Epic Cogito, a Cogito data model, or an analytics engineering technology such as Microsoft Fabric is preferred.
Experience
Level 1: No experience is 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.
Team Lead: 5+ years of related experience, including approximately 3+ years of demonstrated leadership through projects, initiatives, mentoring, coordination or technical direction.
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.
Nearest Major Market: Durham
Nearest Secondary Market: Raleigh
Apply now »
Find similar jobs
Opens in a new tab.
Opens in a new tab.
Opens in a new tab.
Read more about Duke’s commitment to affirmative action and nondiscrimination at hr.duke.edu/eeo.
