Optimizing business performance through people, data, tech & analytics
Lead Data Engineer
Location
Chile
Posted
4 days ago
Salary
0
Seniority
Senior
Job Description
Lead Data Engineer
Blend360
• 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.
Job Requirements
- 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.
- English: Advanced (required 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 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.
- Other benefits may vary according to your location in LATAM.
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
• 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.
• Design and evolve data platforms using Lakehouse architecture • Develop scalable pipelines • Define architecture, governance, and performance standards with Databricks, Delta Lake, and PySpark • Implement solutions on Databricks and Delta Lake • Support technical teams and document solutions
• Design, build, and operate modern, end-to-end, cloud-native data warehouses • Develop and maintain robust ELT/ETL pipelines that integrate multiple internal systems (servicing, origination, CRM) and third-party data feeds • Create scalable data models for reporting, BI (semantic layer), and future AI/ML initiatives • Implement data quality, governance, and security practices aligned with stringent U.S. financial regulations • Work closely with C-suite stakeholders and directors in the U.S. to translate business requirements into technical data architecture • Optimize the performance of queries, pipelines, and workflows to ensure efficiency and cost control
• Lead client discovery sessions to gather business and technical requirements, define project scope, and manage stakeholder expectations throughout engagements. • Provide strategic guidance on Adobe Experience Platform adoption, enterprise data strategy, and solution architecture. • Partner with clients to assess data maturity and recommend scalable architecture solutions aligned with business objectives. • Serve as a trusted advisor by translating complex technical concepts into actionable recommendations for both technical and non-technical stakeholders. • Review and validate enterprise data architectures, XDM schema designs, identity resolution strategies, activation plans, and technical specifications. • Provide recommendations across the entire data lifecycle, including data ingestion, ETL/ELT processes, transformation, governance, quality, archival, and lifecycle management. • Guide customer identity mapping and Customer 360 initiatives through effective SQL and NoSQL data modeling strategies. • Promote enterprise data governance standards and repeatable best practices across Adobe Experience Platform implementations. • Review technical design documents and architecture specifications to ensure alignment with Adobe best practices and enterprise standards. • Mentor Data Architects and cross-functional engineering teams by providing architectural oversight and technical leadership. • Collaborate with software engineering consultants, data scientists, and delivery teams to guide scalable data workflows and machine learning operationalization. • Act as the senior data architecture advisor across multiple client engagements, ensuring technical excellence throughout project delivery. • Successfully manage multiple client engagements while balancing competing priorities and maintaining project governance. • Contribute reusable templates, playbooks, frameworks, and Center of Excellence initiatives that strengthen the Adobe consulting practice. • Develop client-facing documentation, presentations, architecture recommendations, and implementation guidance. • Maintain accurate project documentation, workload estimates, and project tracking throughout engagements. • Stay current on Adobe Experience Platform capabilities, Azure cloud technologies, and emerging enterprise data architecture trends. • Identify opportunities to improve delivery methodologies and recommend innovative solutions that address evolving client needs. • Continuously expand technical expertise while contributing knowledge and best practices across the consulting organization.



