DATABASE ANALYST II - Department of Surgery, Lung Transplant
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
Occupa tional Summary
Duke Heart – Duke Division of Ca rdiovascular and Thoracic Surgery and Duke Division of Cardiology – is r anked among the top programs in the nation and aims to position itself a s a leader in Heart Analytics and Cardiovascular Intelligence. Duke Hear t is a powerhouse of Cardiovascular Information Technologies. We use Lum edx, a cardiovascular platform, to augments Epic EHR in order to create an immensely data rich environment. This position will be part of the Ce nter of Excellence Sr. Analyst Team and report directly to the Senior Ma nager. The primary responsibility will be to support electronic sourcing for registries, submit data to registries, and mine EHR data (EPIC Cabo odle: SQLServer or EPIC Clarity: Oracle), as well as create jobs that im port and integrate miscellaneous external data sets into our Heart Cente r Repository (SQL Server)for use, among other things, to update a variet y of Registry data and generate reports in support of clinical operation s.
- Support Duke Heart by sourci ng data sets associated with clinical areas (e.g.Cath) from EPIC Caboodl e, 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 an d manage large volume of healthcare datasets between repositories. Audi t and cleanse data that can be consumable/transferred to other applicati on databases.
- Collaborate with fellow developers and with Clinical Business Analyst in the establishment, maintenance, an d execution of best practices associated with data security, data govern ance (approvals),testing, documentation, verification data, and dictiona ry and meta data management.
- Perform and document data validation, including validation of Electronic Health Record-deriv ed clinical phenotypes
- Periodically create SQL Ser ver SSRS, or PowerBI reports following requirements laid out by Clinical Analyst.
- Participate in 2nd level help desk supp ort,24x7, for departmentally supported systems.
- Vi sit and acquire general understanding of clinical areas supported by COE by performing periodic field visits.
- Teach and t rain other members of COE about available data and how to access it and use it to support their clinical and operational areas. Strong analytica l skills, including a thorough understanding of how to interpret client business needs and translate them intoapplication and operational requi rements.
- Contribute to departmental knowledge bas e.
- Perform other related duties incidental to the work described herein.
Desired experience and skills:
Work generally requires a bachelor's degre e in mathematics, computer science, or a computer-related field or the e quivalent coursework or technical training.
Experience Job Requirements:
- SQL server and plus other dat a sourcing and reporting tools. e.g. Power BI, SSRS. (5 years or more).< br/>- Experience sourcing data and or reports in support of a clinica lenvironment (3 years).
- Experience interacting with physicians in the cardiology or CT surgery care areas supporting education, qualit y, performance improvement and or educational activities (5 years).
- 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 oth er relevant privacy regulations- Strong commu nication skills and the ability to build positive working relationships with clinicians, biostatisticians, and IT staff.
- Strong attenti on to detail.
- Excellent customer service and diplomacy skills.- Willingness to address issues and take ownership, knowing when and how to escalate issues.
Work requires a Bachelor's degree in mathematics, computer science, or a computer related field.
Work requires 4 years of progressive programming or database administration experience to include design, implementation, tuning, backup, recovery, modification and reorganizationof relational databases for a complex computer network. OR AN EQUIVALENT COMBINATION OF RELEVANT EDUCATION AND/OR EXPERIENCE
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.