Lead Data Engineer

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., 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.

• 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

Estimated Pay Range:

Exact compensation and offers of employment are dependent on circumstances of each case and will be determined based on job-related knowledge, skills, experience, licenses or certifications, and location.

Our Commitment to Diversity & Inclusion

At Milestone we strive to create a workplace that reflects the communities we serve and work with, where we all feel empowered to bring our full, authentic selves to work. We know creating a diverse and inclusive culture that champions equity and belonging is not only the right thing to do for our employees but is also critical to our continued success.

Milestone Technologies provides equal employment opportunity for all applicants and employees. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, gender, gender identity, marital status, age, disability, veteran status, sexual orientation, national origin, or any other category protected by applicable federal and state law, or local ordinance. Milestone also makes reasonable accommodations for disabled applicants and employees.

We welcome the unique background, culture, experiences, knowledge, innovation, self-expression and perspectives you can bring to our global community. Our recruitment team is looking forward to meeting you.

Milestone Technologies is a global IT managed services firm that partners with organizations to scale their technology, infrastructure and services to drive specific business outcomes such as digital transformation, innovation, and operational agility. Milestone is focused on building an employee-first, performance-based culture and for over 25 years, we have a demonstrated history of supporting category-defining enterprise clients that are growing ahead of the market. The company specializes in providing solutions across Application Services and Consulting, Digital Product Engineering, Digital Workplace Services, Private Cloud Services, AI/Automation, and ServiceNow. Milestone culture is built to provide a collaborative, inclusive environment that supports employees and empowers them to reach their full potential.

Our seasoned professionals deliver services based on Milestone’s best practices and service delivery framework. By leveraging our vast knowledge base to execute initiatives, we deliver both short-term and long-term value to our clients and apply continuous service improvement to deliver transformational benefits to IT. With Intelligent Automation, Milestone helps businesses further accelerate their IT transformation. The result is a sharper focus on business objectives and a dramatic improvement in employee productivity. Through our key technology partnerships and our people-first approach, Milestone continues to deliver industry-leading innovation to our clients. With more than 3,000 employees serving over 200 companies worldwide, we are following our mission of revolutionizing the way IT is deployed.