Share this Job
Job Req ID:  19176

Clinical Data Analysis (CDA) Engineer


Position Overview: 

This position is responsible for writing and maintaining extract/transform/load routines to get data from institutional data sources for use by clinical researchers.


Describe the position’s roles & interactions:

This position will require a significant level of collaboration with other engineers on the Center for Clinical Data Analysis (CCDA) team. It will also require working closely with our Medical Directors on specific projects and techniques. This position will also require working closely with our research customers to discern their needs and to understand and address changes that arise from end user acceptance testing.  A weekly scrum is held with the entire team to review all work. The engineer will use Jira to document and track their assignments. Data must be delivered in a secure manner, following all applicable institutional policies and State and Federal regulations for privacy, security, and the conduct of human subject research.


Describe the specific systems, applications, projects for which the position is responsible:
This position is will work on extract/transform/load projects which could last in duration from 1 day to 2 weeks. The major systems with which the position interfaces are:  Epic, EPR2020, Sunrise Clinical Manager, and DataMart/CaseMix.


Describe scale/size of area, project and/or system supported:

This position could work with about one hundred different users annually, primarily from the Johns Hopkins School of Medicine, but also from the Johns Hopkins School of Public Health, Nursing, and the Engineering Program at the Homewood Campus.   The position will require some travel to the Johns Hopkins Hospital and possibly to other locations in Baltimore in order to meet with customers. The most complex part of this job is learning about the nuances of the data in large institutional databases, with data for about 4.9 million patients.


List required & preferred skills specific to position:


  • Bachelor's degree.
  • 5 years related experience.
  • Experience using SQL Server to extract and transform data.
  • Direct programming experience while pursuing education may count towards related experience. Significant undergraduate programming coursework or independent project can be considered as related experience.
  • Additional education may substitute for required experience and additional related experience may substitute for required education, to the extent permitted by the JHU equivalency formula.


Preferred skills:

  • Experience with mining data from one or more of the following systems: 
    • Epic
    • EPR2020
    • Sunrise Clinical Manager
    • DataMart/CaseMix.
  • Full command of and extensive experience with complex SQL, including:
    • DBA-level understanding of SQL Server database and table design and performance, including logs, fillfactor settings, optimization, SQL Server Agent, user permissions and schema, transaction management, iSQL, bcp, batch files.
  • Advanced DDL statements, including:
    • CREATE/ALTER/DROP tables, constraints, indexes, referential integrity, primary and foreign keys, data typing, defaults, defaults, check constraints, rules, triggers, logging, sort orders and character sets, transaction logs, global and local temporary objects, locking and lock contention/escalation, killing spids.
  • Advanced DML statements, including:
    • CASE statements, PATINDEX/CHARINDEX parsing, regular expressions, aggregate queries/scalar and vector aggregates, stored procedures, parameters, local and global variables, delimiters, CAST and CONVERT, datetime arithmetic, Boolean comparisons, while loops, cursors, RAISERROR, query optimization, SQL functions, system functions, querying system tables, query optimization.
    • SQL Server Management Studio experience, including compiling and scripting stored procedures, database mail, log analysis, optimizing/analyzing indexes.
    • SQL Server Integration Services experience (both 2008 and 2010 versions, 32- and 64-bit), include project and package creation/design; data flow tasks and data conversion; OLE, flat file and Excel data sources/destinations and connection managers; scheduled jobs; monitoring; data transformation; email notification.
  • Basic command of clinical research methods and epidemiologic principles, including missing-data handling, imputation (and its perils), parametric vs. non-parametric analysis, skewed distributions, implications of continuous vs. categorical data, assessing measurement error, form design, PID validation, CPT data, and ICD9/ICD10 diagnosis categories and handling within Epic.


Additional information:

If the candidate does not already have Epic Clarity Certification, then they will be expected to attend training sessions at Epic Headquarters in Verona Wisconsin for training leading to Clarity certification.  Certification is required for this job. In order to remain employed in this position, the candidate must pass the certification test in 3 attempts.


Classified Title: Software Engineer 
Working Title: Clinical Data Analysis (CDA) Engineer  ​​​​​
Role/Level/Range: ATP/04/PE 
Starting Salary Range: $69,140 - $75,000 annually
Employee group: Full Time 
Schedule: Monday - Friday, 8:30 a.m - 5:00 p.m /Commensurate with Experience 
Exempt Status: Exempt  
Location: 04-MD:School of Medicine Campus 
Department name: 10002853-SOM OB GYN General Administration 
Personnel area: School of Medicine


The successful candidate(s) for this position will be subject to a pre-employment background check.


If you are interested in applying for employment with The Johns Hopkins University and require special assistance or accommodation during any part of the pre-employment process, please contact the HR Business Services Office at For TTY users, call via Maryland Relay or dial 711.


The following additional provisions may apply depending on which campus you will work.  Your recruiter will advise accordingly.


During the Influenza ("the flu") season, as a condition of employment, The Johns Hopkins Institutions require all employees who provide ongoing services to patients or work in patient care or clinical care areas to have an annual influenza vaccination or possess an approved medical or religious exception. Failure to meet this requirement may result in termination of employment.


The pre-employment physical for positions in clinical areas, laboratories, working with research subjects, or involving community contact requires documentation of immune status against Rubella (German measles), Rubeola (Measles), Mumps, Varicella (chickenpox), Hepatitis B and documentation of having received the Tdap (Tetanus, diphtheria, pertussis) vaccination. This may include documentation of having two (2) MMR vaccines; two (2) Varicella vaccines; or antibody status to these diseases from laboratory testing. Blood tests for immunities to these diseases are ordinarily included in the pre-employment physical exam except for those employees who provide results of blood tests or immunization documentation from their own health care providers. Any vaccinations required for these diseases will be given at no cost in our Occupational Health office.


Equal Opportunity Employer
Note: Job Postings are updated daily and remain online until filled. 


EEO is the Law
Learn more:
Important legal information


School of Medicine - East Baltimore Campus