Lead Data Engineer – Migration & Integration

Role Overview

• Lead the technical execution of the migration from Oracle and Boomi to Azure SQL and Azure Data Factory.
• Guide architecture and design decisions across database migration, ETL migration, integration, validation, and deployment activities.
• Serve as the main technical point of contact with the client.
• Translate client requirements, priorities, and constraints into actionable technical direction for the team.
• Coordinate the work of the database migration and ETL / ADF engineers.
• Review and validate technical designs, source-to-target mappings, migration approaches, and implementation plans.
• Provide hands-on technical guidance and troubleshooting support when needed.
• Help resolve complex issues related to data conversion, pipeline design, performance, compatibility, validation, and reconciliation.
• Track project timeline, deliverables, dependencies, risks, and open decisions.
• Ensure the team is aligned on priorities, scope, quality expectations, and delivery commitments.
• Communicate project status, risks, blockers, and key decisions to client stakeholders and internal leadership.
• Support planning for testing, production cutover, rollback considerations, and post-migration stabilization.
• Ensure technical documentation is created and maintained throughout the engagement.
• Promote best practices for data migration, ETL design, security, performance, monitoring, and maintainability.

Requirements

• Strong experience leading data migration, ETL, or data platform modernization projects.
• Solid understanding of relational databases, data modeling, SQL development, and data validation.
• Experience with Oracle, SQL Server, and/or Azure SQL.
• Experience with ETL / integration platforms such as Boomi, Azure Data Factory, SSIS, Informatica, Talend, MuleSoft, or similar tools.
• Ability to guide technical architecture and design decisions across database and integration workstreams.
• Strong understanding of source-to-target mapping, data profiling, migration planning, reconciliation, and cutover activities.
• Ability to provide technical support to engineers and help resolve design, development, performance, and data quality issues.
• Experience managing project timelines, deliverables, dependencies, risks, and technical decisions.
• Strong client-facing communication skills.
• Ability to coordinate with business stakeholders, architects, developers, QA resources, and project leadership.
• Strong documentation skills, including technical decisions, risks, action items, and status updates.

Tech Stack

• Azure
• ETL
• Informatica
• Oracle
• SQL
• SSIS

Benefits

• Monetary compensation
• Year-end Bonus
• IMSS, AFORE, INFONAVIT
• Major Medical Expenses Insurance
• Life Insurance
• Funeral Expenses Coverage
• TDU Membership
• MediAccess
• Health Check-Up Subsidy
• Preferential rates for car insurance
• Vacations
• Official Mexican Holidays
• Life Happens Days
• Bereavement Leave
• Civil Marriage Leave
• English Classes
• Certifications
• Educational Agreements (Talisis, U-ERRE, UNID, TecMilenio, Tec de Monterrey, UDEM, SPIS)
• Corporate Agreements & Discounts (Sorteos Tec, Envia Flores, TopGolf)
• Taquitos Rewards
• Birthday Bonus
• Work-from-home Bonus
• Laptop Policy