Data Migration Engineer / Lead

Overview: We are seeking an experienced Data Migration Engineer/Lead to join a high-impact transformation programme involving the integration of Salesforce data with an Azure-based Enterprise Data Warehouse (EDW). You will be responsible for leading the design and execution of data migration activities, including mapping, extraction, transformation, and loading (ETL), while overseeing a team of offshore developers. This role is ideal for professionals who have strong expertise in Salesforce data architecture, Azure cloud, and data migration strategies within enterprise-scale environments. Key Responsibilities: Lead and oversee end-to-end data migration from Salesforce to an Azure-hosted Enterprise Data Warehouse. Conduct detailed analysis and mapping of Salesforce objects and fields to the target EDW schema. Lead technical design discussions to define migration architecture, data flow, transformation logic, and error handling. Collaborate with business and technical stakeholders to gather requirements, identify data sources, and define data quality criteria. Develop and optimize ETL/ELT pipelines using modern data integration tools and Azure services. Provide technical oversight and direction to offshore data engineering teams building extraction and loading components. Ensure data migration adheres to Salesforce platform limitations, governance, and best practices. Define and implement data validation strategies to ensure completeness and accuracy during the migration. Support data cutover activities and post-migration reconciliation. Required Skills & Experience: Proven experience in Salesforce data migration, with deep understanding of Salesforce data model, object relationships, and limitations. Hands-on experience with Enterprise Data Warehouses, preferably on Azure Synapse Analytics, Azure Data Factory, or similar platforms. Strong knowledge of data integration and ETL processes, with experience designing and developing custom data pipelines. Ability to map and translate complex data structures from Salesforce to relational schemas. Solid understanding of cloud-based architectures, data modeling, and migration performance optimization. Demonstrated experience leading teams, especially offshore or distributed data engineers. Experience working in an agile delivery environment. Preferred Qualifications: Salesforce certifications (e.g., Salesforce Data Architect, Platform Developer) Azure certifications (e.g., Azure Data Engineer Associate) Knowledge of Salesforce APIs, SOQL, Azure DevOps, CI/CD pipelines Experience with data quality frameworks and governance policies Working Model: Hybrid working with flexibility—some on-site collaboration may be required depending on project phase. Opportunity to work with a global team in a fast-paced, transformation-focused environment.