Principal Clinical Datawarehouse Programmer [Remote]

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Principal Clinical Datawarehouse Programmer based in the United States.

This role sits at the intersection of clinical research and advanced data engineering, ensuring high-quality, reliable data foundations that support critical decision-making in clinical trials. You will design, build, and maintain robust ETL pipelines that integrate complex clinical datasets from multiple sources into structured, analysis-ready environments. Working within a regulated life sciences setting, you will translate clinical and business requirements into scalable technical solutions aligned with SDLC best practices. The position involves close collaboration with cross-functional stakeholders including clinical operations, safety, IT, and medical affairs teams. You will play a key role in ensuring data integrity, governance, and compliance while enabling downstream analytics and reporting. This is a highly technical and impact-driven role where precision, reliability, and scientific rigor are essential.

Accountabilities:

In this role, you will design, develop, and maintain clinical data warehouse solutions that ensure accurate, secure, and high-performing data pipelines for clinical research and business use.

• Translate business and clinical requirements into ETL data pipeline design specifications following SDLC processes
• Design, build, test, and deploy scalable ETL pipelines, validation checks, and clinical data models
• Develop and maintain high-quality data workflows using SQL and relevant programming tools such as Python or R
• Assemble and integrate large, complex clinical datasets from multiple structured and semi-structured sources
• Ensure data accuracy, quality, and compliance through validation, monitoring, and testing of outputs
• Maintain and optimize ETL pipeline performance while enforcing data governance, security, and data protection standards
• Support troubleshooting, debugging, and resolution of data pipeline issues in production environments
• Collaborate with cross-functional stakeholders to address data needs and support clinical and analytical use cases
• Develop and support infrastructure for efficient data processing and downstream analytics applications
• Ensure data readiness for reporting, clinical studies, regulatory submissions, and business intelligence use

Requirements:

This role requires deep expertise in clinical data systems, ETL development, and relational database programming within a regulated pharmaceutical or biotech environment.

• Bachelor’s degree in Computer Science, Software Engineering, or related scientific discipline
• 5+ years of experience in ETL data pipeline development and clinical data warehousing
• 5+ years of strong SQL and relational database experience
• 2+ years of experience working within SDLC environments
• 3+ years of experience with clinical trial data in pharmaceutical or biotechnology settings
• Experience with APIs and integration of clinical or enterprise data systems
• Strong understanding of clinical data standards such as CDISC SDTM, SDTMIG, and CDASH (preferred)
• Hands-on experience with Oracle clinical data platforms such as LSH, DMW, CDA, and ODI
• Experience with BI tools such as OBIEE, Spotfire, or Power BI is a plus
• Proficiency in programming languages such as Python, SAS, or JavaScript is highly desirable
• Strong analytical, debugging, and problem-solving skills in complex data environments
• Ability to collaborate effectively with technical and non-technical stakeholders across clinical and IT functions

Benefits:

• Competitive base salary ranging from $125,000 to $165,000 annually
• Eligibility for annual bonus programs and performance-based incentives (role-dependent)
• Equity participation through discretionary stock awards and employee stock purchase plan
• Comprehensive health coverage including medical, dental, and vision insurance
• 401(k) retirement savings plan with additional financial support options (FSA/HSA)
• Paid time off, holidays, and wellness programs
• Flexible benefits package supporting overall health and wellbeing
• Exposure to advanced clinical data systems and enterprise-level life sciences technology
• Collaborative, science-driven environment focused on innovation in clinical research and patient outcomes

How Jobgether works:

We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team.

We appreciate your interest and wish you the best!

Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.

#LI-CL1

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.