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 Data Engineer with strong ETL and integration experience to support a migration from different Sources to Azure Data Factory. This role will focus on analyzing existing processes, redesigning and rebuilding data pipelines in ADF, and ensuring that data movement, transformations, scheduling, monitoring, and error handling are successfully migrated to the Azure platform.
The ideal candidate should have hands-on experience designing, developing, and supporting ETL / ELT pipelines, working with enterprise integration platforms, and building reliable data movement processes in Azure Data Factory.
Requirements
- Strong hands-on experience with Azure Data Factory.
- Experience designing, developing, and supporting ETL / ELT pipelines.
- Experience integrating with databases, flat files, APIs, cloud storage, and enterprise applications.
- Strong SQL skills and experience working with relational databases.
- Understanding of pipeline orchestration, dependencies, scheduling, monitoring, retry logic, and error handling.
- Experience with data mapping, transformation logic, data validation, and migration testing.
- Ability to analyze existing integration processes and rebuild them in a new platform.
- Strong troubleshooting, documentation, and communication skills.
- Ability to collaborate with database engineers, QA, architecture, and business teams.
- Experience with CI/CD process.
Responsibilities - Analyze existing integrations, workflows, mappings, transformations, schedules, and dependencies.
- Design and develop data pipelines in Azure Data Factory.
- Connect ADF pipelines to source and target systems, including Oracle, Azure SQL, files, APIs, and other relevant systems.
- Implement pipeline scheduling, parameterization, monitoring, alerting, retry logic, and error handling.
- Collaborate with database migration engineers to ensure pipelines align with migrated Snowflake SQL data structures.
- Support source-to-target mapping, data transformation logic, and technical documentation.
- Perform pipeline testing, data validation, and defect resolution.
- Optimize ADF pipelines for reliability, performance, and maintainability.
- Support deployment, production cutover, and stabilization activities.
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
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
Skills Required
- Hands-on experience with Azure Data Factory
- Designing, developing, and supporting ETL/ELT pipelines
- Integrating with databases, flat files, APIs, cloud storage, and enterprise applications
- Strong SQL skills and experience with relational databases
- Understanding of pipeline orchestration, scheduling, monitoring, retry logic, and error handling
- Experience with data mapping, transformation logic, data validation, and migration testing
- Ability to analyze existing integration processes and rebuild them on a new platform
- Strong troubleshooting, documentation, and communication skills
- Ability to collaborate with database engineers, QA, architecture, and business teams
- Experience with CI/CD processes
- Experience connecting pipelines to Oracle, Azure SQL, files, APIs and aligning with Snowflake SQL structures
What We Do
We are a group of top-notch gurus that bring together years of experience, cutting edge technology skills and cost-effective frameworks into a single place, we fuse them and deliver a sexy and perfectly fitted solution for all of our partners. We guide our clients for preparation and execution of critical projects and sourcing plans to: Minimize risks Drive Innovation Ensure the highest ROI Create value
