Clinical Analytics Platform Developer

We are seeking a Clinical Analytics Platform Developer to support and configure a global life sciences client's clinical analytics ecosystem across three key platforms: Sycamore Clinical Data Warehouse (CDW), Lokavant Spectrum, and Aetion Evidence Platform. This role will combine hands-on data warehouse development with platform configuration, validation, and operational support activities.

The successful candidate will own data model impact analysis, reconciliation logic redesign, and inspection analytics support on Sycamore CDW; deliver validation support and vendor coordination across Lokavant Spectrum; and provide configuration support, validation testing, and mailbox/intake management for the Aetion Evidence Platform. This individual will partner across Clinical Data Management, Biostatistics, Real-World Evidence, Clinical Operations, and Quality functions to deliver scalable, inspection-ready analytics.

Job Responsibilities

Sycamore Clinical Data Warehouse

• Lead user access administration, vendor coordination, license management, dashboard access, and platform monitoring across the Sycamore CDW environment
• Execute metadata and configuration updates and controlled change execution under formal change management procedures
• Perform data model impact analysis for new study onboarding, mid-study changes, and downstream consumer requirements
• Design and redesign reconciliation logic across clinical data sources (EDC, safety, labs, imaging, ePRO) to ensure data integrity and audit traceability
• Build and support inspection analytics - including listings, metrics, KPIs, and visualizations required for regulatory inspections and audits
• Provide validation support including test script authoring, execution support, and documentation

Lokavant Spectrum

• Manage user access administration and vendor coordination for the Lokavant Spectrum platform
• Provide validation support including test script authoring, execution support, and documentation

Aetion Evidence Platform

• Own the intake mailbox for the Aetion Evidence Platform - triaging incoming requests, routing to the right owner, tracking SLAs, and closing the loop with requestors
• Manage user access administration and vendor coordination
• Provide configuration support within agreed-upon standards and execute validation testing activities, including test script authoring, execution, evidence collection, and traceability

Cross-Platform

• Author and maintain configuration standards, work instructions, technical specifications, data lineage documentation, and validation deliverables
• Troubleshoot data pipeline failures, configuration issues, and reconciliation discrepancies; perform root cause analysis and implement durable fixes
• Contribute to continuous improvement initiatives related to platform operations, configuration standards, data quality, and vendor management

• Bachelor's degree required; advanced degree preferred in Computer Science, Information Systems, Statistics, Life Sciences, or a related field
• 5+ years of experience supporting clinical analytics platforms in a regulated life sciences environment, with hands-on development experience on Sycamore Clinical Data Warehouse
• Strong SQL skills and experience with ETL/ELT design, performance tuning, and complex reconciliation logic
• Proven experience designing and modifying clinical data models for trial and program-level analytics
• Hands-on experience building inspection-ready listings and analytics for regulatory submissions and audits
• Configuration experience with Aetion Evidence Platform and/or Lokavant Spectrum strongly preferred
• Demonstrated experience executing computer system validation activities, including test script authoring, execution, and evidence management
• Experience operating an intake/triage mailbox with SLA-driven request management
• Familiarity with clinical data standards (CDISC SDTM, ADaM) and source systems such as Medidata Rave
• Experience executing controlled changes under formal change management and validation processes
• Strong understanding of GxP and 21 CFR Part 11 requirements as applied to clinical analytics platforms
• Experience integrating clinical data with BI/visualization tools (e.g., Spotfire, Tableau, Power BI) preferred
• Cloud data platform experience (AWS, Azure, Snowflake) preferred
• Excellent problem-solving, documentation, vendor coordination, and stakeholder communication skills
• Ability to work fully remote and provide consistent coverage during US Eastern Standard Time (EST) business hours