Lead Data Engineer

Blend 360; Región Centro; Hybrid; MXN 900,000 - 1,300,000; Full time

Benefits offered by this job

Learning opportunities

Travel opportunities

Mentoring and development

Flexible working options

Statutory benefits

Job summary

Blend 360 in Mexico seeks a senior Data Engineer to lead gap analysis across 80+ ERP systems, design standardized ETL pipelines for Microsoft Fabric, and build data quality frameworks.

You will mentor teammates, document data lineage, collaborate with stakeholders, and optimize data models to enable AI-ready analytics. English proficiency is required; 5+ years in Data Engineering; the role offers flexible work options and opportunities to travel for industry conferences.

Qualifications

• 5+ years of experience in Data Engineering with expertise in data modeling and ETL development.
• Advanced SQL for complex transformations and performance tuning.
• Strong Python for automation and ETL orchestration.
• Experience with enterprise ERP systems and large-scale data integration.
• Solid knowledge of Azure ecosystem and Microsoft Fabric for data engineering.
• Knowledge of data modeling principles for AI/analytics use cases.
• Experience with data quality assessment and data profiling techniques.
• Excellent problem-solving and collaboration skills.

Responsibilities

• Conduct gap analysis and data mapping across ERP systems to identify integration challenges.
• Design and implement standardized ETL pipelines and data transformations for migrating data to Microsoft Fabric.
• Build data quality frameworks and validation rules for AI/analytics readiness.
• Lead hands-on implementation of ETL standards and automation scripts for multi-source integrations.
• Develop and optimize data models to support unified, AI-ready architecture.
• Lead pilot implementations and refine standards against real ERP data.
• Mentor team members on ETL development and Fabric-specific practices.
• Collaborate with stakeholders to document data lineage and transformation logic.

Skills

SQL

Python

ETL design

ERP systems

Azure

Microsoft Fabric

Data modeling

Data quality

Problem solving

Communication

Tools

Microsoft Fabric

Azure

Job description

What is this position about?

• Conduct comprehensive gap analysis and data mapping across 80+ ERP systems to identify integration challenges, data inconsistencies, and transformation requirements.
• Design and develop standardized ETL pipelines and data transformation processes for migrating enterprise data into Microsoft Fabric.
• Build robust data quality frameworks and validation rules to ensure data readiness for AI and analytics workloads.
• Lead hands-on implementation of ETL standards and best practices, establishing repeatable patterns and automation scripts for multi-source integrations.
• Develop and optimize data models that support seamless transformation from fragmented ERP sources into a unified, AI-ready data architecture.
• Lead the pilot implementation phase, testing and refining standards against real ERP data before full-scale rollout.
• Mentor and guide team members on ETL development, data transformation techniques, and Fabric-specific engineering practices.
• Collaborate with stakeholders to document data lineage, transformation logic, and integration patterns for knowledge transfer and governance.
• Troubleshoot data inconsistencies and implement corrective measures to maintain data integrity throughout the pipeline.

• Advanced proficiency in SQL for complex data transformations, query optimization, and performance tuning.
• Strong Python expertise for automation scripting, data pipeline development, and ETL orchestration.
• Demonstrated hands-on experience in designing and implementing ETL solutions across complex, multi-source environments.
• Proven experience with enterprise ERP systems and large-scale data integration scenarios.
• Solid understanding of Azure ecosystem and hands-on experience with Microsoft Fabric for data engineering.
• Strong knowledge of data modeling principles and ability to design schemas that support AI and analytics use cases.
• Experience with data quality assessment, validation frameworks, and data profiling techniques.
• Excellent problem-solving skills with a focus on scalability, maintainability, and performance optimization.
• Strong communication skills and ability to collaborate with technical and business stakeholders.

What about languages?

English: Advanced (required for effective communication with global teams)

How much experience must I have?

5+ years of experience in Data Engineering with demonstrated expertise in data modeling and ETL development.

Our Perks and Benefits:

• Learning Opportunities:
  • Certifications in AWS (we are AWS Partners)
  • Access to AI learning paths to stay up to date with the latest technologies.
  • Study plans, courses, and additional certifications tailored to your role.
  • Access to Udemy Business, offering thousands of courses to boost your technical and soft skills.
  • English lessons to support your professional communication.
• Travel opportunities to attend industry conferences and meet clients.
• Mentoring and Development:
  • Career development plans and mentorship programs to help shape your path.
• Celebrations & Support:
  • Special day rewards to celebrate birthdays, work anniversaries, and other personal milestones.
  • Company-provided equipment.
• Flexible working options to help you strike the right balance.
• Statutory Benefits:
  • Social security coverage (IMSS).
  • Christmas bonus (Aguinaldo) as per Mexican law.
  • Vacation premium (Prima Vacacional).
  • Remote work bonus.
  • Paid leaves as per Federal Labor Law (LFT).
  • Additional benefits as required by Mexican labor regulations.

Other benefits may vary. For detailed information, please consult with one of our recruiters.