Data Integration Analyst I

Philadelphia, PA, US, 19146

​Location: LOC_ROBERTS-Roberts Ctr Pediatric Research 

Req ID: 229251

Shift: Days

Employment Status: Regular - Full Time 


Seeking Breakthrough Makers   

Children’s Hospital of Philadelphia (CHOP)—named America’s 2022 Best Large Employer by Forbes—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’s Commitment to Diversity, Equity, and Inclusion 

CHOP is committed to building an inclusive culture where employees feel a sense of belonging, connection, and community within their workplace. We are a team dedicated to fostering an environment that allows for all to be their authentic selves. We are focused on attracting, cultivating, and retaining diverse talent who can help us deliver on our mission to be a world leader in the advancement of healthcare for children. 

We strongly encourage all candidates of diverse backgrounds and lived experiences to apply. 

Job Summary

The Data Integration Analyst I will join an internationally recognized group at the Children’s Hospital of Philadelphia working to transform the health of children. He or she will work within a dynamic team of data scientists, programmers, and researchers as part of PEDSnet ( and the Research Institute’s Applied Clinical Research Center to understand predictors of childhood diseases, improve the quality of children’s healthcare, and rapidly advance knowledge through the creation and development of learning health systems. The Data Coordinating Center’s focus is on developing informatics methods to standardize health data from diverse sources and make intelligent use of the data to produce new and actionable knowledge about child health. The Data Integration Analyst will work on a variety of projects including quarterly pediatric submissions, onboarding work associated with new pediatric hospitals, and COVID-19 related research projects.


The main activities of the role include but are not limited to the following:


  • Integrate disparate data sources as part of multiple pipelines which include COVID19 surveillance as well as EHR data as part of a learning health system.
  • Utilize Docker or Kubernetes for containerization needs.
  • Conduct data quality assessments on incoming data and identify potential areas where data extraction processes can be improved.
  • Develop reports summarizing the content and quality of data submissions and communicate with data partners about the use of their data.
  • Collaborate with members of the PEDSnet DCC to develop tools for more efficient analyses that can be disseminated to researchers and other stakeholders who access the data.
  • Participate in decisions regarding data modeling and design to optimize use of the network database.
  • Work as part of a project team in a highly matrixed research environment, including direct interaction with clinicians and biomedical researchers.

Job Responsibilities

  • 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.

Required Education and Experience

Required Education: Bachelors Degree

Preferred Education, Experience & Cert/Lic

Preferred Education: Masters Degree in Computer Science, Information Science, Informatics, Biomedical Engineering, Biological Science or a related discipline

Preferred Experience:

  • At least (1) year of experience in database development, database administration, data management, or related discipline, preferably in a biomedical science or healthcare environment. 
  • Experience with source code management, continuous integration, containerization, and automated testing tools and processes is preferred.
  • Project management experience preferred.
  • Previous experience in data modeling, ETL, and applications of highly dimensional data types such as derived from genomics and observational clinical or human subjects research data preferred.

Additional Technical Requirements


  • Knowledge of distributed data processing ETL such as Apache Spark, Databricks, AWS Glue.
  • Experience with open-source platforms.
  • Must exhibit excellent oral, presentation, and written communication skills.
  • Working knowledge of SQL.
  • Working knowledge of relational database management systems such as PostgreSQL, MySQL, Oracle.
  • Working knowledge of one or more of the following preferred: Python/Django, JavaScript/HTML (as used in Single Page Applications), Java, Scala.
  • Working knowledge of biomedical or healthcare data standards such as HL7, ICD, CPT, SNOMED preferred.

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, professionals working onsite—at any CHOP location, for any portion of time—must be vaccinated for COVID-19. Learn more. 

CHOP also requires employees who work in patient care buildings to receive an annual influenza vaccine. Employees may request exemptions for valid religious and medical reasons.  Start dates may be delayed until candidates are immunized or exemption requests are reviewed.  

EEO / VEVRAA Federal Contractor        |              Tobacco Statement 


Nearest Major Market: Philadelphia

Job Segment: Data Analyst, Database, DBA, Clinical Research, Medical Research, Data, Technology, Healthcare