Sr. Data Engineer

<p>Ecolab is looking for a <b>Sr Data Engineer</b> based in Barcelona, Spain to join the Analytics and Digital Solutions Team in support of Global Supply Chain. If you're a passionate professional seeking growth and a rewarding career, we invite you to apply. This is an excellent opportunity to join a recognized global company offering competitive compensation, benefits, and significant career advancement.</p><p></p><p><b>What You'll Do</b></p><p>As a technical lead, you'll drive continuous improvements in our digital capabilities and advanced analytics. You'll lead the development of new digital products, providing critical insights to solve business challenges. A key part of your role will be enhancing data utilization across the organization through improved processes, governance, and data management. We're looking for someone passionate about building a strong data foundation and adopting modern data architecture for current and future analytical needs.</p><p></p><p><b>Key Responsibilities</b></p><ul><li><p><b>Lead data initiatives:</b> Serve as a liaison among stakeholders to analyze and define data requirements for reporting and business process changes.</p></li><li><p><b>Manage data infrastructure:</b> Proactively manage Snowflake and SQL databases and analytical data models.</p></li><li><p><b>Drive data excellence:</b> Develop, test, and tune semantic models for enterprise reporting, ensuring compliance with IT security requirements.</p></li><li><p><b>Advance data architecture:</b> Lead the adoption of modern data architecture and identify opportunities to solve business problems with state-of-the-art solutions.</p></li><li><p><b>Perform reverse engineering:</b> Analyze and understand existing complex data structures and processes to facilitate migrations, integrations, or improvements.</p></li><li><p><b>Foster best practices:</b> Mentor peers on implementing and improving our data management and governance framework across technologies like Microsoft Power BI, Snowflake, Microsoft Azure, and on-premise data points.</p></li><li><p><b>Promote Agile methodologies:</b> Champion and follow SCRUM/Agile frameworks.</p></li></ul><p></p><p><b>What You'll Need</b></p><ul><li><p><b>Experience:</b></p><ul><li><p>6+ years in a data engineering, analytics, or business intelligence role.</p></li><li><p>Proficiency in ETL data engineering, data modelling, master data management, data governance, and end-to-end data lineage documentation.</p></li><li><p>Strong experience with cloud data warehouses, specifically Snowflake, and the Azure Platform (SQL Server, Logic Apps, App Services, Data Factory, Power BI including pipelines, Lakehouse, and Warehouse).</p></li><li><p>Advanced SQL skills (cursors, triggers, CTEs, procedures, functions, external tables, dynamic tables, security roles) and Python (object-oriented programming, handling JSON/XML).</p></li><li><p>Experience with medallion data architecture framework.</p></li><li><p>At least 2 years of Agile/Scrum project management experience, including data requirements gathering and project ownership.</p></li></ul></li><li><p><b>Skills:</b> Exceptional analytical and problem-solving abilities.</p></li><li><p><b>Education:</b> A Bachelor’s or Master’s degree in Mathematics, Statistics, Computer Science, Information Technology, or Engineering is preferred.</p></li></ul><p></p><p><b>Bonus Points If You Have</b></p><ul><li><p>Experience working in applications within supply chain, especially procurement domain.</p></li><li><p>Proven ability to manage and deliver multiple projects simultaneously in a dynamic environment.</p></li><li><p>Experience creating, implementing, and continuously improving processes.</p></li><li><p>Familiarity with data science areas like time series analysis, forecasting, classification, and regression analysis.</p></li><li><p>Experience with ERP systems (SAP preferred).</p></li><li><p>Demonstrated ability to collaborate effectively with global cross-functional teams and individuals with varying technical expertise.</p></li><li><p>Developed cloud hosted applications.</p></li><li><p>Have experience with PySpark (ETL).</p></li><li><p>Have experience with source control (GIT).</p></li></ul><p></p><p>#lI-eu</p>