Share this Job

DBHi Information Analyst II

Date: Mar 18, 2017

Location: Philadelphia, PA, US, 19104

Company: CHOP

Apply now »

Job Description

Req ID: 7253

Shift: Days

Employment Status: AF - Active - Regular - Full Time 

Job Summary

The Department of Biomedical and Health Informatics (DBHi) at The Children’s Hospital of Philadelphia (CHOP) is seeking an Information Analyst to extract and transform data from a variety of clinical and supporting non-clinical data sources to enable research initiatives. The amount and complexity of the data will demand careful attention to details of the underlying data model and may result in large schema changes or mapping. The candidate should possess strong SQL programming skills, basic performance tuning and must be able to communicate with the research teams to efficiently translate clinical data models into interpretable information for biomedical research activities.


  • Will generally extract and transform data from a variety of clinical and supporting non-clinical data sources to enable research and quality improvement initiatives leading to research across a rapidly evolving academic research enterprise.
  • Understands data validation, loading, and structures at an intermediate level.
  • Efficiently manipulates large-scale and complex data sets using a variety of formatting and/or analysis languages such as Perl, Python, and Java.
  • The amount and complexity of the data, especially those associated with genomic experiments, will demand careful attention to details of the underlying data model and may result in large schema changes or mapping.

Job Responsibilities

The responsibilities of an Information Analyst II – Research/DBHi encompass identical responsibilities as the Information Analyst I – Research/DBHi, but with a greater degree of complexity.  An Information Analyst II – Research/DBHi also:

  • Defines strategy for each report, given knowledge of underlying schemas, integration requirements for disparate data sources (e.g., ETL), coding solutions, and 3rd party tool availability.
  • Transforms data models of high complexity into “research-ready” data models also of high complexity by employing code, knowledge of disparate schemas and SQL varieties, and large data set manipulation techniques.
  • Creates reports and provides product to customer along with clear, concise interpretation and caveats.
  • Clearly articulates problems, issues, and potential solutions to clients.
  • Makes oral presentations to colleagues, clients, and administration when requested.
  • Appropriately manages expectations of development time, functionality of resulting modules, and short-term vs. long-term achievements.
  • Stays current with clinical reporting capabilities across the industry, including developments at clinical data systems providers, other hospital and academic research centers, and general user forums.

Job Responsibilities (Continued)

Job Responsibilities (Continued)

Required Licenses, Certifications, Registrations

EPIC - Clarity Certification (90 days)

Required Education and Experience

Required Education: Bachelor’s Degree in computer related field or commensurate experience.


Required Experience: 2-5 years of data extraction / manipulation, preferably in a healthcare environment.

Preferred Education, Experience & Cert/Lic

Preferred Education: Candidates with a degree in the life sciences, but who have pursued a career in informatics is highly desirable.                                                             


Preferred Experience:

  • 3+ years of programming and database experience with progressively more complex projects in a full-time, salaried industry or equivalent academic position.
  • Experience in healthcare and/or biomedical data management issues.
  • Experience in building databases in REDCap.

Additional Technical Requirements

  • Must be able to efficiently translate clinical data modeled within a complex schema into interpretable information for biomedical research activities. 
  • Situational awareness concerning data interpretation, quality, and integrity is essential. 
  • Must exhibit good oral and written communication skills.
  • Working knowledge of SQL and one or more of the following: Perl, Python, Java, PostgreSQL, R and API programming.
  • Working knowledge of relational database application development, including stored procedures, SQL, data definition language, basic performance tuning and query optimization, and ETL techniques.

Information Security Requirements

  • Understand and comply with all enterprise and IS departmental information security policies, procedures and standards.
  • Support the integration of information security in the development, design, and implementation of Hospital Technology Resources that process, transmit, or store CHOP information.
  • Support all compliance activities related to state, federal regulatory requirements, healthcare accreditation standards, and all other applicable regulations that govern the use and disclosure of patient, financial, or other confidential information.


Nearest Major Market: Philadelphia

Job Segment: EMR, SQL, Java, Database, Healthcare, Technology, Research

Apply now »