Lead Data Engineer – Microsoft Fabric

This is a fully remote position, open to applicants in Chile.

📋 Description

• Perform thorough gap analysis and data mapping across over 80 ERP systems to pinpoint integration issues, data discrepancies, and transformation needs.

• Create and implement standardized ETL pipelines and data transformation workflows for migrating enterprise data into Microsoft Fabric.

• Establish robust data quality frameworks and validation rules to guarantee data readiness for AI and analytics applications.

• Oversee the practical implementation of ETL standards and best practices, developing repeatable patterns and automation scripts for multi-source integrations.

• Design and enhance data models that facilitate seamless transformation from disparate ERP sources into a cohesive, AI-ready data architecture.

• Spearhead the pilot implementation stage, testing and refining standards against actual ERP data prior to a full-scale deployment.

• Mentor and support team members in ETL development, data transformation methodologies, and Fabric-specific engineering practices.

• Collaborate with stakeholders to document data lineage, transformation logic, and integration patterns for knowledge transfer and governance.

• Diagnose data inconsistencies and implement corrective actions to uphold data integrity throughout the pipeline.

⛳️ Requirements

• Advanced proficiency in SQL for intricate data transformations, query optimization, and performance enhancements.

• Strong expertise in Python for automation scripting, data pipeline creation, and ETL orchestration.

• Proven hands-on experience in designing and executing ETL solutions across complex, multi-source environments.

• Demonstrated experience with enterprise ERP systems and large-scale data integration projects.

• Comprehensive understanding of the Azure ecosystem and practical experience with Microsoft Fabric for data engineering.

• Solid grasp of data modeling principles and the ability to design schemas that cater to AI and analytics use cases.

• Experience in data quality evaluation, validation frameworks, and data profiling techniques.

• Exceptional problem-solving abilities with an emphasis on scalability, maintainability, and performance optimization.

• Strong communication skills and the capacity to collaborate with both technical and business stakeholders.

• Proficiency in English: Advanced (essential for effective communication with global teams).

🏝️ Benefits

• 📚 Learning Opportunities: Certifications in AWS (we are AWS Partners), Databricks, and Snowflake.

• Access to AI learning paths to remain current with the latest technologies.

• Study plans, courses, and additional certifications customized for your role.

• Access to Udemy Business, which offers thousands of courses to enhance your technical and soft skills.

• English lessons to bolster your professional communication.

• 👨🏽‍💻 Travel opportunities to participate in industry conferences and meet clients.

• 👩‍🏫 Mentoring and Development: Career development plans and mentorship programs designed to help shape your path.

• 🎁 Celebrations & Support: Special day rewards to commemorate birthdays, work anniversaries, and other personal milestones.

• Company-provided equipment.

• ⚖️ Flexible working options to assist you in achieving the right work-life balance.

• Other benefits may vary depending on your location in LATAM.