The Lead Data Engineer is part of the EDO - focused on Institutional division's Global Business Intelligence & Analytics and is responsible for leading and supporting development of information and reporting systems which create value and insight. This requires in-depth development experience with Ecolab's cloud technologies (Azure, Snowflake, Power BI, ThoughtSpot) in addition to the ability to independently lead multiple complex projects across organizational boundaries and influence others.

This position is based in St. Paul, MN

What You Will Do:

• Work with the EDO and Institutional Divisional BI team and other organizations to define and deliver solutions.
• Understand technology, business processes and opportunities in the context of the technical and business requirements and recommend sustainable solutions to extend the capability of the system.
• Contribute vision and integrate a broad range of ideas regarding business information definitions, processes, and analytics development.
• Demonstrates ability to extensively use data engineering principles, solve complex data flow challenges to integrate, model, and automate data pipelines using Azure and data systems.
• The employee should demonstrate mastering of skills across following data engineering areas: development of data integration pipelines between data systems, data security, ETL and ELT, quality engineering activities and data operation engineering using SSIS & Azure Data Factory.
• Develop tabular data models using visual studio and Power BI datasets by integrating data from different source systems like Azure data lake gen 2, Azure SQL database, share point etc. creating measures, calculated tables/columns through DAX.
• The employee should be able to assist in troubleshooting and problem resolution activities reported through Service Now & DevOps.
• Responsible for program design, coding, testing, deploying, debugging and documentation.
• Devise or modify procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results.
• May act as expert in business or functional area. Formulate/define system scope and objectives.
• Provide work direction for BI projects to other developers by collaborating with Global BI business stakeholders.

Minimum Qualifications:

• Bachelor's DegreeinComputer Science, Mathematics, Econometrics, or similar degree
• Minimum 8 years of experience inbusiness intelligence, technical development, or similar positions
• Minimum 3 years of experience with programming in Microsoft SQL, SQL Server Integration Services (ETL/ELT), SQL Server Analysis Services (Tabular)
• Minimum 3 years of experience working with Microsoft Azure BI Stack (Azure Data Factory, Azure Analysis Service, Azure SQL DB, Data Lake Storage (Gen 2), logic apps, Azure DevOps (CI/CD), Power BI dataset, DAX)
• No immigration sponsorship available for this role

Preferred Qualifications:

• Advanced degree
• Good communication and writing skills.
• Experience translating business requirements into reports, dashboard/scorecards, BI query objects.
• Experience in use of systems and reporting environments such as(but not limited to): Databricks, U-SQL, Python, Data Warehousing, Snowflake, ThoughtSpot, Team Foundation Server.

A trusted partner at nearly three million commercial customer locations, Ecolab is a global sustainability leader offering water, hygiene and infection prevention solutions and services that protect people and the resources vital to life. Building on a century of innovation, our 47,000 associates help deliver comprehensive science-based solutions, data-driven insights and world-class service to advance food safety, maintain clean and safe environments, and optimize water and energy use, and improve operational efficiencies and sustainability for customers in the food, healthcare, hospitality and industrial markets in more than 170 countries around the world.

When you come to work at Ecolab, you get to take on some of the world's most meaningful challenges and have the opportunity to learn and grow, shape your career, make an impact and quickly see the importance of your work.

For more Ecolab news and information, visit . Follow us on Twitter , Facebook at , LinkedIn at or Instagram at

Ecolab strives to provide comprehensive and market-competitive benefits to meet the needs of our associates and their families. to see our benefits.

If you are viewing this posting on a site other than our Ecolab Career website, view our benefits at jobs.ecolab.com/working-here.