Data Integration Analyst II; Aplenc Lab

SHIFT:

Seeking Breakthrough Makers

Children's Hospital of Philadelphia (CHOP) offers countless ways to change lives. Our diverse community of more than 20,000 Breakthrough Makers will inspire you to pursue passions, develop expertise, and drive innovation.

At CHOP, your experience is valued; your voice is heard; and your contributions make a difference for patients and families. Join us as we build on our promise to advance pediatric care-and your career.

CHOP does not discriminate on the basis of race, color, sex, national origin, religion, or any other legally protected categories in any employment, training, or vendor decisions or programs. CHOP recognizes the critical importance of a workforce rich in varied backgrounds and experiences and engages in ongoing efforts to achieve that through equally varied and non-discriminatory means.

A Brief Overview

Dr. Richard Aplenc, MD, PhD, Professor of Pediatrics and Epidemiology at the Perelman School of Medicine at the University of Pennsylvania; AVP and Chief Clinical Research Officer; and The Mai and Harry F. West Endowed Chair in Pediatric Research at Children's Hospital of Philadelphia, is seeking a talented, highly self-motivated individual to join his collaborative team as a Data Integration Analyst II.

Dr. Aplenc's work aims to improve clinical outcomes for pediatric cancer patients through translational, large-scale clinical data initiatives. This role will contribute directly to the continued development and implementation of ExtractEHR+, an automated electronic health record (EHR) data extraction and curation toolkit designed to make high-quality clinical data more accessible, consistent, and usable for research.

The Data Integration Analyst II will independently develop integrated biomedical data resources and associated applications that enable novel, data-intensive clinical and translational research. A core focus of the role will be designing, improving, and supporting automated workflows for extracting, transforming, validating, and integrating EHR data from diverse clinical systems and sources. This work will include the Epic Cosmos environment.

Key responsibilities include:

• Analyze clinical care, clinical research, laboratory, and EHR documentation workflows to deliver customized data-management, data-integration, reporting, and analytic solutions.
• Support the development and expansion of ExtractEHR+, including automated extraction of structured and unstructured EHR data, data normalization, quality assurance, provenance tracking, and integration with research databases and analytic platforms.
• Develop scalable data pipelines and data models that transform raw EHR and related biomedical data into research-ready datasets.
• Collaborate with clinicians, researchers, informaticians, and technical teams to identify priority EHR data elements, define extraction requirements, and validate the accuracy and completeness of extracted data.
• Improve the quality, consistency, utility, and accessibility of clinical and scientific data throughout its lifecycle, with particular attention to the challenges of real-world EHR data.
• Build consensus and buy-in for complex data-integration initiatives by defining clear milestones and rapidly delivering iterative data-management, database, application, and automated extraction products.
• Develop and apply best-practice methods for high-value biomedical data resources, including data modeling, interoperability, data provenance, data integration, quality control, governance, and patient privacy protection.
• Work independently and as part of a project team in a highly matrixed research environment, including direct interaction with clinicians and biomedical researchers.
  

What you will do

• Collaborate with biomedical researchers to identify and analyze scientific problems that require integration of disparate, highly dimensional data types such as clinical and genomic data.
• Quickly acquire biomedical domain knowledge in order to understand requirements for data integration, optimizing data resources and applications to meet scientific needs.
• Create requirements for complex data integration and application development projects, and translate requirements into deliverables.
• Develop and implement innovative data models that represent complex biomedical data types in usable and accessible schema.
• Write extract, transform, and load (ETL) procedures that combine and recombine biomedical data into new, more useful formats.
• Build and optimize scientific data management, data discovery, reporting, and analysis applications using a combination of off-the-shelf and custom tools.
• Manage small projects and subprojects within larger initiatives, identifying, tracking, and reporting on tasks and deliverables against project timelines.

Education Qualifications

• Bachelor's Degree Required
• Master's Degree in computer/information science, informatics, biomedical engineering, biological science or a related field Preferred

Experience Qualifications

• At least three (3) years of database development/administration, data management, or related experience Required
• At least five (5) years of database development/administration, data management, or related experience within a biomedical science or healthcare environment Preferred

Skills and Abilities

• Intermediate proficiency in data integration, and data architecture
• Intermediate proficiency in data modeling, ETL, and applications of highly dimensional data types, such as derived from genomics and observational clinical or human subjects research data
• Intermediate proficiency in source code management, continuous integration, containerization, and automated testing tools and processes
• Substantial knowledge of programing languages (SQL, Python/Django, JavaScript/HTML, Java, Scala)
• Substantial knowledge of relational database management systems (PostgreSQL, MySQL, Oracle)
• Substantial knowledge of biomedical or healthcare data models and standards (HL7, ICD, CPT, SNOMED)
• Excellent verbal and written communications skills
• Strong time management skills
• Strong organizational skills
• Strong presentation skills
• Strong project management skills

To carry out its mission, CHOP is committed to supporting the health of our patients, families, workforce, and global community. As a condition of employment, CHOP employees who work in patient care buildings or who have patient facing responsibilities must receive an annual influenza vaccine. Learn more. EEO / VEVRAA Federal Contractor | Tobacco Statement

SALARY RANGE:

Salary ranges are shown for full-time jobs. If you're working part-time, your pay will be adjusted accordingly.

-------------------

At CHOP, we are committed to fair and transparent pay practices. Factors such as skills and experience could result in an offer above the salary range noted in this job posting. Click here for more information regarding CHOP's Compensation and Benefits.