• Responsible for understanding, preparing, transforming, loading, and validating data migrated from the legacy system to the new model. • Map entities, fields, and relationships of the current model, including user, subscription, dependent, and payment where applicable to the scope. • Perform AS IS → TO BE mapping, identifying gaps, inconsistencies, duplicates, and required rules for the new data model. • Define and execute processes for extraction, cleansing, normalization, transformation, and loading of legacy Filó data. • Create import scripts, integrity controls, execution logs, volume validations, and data reconciliation. • Support modeling of the partner, company, beneficiary, dependents, offers, and subscriptions hierarchy. • Participate in cutover strategy, data freeze, migration window, and rollback planning.

• Define and implement Artificial Intelligence solutions applied to data modernization and legacy systems. • Develop mechanisms for analyzing, interpreting, and extracting technical information from legacy artifacts. • Build Generative AI–based solutions to accelerate documentation, transformation, and migration processes. • Create intermediate metadata models to represent flows, business rules, dependencies, entities, and transformations. • Develop accelerators and reusable components aligned with the enterprise data architecture. • Support the definition of templates, technical standards, and declarative structures for modern pipelines. • Develop and evolve pipelines using Databricks, PySpark, Lakeflow Jobs, and Declarative Pipelines. • Work with batch loads, incremental ingestions, CDC (Change Data Capture), and enterprise integrations. • Support the advancement of data governance, traceability, and data quality during migration. • Collaborate with architects, data engineers, and platform specialists to define scalable and secure solutions.

• Develop, design, and implement data warehousing solutions. • Collaborate with stakeholders to gather requirements • Perform data analysis and reporting to support decision-making. • Ensure data integrity and quality in data solutions.

Role Description As a Senior Lead Clinical Data Science Programmer at ICON, you will be instrumental in leading the development and implementation of advanced data science solutions for clinical trials. - Manage day-to-day clinical data science activities, supporting your team to deliver quality outcomes. - Lead the development of Data Transfer Specifications (DTS) documents to align external data providers and research partners on the required structure for new data, including: - Authoring the DTS and responding to external data providers and internal stakeholder queries to ensure data will be delivered in the correct format and structure. - Track DTS status with external data providers across different data types and programs and ensure data completion dates are met for study timelines and deliverables. - Ensure data structure based on the type(s) of data being used is consistent and compliant with appropriate data templates. - Ensure data structure is consistent across each data provider and complies with appropriate data templates. - Support data reconciliation and data structure inquiry resolution. - Liaise cross-functionally to facilitate the creation of new test codes. - Participate in the Clinical Study Team as an extended team member. - Oversee and train in the use of the DTS and other supplemental documents. - Contribute to improvement initiatives as it relates to external data process. - Ensure study teams adhere to CDISC standards as it relates to external data. - Comply with all pertinent regulatory agency requirements (Understand clinical protocols and requirements for Biomarkers/Imaging/eCOA data, blinding and analysis expectations). - Process change requests to update existing DTS. - Improve templates for existing DTS to ensure data harmonization and downstream analytics. - Provide external data management oversight to vendors, providing a pathway for functional discussions, partnership level processes & standards, portfolio status, communication, and escalation. - Review and contribute to eCRF and EDC builds as it relates to external data requirements. Qualifications - Expertise in biomarker data types and/or Imaging data for oncology and non-oncology studies is preferred. - Experience working with multiple data types/formats. - Experience in managing clinical, biomarker data, eCOA, and imaging data. - Demonstrates broad knowledge of all applicable regulations including 21 CFR Part 11, ICH-GCP Guidelines, and CDISC standards for data collections. - Demonstrates advanced knowledge of Data Management processes and industry best practices. - Advanced knowledge and experience with extracting data into SAS, CSV, and XML formats is required. Requirements - Employment with ICON is contingent upon having the legal right to work in the country where the role is based. Benefits - Competitive base salary and performance-related incentives. - Health and wellbeing programmes including medical, dental, and vision coverage where applicable. - Retirement and pension plans. - Life assurance and disability coverage. - Employee assistance programmes and wellbeing resources. - Learning and development opportunities through structured training and career pathways. - Benefits may vary depending on role and location. Company Description ICON is a global healthcare intelligence and clinical research organisation united by a mission to bring new medicines and treatments to patients faster. As a values-driven organisation, integrity, collaboration, agility, and inclusion are at the heart of how we work and interact with each other, customers, patients, and suppliers.