The Department of Biomedical and Health Informatics (DBHi) and the Center for Pediatric Clinical Effectiveness (CPCE) at Children’s Hospital of Philadelphia (CHOP) are seeking an Information Analyst III to support the combined laboratories of Drs. Richard Aplenc, Brian Fisher, and Jeffrey Gerber. The candidate will extract data from various research and clinical sources, most notably CHOP’s electronic health record (EHR), and transform into aggregate, actionable formats for research. The candidate will also work very closely with CHOP DBHI staff and external stakeholders in the multi-site implementation of ExtractEHR, a CHOP based EHR data extraction, cleaning, and federation platform.
The Aplenc, Fisher, and Gerber laboratories use advanced informatics methods and large data sets to analyze various aspects of childhood disease in areas such as oncology and infectious diseases as well as related areas such as clinical effectiveness, safety, and adverse event reporting in the single and multi-institutional trial setting. Additional responsibilities include Honest Broker activities, reconciliation of data models from multiple sources, and general data management.
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.
- The responsibilities of an Information Analyst III - encompass similar responsibilities as the Information Analyst II, but with a greater degree of complexity. An Information Analyst III may be involved in some leadership activities. An Information Analyst III also:
- 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
At least five (5) years of data extraction / manipulation experience
Preferred Education: Master’s degree in Life Sciences or Informatics
- At least five (5) years of data extraction / manipulation experience in a healthcare environment
- At least five (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
Additional Technical Requirements
- Mastery and expert working knowledge of SQL and one or more of the following: Perl, Python, Java, R, PostgreSQL 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.
- Strong knowledge in data mapping using Common Data Models (CDM) such as PCORNET and OMOP preferred