Senior Azure Data Migration Engineer REMOTO (Por proyecto de 6 meses)

Senior Azure Data Migration Engineer

Specialization: Azure Data Factory | Azure SQL | Dynamics 365 | Dataverse

Location: Mexico (100% remote)

Salary: $50,000 to $60,000 MXN net monthly

Contract: 6-month project

English Level: Advanced / Fluent (C1-C2)

Work Mode: Remote (personal computer required)

About the Role

We are seeking a Senior Azure Data Migration Engineer responsible for designing, developing and executing large-scale enterprise data migration projects, primarily from Salesforce to Microsoft Dynamics 365 Customer Service and Dataverse.

You will be responsible for building extraction and loading pipelines using Azure Data Factory (ADF), implementing data transformation and cleaning processes using Azure SQL, and ensuring data integrity, consistency and correct integration into the target platform.

The role requires solid technical experience in complex migrations, autonomy to execute end-to-end solutions, and direct English-language communication with international clients and stakeholders.

Main Responsibilities

• Design, develop and execute migration pipelines using Azure Data Factory (ADF), including Linked Services, Copy Activities, parameterization and automated triggers.
• Analyze, debug and redesign complex data mapping matrices, including sources with more than 400 fields per entity.
• Design and implement staging structures in Azure SQL for data preparation, transformation and cleaning.
• Develop stored procedures and T-SQL queries to perform complex transformations, data type conversion, null value handling and choice list translation.
• Execute large-scale data extraction and migration processes from Salesforce to Microsoft Dynamics 365 / Dataverse.
• Perform high-performance data loads using Dataverse Web API, Upsert operations, Alternate Keys and Batch Requests.
• Manage migration of accounts, contacts, notes, attachments and knowledge base articles.
• Generate reconciliation reports to validate source records against target, identify errors, control retries and document results.
• Apply governance rules and conflict resolution between different data sources.
• Identify, diagnose and resolve errors in pipelines, ETL/ELT processes and data loads.
• Participate in technical meetings and follow-up sessions with international clients, communicating progress, risks and solutions in English.

Essential Requirements

• Bachelor's degree or Engineering in Systems, Computer Science, Computer Science, Information Technology or related field.
• Minimum 5 years of experience in Data Engineering, ETL/ELT development, enterprise data integration or migration.
• Advanced experience in Microsoft Azure, primarily:
• Azure Data Factory (ADF)
• Azure SQL Database
• Azure DevOps
• Experience in data migration projects to Microsoft Dynamics 365 and Dataverse.
• Deep knowledge of the Dataverse data model: entities, relationships, Lookups, Option Sets and Alternate Keys.
• Practical experience using Dataverse Web API for bulk loads, Upsert operations, Batch Requests and error handling.
• Experience extracting information from Salesforce through APIs.
• Advanced SQL / T-SQL proficiency to develop complex queries, stored procedures and transformation processes.
• Experience mapping and transforming large data volumes and complex structures with more than 400 attributes per entity.
• Advanced / fluent English (C1-C2), essential for daily communication with international clients.

Technical Knowledge

• Azure Data Factory (ADF)
• Azure SQL Database
• Microsoft Dynamics 365 Customer Service
• Microsoft Dataverse
• Dataverse Web API
• Salesforce APIs
• ETL / ELT
• T-SQL and Stored Procedures
• Data Mapping and Data Transformation
• Staging Tables
• Data Reconciliation
• Upsert Operations and Alternate Keys
• Batch Requests and API Error Handling
• Azure DevOps

Competencies

• High analytical capacity and problem-solving skills.
• Autonomy and immediate technical execution capability.
• Effective communication with international clients and teams.
• Analytical thinking and attention to detail.
• Results-oriented and commitment to deliverables.
• Capacity to work with large volumes of information.
• Adaptability and agile response to technical incidents.

Employment Terms

• Temporary project for 6 months.
• Fees of $50,000 to $60,000 MXN net monthly.
• Payment scheme via invoice or honorarium receipt.
• No benefits included.
• 100% remote work mode from Mexico.
• Personal computer required.
• Daily English communication with international clients.