Lead Data Engineer, Data Migration

About the role

Role Overview We are seeking an experienced Lead Data Engineer to lead the end-to-end data migration initiative from ServiceNow ITSM to Salesforce Agentforce ITSM . The ideal candidate will have deep expertise in enterprise data migration, ETL/ELT frameworks, data architecture, data governance, and cloud-based integration technologies. The Lead Data Engineer will be responsible for designing migration strategies, defining source-to-target mappings, building scalable migration pipelines, ensuring data quality, and collaborating with business, ServiceNow, and Salesforce stakeholders to deliver a seamless transition. Key Responsibilities Data Migration Leadership Lead the design and execution of large-scale ServiceNow to Salesforce Agentforce ITSM data migration programs. Define migration strategy, migration waves, cutover plans, and rollback procedures. Establish data migration standards, frameworks, and best practices. Data Analysis & Mapping Analyze ServiceNow ITSM data structures, including: Incidents Problems Changes Knowledge Articles CMDB Assets Service Catalog Requests & Tasks User and Group Data Design source-to-target mappings for Salesforce Agentforce ITSM objects. Document transformation, enrichment, and data validation rules. ETL/ELT Development Design and develop scalable ETL/ELT pipelines for data extraction, transformation, and loading. Integrate ServiceNow APIs, databases, and exports with Salesforce data ingestion mechanisms. Leverage Salesforce Bulk APIs and data loading frameworks for high-volume data migration. Data Quality & Governance Implement data profiling, cleansing, standardization, and deduplication processes. Develop reconciliation frameworks to ensure data completeness and accuracy. Monitor data validation metrics and address data anomalies proactively. Ensure compliance with enterprise data governance and security policies. Salesforce Agentforce Data Enablement Support migration of service operations data into Salesforce Service Cloud and Agentforce environments. Optimize migrated data for Agentforce AI-driven support workflows and automations. Ensure relationships, hierarchies, and historical records are accurately migrated and maintained. Technical Leadership Provide mentoring and technical guidance to data engineers and migration specialists. Conduct design reviews and code reviews. Collaborate with Salesforce Architects, ServiceNow SMEs, Product Owners, and Business Stakeholders. Testing & Deployment Lead mock migrations, performance testing, UAT support, and production cutovers. Create migration dashboards, monitoring reports, and status communications. Drive issue resolution during deployment and hypercare phases. Required Qualifications Bachelor's or Master's degree in Computer Science, Information Systems, Data Engineering, or related field. 8-10 years of experience in Data Engineering, Data Integration, or Data Migration projects. Minimum 3+ years leading enterprise-scale migration initiatives. Strong experience with ServiceNow and Salesforce ecosystems. Proven experience migrating data across enterprise applications. Required Technical Skills Data Engineering Advanced SQL and data modeling expertise. Strong knowledge of ETL/ELT development patterns. Experience with: Azure Data Factory Informatica Talend SSIS AWS Glue MuleSoft Programming Python SQL Shell Scripting ServiceNow ServiceNow Data Model CMDB Incident, Change, Problem Management Service Catalog ServiceNow APIs and Data Export Frameworks Salesforce Agentforce / Service Cloud Salesforce Data Model Service Cloud Agentforce Salesforce Bulk API Salesforce Data Loader Salesforce Integration Patterns Database Technologies SQL Server Oracle PostgreSQL Snowflake Azure SQL Preferred Qualifications Experience with Salesforce Agentforce implementations. Experience with AI-ready data architecture and knowledge management migration. Experience working in Agile and DevOps environments. Knowledge of Data Governance, MDM, and Metadata Management. Experience with cloud platforms: Microsoft Azure AWS Google Cloud Platform Key Competencies Data Migration Strategy Stakeholder Management Technical Leadership Problem Solving Data Quality Management Architecture & Design Communication & Collaboration Risk Management

What you’ll do

• Lead design and execution of large-scale ServiceNow to Salesforce Agentforce ITSM data migrations
• Define migration strategy, waves, cutover and rollback plans
• Develop scalable ETL/ELT pipelines and integrate ServiceNow APIs with Salesforce Bulk APIs
• Implement data profiling, cleansing, deduplication and reconciliation frameworks
• Ensure data governance, security compliance and data quality throughout migration
• Mentor data engineers, conduct design and code reviews
• Collaborate with Salesforce architects, ServiceNow SMEs, product owners and business stakeholders
• Lead testing, performance validation, UAT support and production cutovers

What you’ll bring

• 8-10 years data engineering or migration experience
• 3+ years leading enterprise-scale migration initiatives
• Strong experience with ServiceNow and Salesforce ecosystems
• Advanced SQL and data modeling expertise
• Proficiency with ETL/ELT tools such as Azure Data Factory, Informatica, Talend, SSIS, AWS Glue, MuleSoft
• Programming in Python, SQL, Shell scripting
• Experience with cloud platforms Azure, AWS, GCP

Skills

Education

Bachelor's or Master's in Computer Science, Information Systems, Data Engineering or related field