Share this Job

DBHi Information Analyst III

Date: Dec 5, 2018

Location: Philadelphia, PA, US, 19146

Company: CHOP

Job Description

Req ID: 20244

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 III 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

•    Meets with researchers and other customers to establish project goals and scope, set expectations concerning feasibility and timelines, and generally discuss solutions.
•    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.
•    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.
•    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
•    Can provide moderate on-the-job training/guidance to other analysts for one or more querying, analytical, and formatting languages such as Perl, Python, Java, SQL, R, PosgreSQL and API programming.
•    Serves as lead for unit-level activities such as code reviews, etc.
 

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: 4-8 years of data extraction / manipulation experience, preferably in a healthcare environment.

Preferred Education, Experience & Cert/Lic

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

 

Preferred Experience:

  • 5+ years of programming and database experience with progressively more complex projects in a full-time, salaried industry or equivalent academic position.
  • Experience in building databases in REDCap.
  • Strong knowledge in data mapping using Common Data Models (CDM) such as PCORNET and OMOP.

Additional Technical Requirements

  • Mastery and expert working knowledge of SQL and one or more of the following: Perl, Python, Java, R, PosgreSQL and API programming.
  • Mastery and expert working knowledge of relational database application development, including stored procedures, SQL, data definition language, basic performance tuning and query optimization, and ETL techniques.
  • 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 excellent oral and written communication skills, including presentations in national conferences and writing papers.

 

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.

All CHOP employees who work in a patient building or who provide patient care are required to receive an annual influenza vaccine unless they are granted a medical or religious exemption.

Children's Hospital of Philadelphia is committed to providing a safe and healthy environment for its patients, family members, visitors and employees. In an effort to achieve this goal, employment at Children's Hospital of Philadelphia, other than for positions with regularly scheduled hours in New Jersey, is contingent upon an attestation that the job applicant does not use tobacco products or nicotine in any form and a negative nicotine screen (the latter occurs after a job offer).

Children's Hospital of Philadelphia is an equal opportunity employer. We do not discriminate on the basis of race, color, gender, gender identity, sexual orientation, age, religion, national or ethnic origin, disability or protected veteran status.

VEVRAA Federal Contractor/Seeking priority referrals for protected veterans.  Please contact our hiring official with any referrals or questions.

CHOP Careers Contact 

Talent Acquisition

2716 South Street, 6th Floor

Philadelphia, PA 19146 

Phone: 866-820-9288 

Email:TalentAcquisition@email.chop.edu

 

 


Nearest Major Market: Philadelphia

Job Segment: EMR, Medical, Patient Care, Database, Healthcare, Research, Technology