Senior Azure Data Migration Engineer

This is a fully remote position, open to applicants in Mexico.

📋 Description

• Design, develop, and execute migration pipelines using Azure Data Factory, including Linked Services, Copy Activities, parameterization, and automated triggers.

• Analyze, troubleshoot, and redesign complex data mapping matrices.

• Design and implement staging structures in Azure SQL to prepare, transform, and cleanse data.

• Develop stored procedures and T-SQL queries for complex transformations, type conversions, null value handling, and selection list translations.

• Execute large-scale data extraction and migration from Salesforce to Microsoft Dynamics 365/Dataverse.

• Perform high-performance loads using Dataverse Web API, Upsert operations, Alternate Keys, and Batch Requests.

• Manage the migration of accounts, contacts, notes, attachments, and knowledge base articles.

• Generate reconciliation reports to validate source records against destination, identify errors, manage retries, and document results.

• Apply governance rules and resolve conflicts among different information 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.

⛳️ Requirements

• Bachelor's degree or Engineering in Systems, Computer Science, Information Technology, or a related field.

• At least 5 years of experience in Data Engineering, ETL/ELT development, data integration, or corporate data migration.

• Advanced experience with Microsoft Azure, primarily Azure Data Factory, Azure SQL Database, and Azure DevOps.

• Experience in data migration projects to Microsoft Dynamics 365 and Dataverse.

• In-depth 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 using APIs.

• Advanced proficiency in SQL/T-SQL for developing complex queries, stored procedures, and transformation processes.

• Experience in mapping and transforming large volumes of data and complex structures with over 400 attributes per entity.

• Advanced/Fluent English (C1-C2) is essential for daily communication with international clients.

• Must have personal computing equipment.

• Ability to work from Mexico.

🏝️ Benefits

• Does not include benefits.

• Remote work modality.

• Temporary project for 6 months.