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 Qualifications 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