Data Integration Analyst II

Children’s Hospital of Philadelphia•Philadelphia, PA

3d•$101,300 - $129,100•Onsite

About The Position

Independently develop integrated biomedical data resources and associated applications that enable novel modes of data intensive clinical and translational research. Analyze clinical, clinical research, and laboratory workflows in order to deliver custom data management, data integration, reporting, and analysis solutions that improve the quality, consistency, and utility of scientific data throughout its lifecycle. Build consensus and buy-in to complex data integration projects by defining clear milestones and quickly delivering iterative data management, database and application products. Develop and apply best-practice methods for creation, optimization, and operation of high-value biomedical data resources, including data modeling, data provenance, data integration, quality control, 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.

Requirements

Bachelor's Degree - Required
At least three (3) years of database development/administration, data management, or related experience - Required
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, R)
Substantial knowledge of relational database management systems (PostgreSQL, Snowflake, BigQuery)
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

Nice To Haves

Master's Degree in computer/information science, informatics, biomedical engineering, biological science or a related field - Preferred
At least five (5) years of database development/administration, data management, or related experience within a biomedical science or healthcare environment - Preferred
Working knowledge of containerization and container orchestration tools preferred (Docker, Kubernetes, Argo)

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.