Share this Job


Req ID:  11105

Durham, NC, US, 27710

Personnel Area:  MEDICAL CENTER

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.



2293 Database Information Technology Analyst II (DBA II), Position 51020101

Job Family 08; Job Level 14


Position Description

Occupational Summary

Coordinate and perform a variety of technical and creative duties for data analytics, data modeling and data management using an array of software applications, framework, techniques, and tools to design and develop and test custom solutions, reports and applications and provide support to existing applications for the Duke Cancer Institute (DCI).



This position reports directly to the Office of Academic Solutions and Information Systems (OASIS) Application Data Team Lead, and indirectly to the DCI IT Application & Database Development Manager and the DCI-IT Research Operations Leader


Responsibilities and Expectations

DCI Data – 50% Effort

  • Work with DCI leadership and customers to develop requested reports and advanced ad-hoc queries
  • Develop, maintain, and document extensive suite of DCI-specific data solutions, with a focus on data from iMedRIS iRIS, Duke’s Institutional Review Board (IRB) system and Forte OnCore, Duke’s Clinical Research Management System (CRMS)
  • Develop, maintain, and document database solutions (e.g., virtual private database, materialized views) that can easily be extended to support other departments.


Build, maintain, and document database for CTMS reporting DCI Applications – 10% Effort

  • Administration and management of applications on DCI’s application team. 
  • Responsible for data analysis, data interpretation using statistical techniques to design, develop and test custom solutions, reports and applications and integrate with web applications


Application Development and Data Management – 30% Effort

  • Foster and build relationships with clinical research teams, leadership, IT/development to developing custom solutions
  • Identify, analyze, and interpret trends or patterns in complex data sets
  • Act as the lead person for data management by creating dashboards and metrics
  • Act as departmental liaison to other departments as it relates to data analytics
  • Evaluate new data analytics tools for scalability, industry approval and consistency
  • Research information/best practices that enhance the significance of the dashboard. Work to keep the dashboard up to date enforcing standards and available technologies


Compliance – 10% Effort

  • Adhere to Duke Security and Standards as related to HIPPA and provide training and assistance on issues regarding data analysis and management
  • Attend staff meetings, conferences and training as assigned


And other work as assigned.



  • Familiarity with code versioning software:  Git, SVN, CVS.  Ability to write good test cases and automated unit tests for all code.
  • Advanced skills in writing SQL queries in multiple databases – SQL Server, MySQL, Oracle, and strong analytical and problem-solving skills. 
  • Experience in documenting code and in creating, writing and maintaining SOPs
  • Experience with deployment to the web and with web security best practices.
  • Effective communication skills to explain reports, models, and dashboards throughout the organization. 
  • Strong organizational skills and high attention to detail to meet deadlines in an environment of constantly changing priorities.

The above statements describe the general nature and level of work being performed.  This is not intended to be an exhaustive list of all responsibilities and duties required.  Employees may be directed to perform job-related tasks other than those specifically presented in this description.

The intent of this job description is to be representative of the level and the types of duties and responsibilities that will be required of this position and shall not be construed as a declaration of the total specific duties and responsibilities. 


  • Experience with OnCore (or other Clinical Research Management Systems – CRMS), Jasper Reports, Tableau, Business Objects, Crystal Reports or similar tools and business intelligence (BI) software tools 
  • Experience with web development tools and programming or scripting tools like Python, Ruby
  • Experience working in multi Operating System environments - Windows and Linux
  • Experience with database development and management



Required Qualifications at this Level



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 reorganization of relational databases for a complex computer network.





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.


Nearest Major Market: Durham
Nearest Secondary Market: Raleigh