Data Integration Lead

Role Overview We are looking for a Senior Consultant to develop reusable extraction and ingestion capabilities connecting the EY Cloud Connector Suite with modern data platforms, replicated databases, data warehouses and document repositories. The role will use native platform connectors where appropriate while adding the orchestration, governance, validation, logging and evidence controls required for reliable enterprise and audit-data acquisition. Key Responsibilities Design and implement reusable cloud data connectors and extraction patterns for Microsoft Fabric, Snowflake, Databricks, Azure Synapse, BigQuery and comparable platforms. Build data workflows for direct platform connections, client data warehouse copies, mirrored or replicated ERP databases, and structured or unstructured document sources. Develop the ERP-independent data warehouse and database-mirroring blueprint with standard configuration, validation, governance and operational controls. Evaluate native platform connectors and integrate them with the EY Cloud Connector Suite through standard APIs, events and configuration contracts. Implement extraction controls including schema capture, row-count reconciliation, source and destination validation, restartability, exception handling and execution traceability. Develop scalable patterns for incremental extraction, change data capture, partitioning, parallel processing, pagination and high-volume data movement. Capture and preserve extraction parameters, schemas, selected objects, run history, technical metadata and evidence required for auditability.