Architect

Job Summary We are seeking an experienced MDM Engineer to design build and support data integration pipelines that bring contactHCP Healthcare Professional and siteinvestigator data from Veeva CTMS into the enterprise Master Data Management MDM platform using Microsoft Fabric as the primary integration and data engineering platform. The resource will work closely with onshore data architects MDM stewards and Veeva CTMS businessfunctional teams to ensure clean deduplicated and governed contact master data Responsibilities Design and develop data pipelines in Microsoft Fabric Data Factory pipelines Dataflows Gen2 LakehouseWarehouse Notebooks to extract contact and related reference data from Veeva CTMS via API OData or intermediate staging layers Build and maintain ETLELT workflows to cleanse standardize transform and load contact data into the MDM hub eg Informatica MDM Reltio SAP MDG Profisee or equivalent specify per your stack Implement data quality match merge survivorship and deduplication rules for contactHCP master data in coordination with MDM stewards Develop and manage medallion architecture BronzeSilverGold layers in Microsoft Fabric Lakehouse for staging curating and publishing contact master data Collaborate with Veeva CTMS functionalbusiness analysts to understand source data structures Contacts Sites Investigators Study Roles and map them to MDM target data models Build monitoring logging and reconciliation processes to ensure endtoend data integrity between Veeva CTMS and MDM Support incrementalCDC Change Data Capture based syncs to keep MDM contact records current with Veeva CTMS updates Work with securitycompliance teams to ensure data handling aligns with GxP GDPR and pharma data privacy requirements where applicable Participate in Agile ceremonies sprint planning standups retrospectives and provide regular status updates to onshore leads Prepare technical documentation: data mapping specs pipeline design docs and run books Provide L2L3 support for production data pipelines and troubleshoot data sync issues between Veeva CTMS and MDM