Lead Data Engineer - Migration & Integration

We love technology, and we enjoy what we do. We are always looking for innovation. We have social awareness and try to improve it daily. We make things happen. You can trust us. Our Enrouters are always up for a challenge. We ask questions, and we love to learn.

We pride ourselves on having great benefits and compensations, a fantastic work environment, flexible schedules, and policies that positively impact the balance of work and life outside of it. We care about who you are in the office and as an individual. We get involved, we like to know our people, we want every Enrouter to become part of a great community of highly driven, responsible, respectful, and above all, happy people. We want you to enjoy working with us.

We are looking for a Technical Lead to guide a migration from an on-premises Oracle and Boomi environment to Azure SQL and Azure Data Factory. This role will provide technical leadership across both the database and ETL workstreams, support architecture and design decisions, provide hands-on technical guidance when needed, and ensure the team remains aligned with the project timeline, scope, and deliverables.

The Technical Lead will also serve as the primary point of contact with the client for day-to-day technical coordination, helping translate client requirements into actionable work for the development team while keeping stakeholders informed of progress, risks, dependencies, and decisions.

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

Key responsibilities:

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

• 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
  

Equal employment

Enroute is committed to providing equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training