Data Integration Analyst III-Data-Driven Discovery in Biomedicine (D3b)

Children’s Hospital of Philadelphia • Philadelphia, PA

4d

About The Position

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
The Center for Data-Driven Discovery in Biomedicine (D3b - d3b.center) at Children's Hospital of Philadelphia (CHOP) is dedicated to accelerating pediatric research through innovative data infrastructure and collaborative science. Our mission is to provide researchers with robust, scalable platforms that enable groundbreaking discoveries in childhood diseases and improve outcomes for children worldwide.
D3b seeks an experienced Data Integration Analyst to join a multi-disciplinary team of data scientists, engineers, and analysts in the Advanced Data Applications and Platforms Technologys Unit (ADAPT) committed to accelerating treatments and cures for children with cancer. The hire will lead collaborative efforts with other institutions to develop and implement harmonized data models for interventional radiology and other cancer treatment data. The data integration analyst will also work with other analysts and engineers to develop and maintain data warehouses and data ingest and harmonization pipelines to support the collection, integration, quality control and reuse of multimodal clinical and research data.
The ideal candidate will have experience with data modeling and data harmonization practices. They will be able to think and plan strategically to achieve long term goals by defining clear milestones and quickly delivering iterative solutions. As a level III, the candidate will also be expected to serve as a project team lead in a highly matrixed research environment, including direct interaction with clinicians and biomedical researchers, and to mentor junior staff and student workers.

Requirements

• Bachelor's Degree - Required
• At least five (5) years of experience in database development, database administration, data management, or related discipline, with progressively more complex projects in a biomedical science or healthcare environment Required
• Working knowledge of SQL required
• Working knowledge of relational database management systems such as PostgreSQL, MySQL, Oracle required
• Must exhibit excellent verbal, presentation, and written communication skills

Nice To Haves

• Master's Degree Computer Science, Information Science, Informatics, Biomedical Engineering, Biological Science or a related discipline - Preferred
• At least six (6) years of experience in database development, database administration, data management, or related discipline, with progressively more complex projects in a biomedical science or healthcare environment. Specific experience with DBT, postgres, and starrocks is a positive. 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 Preferred
• Previous experience in source code management, continuous integration, containerization, and automated testing tools and processes is preferred. Specific experience with Git/Github, AWS, and Airflow is a positive. Preferred
• Project management experience preferred Preferred
• Knowledge of clinical data systems or operational clinical data procedures Preferred
• Previous experience with interventional radiology data or cancer treatment data Preferred
• 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
• Working knowledge of data modeling approaches preferred

Responsibilities

• Collaborate with biomedical researchers and clinical subject matter experts to identify and analyze scientific problems that require integration of disparate, highly dimensional data types such as clinical and genomic data.
• Develop and implement innovative data models that represent complex biomedical data types in usable and accessible schema.
• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level