Data Migration and Interface Developer

Skills

Strong Proficiency in Oracle Strong Proficiency in SQL Understanding of Database Structures Proficiency in utilizing ETL tools such as SSIS working with large datasets and integration strategies 4 Year College Degree 5-10 years of demonstrated experience Familiarity with EPIC and Medipac strongly preferred Familiarity with RedCap preferred Familiarity with Advarra OnCore Clinical Trial Management System preferred

Description

Successful candidates will be members of the team responsible for data mapping, data migration from the current custom Clinical Trials Management System to a vendor’s cloud-based solution, and for development of integration with the cloud-based solution. Responsibilities will include interface development and analysis.
Development of Clinical Pathways System Protocol Status XML file
Development of NCI Database Trial Information Flat File
Development of flat file from Advarra’s OnCore to Wondros Database
Development of Patient and Trial Information flat file export from Advarra’s OnCore to on-premises Data Warehouse
Work with EPIC team to develop EPIC Research Module CPT Code Flat File
Work with Medipac team to develop (3) Flat Files from Advarra’s OnCore to Medipac
Assist with ADT interface build/testing/implementation
Assist with build, testing, and implementation of Advarra’s OnCore RPE interface
Assist with build, testing, and implementation of Advarra’s OnCore CRPE interface
Assist with build, testing, and implementation of interface from EPIC to Varian Medical Systems ARIA EMR
Work will Peoplesoft team to develop Receivables Interface
RedCap Development and Analysis responsibilities