LEAD DATA ENGINEER (MICROSOFT FABRIC)

<p><strong>What is this position about?</strong></p><ul><li>Conduct comprehensive gap analysis and data mapping across 80+ ERP systems to identify integration challenges, data inconsistencies, and transformation requirements.</li><li>Design and develop standardized ETL pipelines and data transformation processes for migrating enterprise data into Microsoft Fabric.</li><li>Build robust data quality frameworks and validation rules to ensure data readiness for AI and analytics workloads.</li><li>Lead hands-on implementation of ETL standards and best practices, establishing repeatable patterns and automation scripts for multi-source integrations.</li><li>Develop and optimize data models that support seamless transformation from fragmented ERP sources into a unified, AI-ready data architecture.</li><li>Lead the pilot implementation phase, testing and refining standards against real ERP data before full-scale rollout.</li><li>Mentor and guide team members on ETL development, data transformation techniques, and Fabric-specific engineering practices.</li><li>Collaborate with stakeholders to document data lineage, transformation logic, and integration patterns for knowledge transfer and governance.</li><li>Troubleshoot data inconsistencies and implement corrective measures to maintain data integrity throughout the pipeline.</li></ul> <ul><li>Advanced proficiency in SQL for complex data transformations, query optimization, and performance tuning.</li><li>Strong Python expertise for automation scripting, data pipeline development, and ETL orchestration.</li><li>Demonstrated hands-on experience in designing and implementing ETL solutions across complex, multi-source environments.</li><li>Proven experience with enterprise ERP systems and large-scale data integration scenarios.</li><li>Solid understanding of Azure ecosystem and hands-on experience with Microsoft Fabric for data engineering.</li><li>Strong knowledge of data modeling principles and ability to design schemas that support AI and analytics use cases.</li><li>Experience with data quality assessment, validation frameworks, and data profiling techniques.</li><li>Excellent problem-solving skills with a focus on scalability, maintainability, and performance optimization.</li><li>Strong communication skills and ability to collaborate with technical and business stakeholders.</li></ul><p><strong>What about languages?</strong></p><p>English: Advanced (required for effective communication with global teams)</p><p><strong>How much experience must I have?</strong></p><p>5+ years of experience in Data Engineering with demonstrated expertise in data modeling and ETL development.</p> <p><strong>Our Perks and Benefits:</strong></p><p>📚 Learning Opportunities:</p><ul><li>Certifications in AWS (we are AWS Partners), Databricks, and Snowflake.</li><li>Access to AI learning paths to stay up to date with the latest technologies.</li><li>Study plans, courses, and additional certifications tailored to your role.</li><li>Access to Udemy Business, offering thousands of courses to boost your technical and soft skills.</li><li>English lessons to support your professional communication.</li></ul><p>👨🏽‍💻 Travel opportunities to attend industry conferences and meet clients.</p><p>👩‍🏫 Mentoring and Development:</p><ul><li>Career development plans and mentorship programs to help shape your path.</li></ul><p>🎁 Celebrations &amp; Support:</p><ul><li>Special day rewards to celebrate birthdays, work anniversaries, and other personal milestones.</li><li>Company-provided equipment.</li></ul><p>⚖️ Flexible working options to help you strike the right balance.</p><p>🏥 Statutory Benefits:</p><ul><li>Social security coverage (IMSS).</li><li>Christmas bonus (Aguinaldo) as per Mexican law.</li><li>Vacation premium (Prima Vacacional).</li><li>Remote work bonus.</li><li>Paid leaves as per Federal Labor Law (LFT).</li><li>Additional benefits as required by Mexican labor regulations.</li></ul><p>Other benefits may vary. For detailed information, please consult with one of our recruiters.</p><p>So what are the next steps? Our team is eager to learn about you! Send us your resume or LinkedIn profile below and we'll explore working together!</p>