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

Similar jobs

More from Milestone Technologies, Inc.
Milestone Technologies, Inc. 1 hour ago
Milestone Technologies, Inc. 1 hour ago
Milestone Technologies, Inc. 1 hour ago

Lead Data Engineer - Data Migration

Apply On Company Site
Back to search page