Review and apply data mappings for customer specific data exports.
Perform peer review / QC of data export programming.
Produce data transfers via data export files and/or web services.
Work with customers to specify data transfer standards and develop/implement software code to automate data transfer activities.
Provide database programming support for custom reports.
Perform peer review / QC of custom report programming.
Create and implement database scripts to correct issues.
Participate in departmental discussions regarding technical, functional and process improvement.
Ensure that all project-related programming tasks are completed in accordance with standard practices throughout the lifecycle of the project including, but not limited to:
Perform data integration configuration, programming, and documentation.
Process Data Clarification Forms (DCFs).
Manage and program targeted rules.
Oversee data outputs for integrity and accuracy.
Triage, research and provide solutions for identified data issues.
Communicate progress and roadblocks on programming efforts to internal and external stakeholders.
Assist junior staff to troubleshoot programming issues.
Contribute to department knowledge share for common issues, standard processes, guides, etc.
Requirements:
Bachelor's degree in computer science, software engineering, information technology, informatics, or closely related field (or equivalent experience).
6 years of experience as a software developer, database analyst/programmer, or clinical software tester.
Experience with Snowflake.
Experience building reports in SSRS, Tableau, or other reporting tools.
3 years' experience with programming in Microsoft SQL and/or MySQL.
4 years of experience programming in SAS.
6 years of experience with Clinical Data Management and clinical development technology solutions.
Understanding of the clinical trial processes, including common data standards (CDISC) and Study Data Tabulation Model (SDTM).
Ability to manage competing priorities and can work in a dynamic environment.
Comfortable writing and troubleshooting complex SQL queries that include PIVOT, Indexing, CTE's, Subqueries, etc.
Index Exchange
EPSA
Ryan
Resillion Netherlands
Parexel