Sr. Data Engineer

Ecolab is looking for a Sr Data Engineer 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.

What You'll Do

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.

Key Responsibilities

• Lead data initiatives: Serve as a liaison among stakeholders to analyze and define data requirements for reporting and business process changes.

• Manage data infrastructure: Proactively manage Snowflake and SQL databases and analytical data models.

• Drive data excellence: Develop, test, and tune semantic models for enterprise reporting, ensuring compliance with IT security requirements.

• Advance data architecture: Lead the adoption of modern data architecture and identify opportunities to solve business problems with state-of-the-art solutions.

• Perform reverse engineering: Analyze and understand existing complex data structures and processes to facilitate migrations, integrations, or improvements.

• Foster best practices: 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.

• Promote Agile methodologies: Champion and follow SCRUM/Agile frameworks.

What You'll Need

• Experience:

  • 6+ years in a data engineering, analytics, or business intelligence role.

  • Proficiency in ETL data engineering, data modelling, master data management, data governance, and end-to-end data lineage documentation.

  • 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).

  • Advanced SQL skills (cursors, triggers, CTEs, procedures, functions, external tables, dynamic tables, security roles) and Python (object-oriented programming, handling JSON/XML).

  • Experience with medallion data architecture framework.

  • At least 2 years of Agile/Scrum project management experience, including data requirements gathering and project ownership.

• Skills: Exceptional analytical and problem-solving abilities.

• Education: A Bachelor’s or Master’s degree in Mathematics, Statistics, Computer Science, Information Technology, or Engineering is preferred.

Bonus Points If You Have

• Experience working in applications within supply chain, especially procurement domain.

• Proven ability to manage and deliver multiple projects simultaneously in a dynamic environment.

• Experience creating, implementing, and continuously improving processes.

• Familiarity with data science areas like time series analysis, forecasting, classification, and regression analysis.

• Experience with ERP systems (SAP preferred).

• Demonstrated ability to collaborate effectively with global cross-functional teams and individuals with varying technical expertise.

• Developed cloud hosted applications.

• Have experience with PySpark (ETL).

• Have experience with source control (GIT).

#lI-eu