Note: The job is a remote job and is open to candidates in USA. Clinical Ink is a global life science company that combines data, technology, and patient science to advance clinical discovery. The Clinical Programmer will develop, configure, quality-check, and troubleshoot data integrations, exports, reports, and database scripts while supporting reliable customer data transfers and project lifecycle improvements.
Responsibilities
- 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
Skills
- Bachelor's degree in computer science, software engineering, information technology, informatics, or closely related field (or equivalent experience)
- 5+ 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
- 2+ years' experience with programming in Microsoft SQL and/or MySQL
- 3+ years of experience programming in SAS
- 5+ 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
Company Overview
Company H1B Sponsorship