DATABASE ANALYST II - Department of Surgery, Lung Transplant at Duke University

Posted in Other 7 days ago.

Location: Durham, North Carolina

Job Description:

School of Medicine:

Established in 1930, Duke University School of Medicine is the youngest of the nation's top medical schools. Ranked tenth among its peers, the School takes pride in being an inclusive community of outstanding learners, investigators, clinicians, and staff where traditional barriers are low, interdisciplinary collaboration is embraced, and great ideas accelerate translation of fundamental scientific discoveries to improve humanhealth locally and around the globe.

Comprised of 2,400 faculty physicians and researchers, the Duke University School of Medicine along with the Duke University School of Nursing and Duke University Health System create Duke Health. Duke Health is a world-class health care network. Founded in 1998 to provide efficient, responsive care, the health system offers a full network of health services and encompasses Duke University Hospital, Duke Regional Hospital, Duke Raleigh Hospital, Duke Primary Care, Private Diagnostic Clinic, Duke Home and Hospice, Duke Health and Wellness, and multiple affiliations.

Database Analyst II- Lung Transplant

Occupational Summary

Duke Heart - Duke Division of Ca rdiovascular and Thoracic Surgery and Duke Division of Cardiology - is ranked among the top programs in the nation and aims to position itself as a leader in Heart Analytics and Cardiovascular Intelligence. Duke Heart is a powerhouse of Cardiovascular Information Technologies. We use Lumedx, a cardiovascular platform, to augments Epic EHR in order to create an immensely data rich environment. This position will be part of the Center of Excellence Sr. Analyst Team and report directly to the Senior Manager. The primary responsibility will be to support electronic sourcing for registries, submit data to registries, and mine EHR data (EPIC Caboodle: SQLServer or EPIC Clarity: Oracle), as well as create jobs that import and integrate miscellaneous external data sets into our Heart Center Repository (SQL Server)for use, among other things, to update a variety of Registry data and generate reports in support of clinical operations.


  • Support Duke Heart by sourcing data sets associated with clinical areas (e.g.Cath) from EPIC Caboodle, or Clarity and import via ETL process into Heart's SQL Server Environ ment (Lumedx) to reduce overall registry manual abstraction workload and provide data to support clinical performance and operations. Process and manage large volume of healthcare datasets between repositories. Audit and cleanse data that can be consumable/transferred to other application databases.

  • Collaborate with fellow developers and with Clinical Business Analyst in the establishment, maintenance, and execution of best practices associated with data security, data governance (approvals), testing, documentation, verification data, and dictionary and meta data management.

  • Perform and document data validation, including validation of Electronic Health Record-derived clinical phenotypes

  • Periodically create SQL Ser ver SSRS, or PowerBI reports following requirements laid out by Clinical Analyst.

  • Participate in 2nd level help desk support,24x7, for departmentally supported systems.

  • Visit and acquire general understanding of clinical areas supported by COE by performing periodic field visits.

  • Teach and train other members of COE about available data and how to access it and use it to support their clinical and operational areas. Strong analytical skills, including a thorough understanding of how to interpret client business needs and translate them into application and operational requirements.

  • Contribute to departmental knowledge base.

  • Perform other related duties incidental to the work described herein.

Desired experience and skills:


Work requires a Bachelor's degree in mathematics, computer science, or a computer related field.

Experience Job Requirements:

  • SQL server and plus other data sourcing and reporting tools. e.g. Power BI, SSRS. (5 years or more).

  • Experience sourcing data and or reports in support of a clinical environment (3 years).

  • Experience interacting with physicians in the cardiology or CT surgery care areas supporting education, quality, performance improvement and or educational activities (5 years).

Skill Requirements:

  • Proficiency with SQL (Vie ws, Stored procedures), experience with BI/reporting platforms.

  • Prior experience with Epic Electronic Health Record systems and demonst rated understanding of HL7 messages and using of medical terminology (su chas ICD9, ICD10, and CPT) in clinical informatics and healthcare resea rch settings are preferred.

  • Knowledge of HIPAA and other relevant privacy regulations

  • Strong communication skills and the ability to build positive working relationships with clinicians, biostatisticians, and IT staff.

  • Strong attention to detail.

  • Excellent customer service and diplomacy skills.

  • Willingness to address issues and take ownership, knowing when and how to escalate issues.

Duke is an Affirmative Action/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, sexual orientation, or veteran 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 essentialjob 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.