Position Summary
Ecolab is seeking an experienced Lead Data Engineer to join the Analytics and Digital Solutions team within Enterprise AI, supporting Global Supply Chain. This hands-on technical leadership role will design, modernize, and operate enterprise data solutions across complex SAP and non-SAP landscapes using Snowflake, dbt, Azure Data Factory, SQL, and Python.
The successful candidate will provide technical direction, establish engineering standards, mentor engineers, and take end-to-end accountability for trusted data products supporting Manufacturing, Planning, Logistics, Procurement, Quality, Finance, self-service analytics, and AI use cases.
Key Responsibilities
Lead End-to-End Data Engineering
- Lead the design, development, testing, deployment, and support of scalable ETL/ELT pipelines and reusable data products.
- Own solutions from source-system analysis and ingestion through transformation, modeling, validation, and consumption.
- Translate complex business requirements into scalable technical designs and implementation plans.
Snowflake, dbt & Data Modeling
- Design and optimize Snowflake solutions using warehouses, databases, schemas, Streams, Tasks, Dynamic Tables, stored procedures, external tables, and role-based access controls.
- Lead development of modular production-grade dbt models, sources, tests, snapshots, macros, documentation, and deployment workflows.
- Build dimensional, Medallion, and reusable data-product models that deliver consistent KPIs and trusted consumption layers.
Data Ingestion & Integration
- Design ingestion solutions using Azure Data Factory, Fivetran, APIs, CDC, and file-based integration patterns.
- Lead integration of SAP, regional ERP, third-party, structured, and semi-structured data into Snowflake.
- Establish patterns for incremental loads, metadata-driven pipelines, reconciliation, restorability, monitoring, and error handling.
Modernization & Engineering Excellence
- Reverse engineer legacy databases, ETL pipelines, stored procedures, applications, and reporting logic to support modernization.
- Champion Git-based version control, CI/CD, automated testing, documentation, peer review, observability, and coding standards.
- Partner with Data Architects to reduce technical debt and create maintainable, scalable, and cost-efficient solutions.
Technical Leadership & AI-Ready Data
- Provide day-to-day technical guidance, conduct solution and code reviews, and mentor Data Engineers and Associate Data Engineers.
- Prepare governed data for semantic models, AI/ML, retrieval-augmented generation, semantic search, and other approved AI applications.
- Collaborate with Product Owners, architects, analysts, Data Scientists, platform teams, and global business stakeholders.
Required Qualifications
- 8+ years of experience in Data Engineering, Analytics Engineering, Data Warehousing, Business Intelligence, or related disciplines, including technical leadership responsibilities.
- Strong hands-on Snowflake expertise covering SQL, warehouses, Streams, Tasks, Dynamic Tables, stored procedures, security/RBAC, and performance optimization.
- Production experience with dbt, Azure Data Factory, advanced SQL, and Python for APIs, automation, validation, and JSON processing.
- Strong knowledge of ETL/ELT, dimensional modeling, Medallion architecture, data warehousing, data quality, metadata, lineage, and governance.
- Experience designing production pipelines with monitoring, logging, error handling, reconciliation, and recovery mechanisms.
- Demonstrated ability to lead technical design, independently solve complex engineering problems, conduct reviews, and mentor engineers.
- Experience with Agile/Scrum delivery and Git-based source control and CI/CD practices.
- Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, Data Analytics, or a related discipline.
Preferred Qualifications
- Experience with Supply Chain domains including Manufacturing, Planning, Procurement, Logistics, Quality, Inventory, or Finance.
- Experience integrating SAP and regional/non-SAP ERP platforms.
- Experience with Fivetran, PySpark, Databricks, Microsoft Fabric, Power BI, Streamlit, Azure App Services, REST APIs, or CDC technologies.
- Experience with enterprise data products, semantic layers, master/reference data, Snowflake Cortex, AI/ML pipelines, or RAG architectures.
- Experience leading legacy modernization or cloud data-platform migration initiatives.