Position summary
At Ecolab, we grow by delivering measurable outcomes—helping teams perform at their best while protecting what’s vital. This role builds and sustains an operational “cockpit” that connects engineering activity, operational performance, and basic financials into a clear, trusted set of KPIs and Power BI dashboards. You will translate data into insights, enabling leaders to focus on what matters most, simplify decision-making, and drive consistent execution.
- Collect and structure data: Identify, access, and consolidate data from engineering and business sources (e.g., ERP/finance extracts, timesheets, CMMS/EAM, project tools, spreadsheets), ensuring quality, traceability, and reliable refresh.
- Build scalable reporting models: Create and maintain clean data models and measures (Power Query, DAX) so KPI definitions are consistent, auditable, and reusable.
- Define KPIs that drive action: Partner with engineering, operations, and finance to define and document KPIs across activity levels, performance, and financials (targets, thresholds, and drivers), creating a clear KPI dictionary and “single source of truth.”
- Design the cockpit in Power BI: Build intuitive dashboards and scorecards (executive summary and operational drill-down) with trends, targets, variance to plan, and exception views that help leaders prioritize and remove noise.
- Enable a disciplined reporting cadence: Deliver weekly/monthly performance reporting and automated refresh schedules; provide clear commentary on key movements, exceptions, and required follow-ups.
- Collaborate as One Ecolab: Work cross-functionally to validate logic, resolve data gaps, and align the cockpit to the decisions leaders need to make.
- Strengthen governance and trust: Maintain documentation for KPI definitions, calculation logic, data lineage, and change control to reduce “number debates” and improve decision speed.
- Continuously improve and simplify: Identify opportunities to automate manual reporting, improve data capture, and enhance the cockpit as priorities evolve.
- Bachelor’s degree with 3 to 5 years of experience
- Candidates must be excellent in Power BI and Power Query, Good at MS SQL.
- Hands-on experience building dashboards in Power BI (Power Query, data modeling, DAX measures).
- Strong analytical problem-solving skills; ability to reconcile data, explain variances, and build confidence in the numbers.
- Advanced Excel capability; working knowledge of SQL (or equivalent) for querying and validation.
- Working understanding of engineering and/or operations performance concepts (e.g., throughput, backlog, cycle time, downtime, productivity, utilization) and comfort engaging with technical stakeholders.
- Ability to interpret basic financials (cost categories, budget vs. actuals, forecasts, simple P&L drivers) and connect financial outcomes to operational drivers.
- Clear communication skills—able to translate business questions into KPI definitions and simple, decision-ready visuals.
- Demonstrated ownership, attention to detail, and ability to deliver on a recurring reporting rhythm.
- Experience with modern data platforms (Snowflake data warehouse/lake concepts, ETL/ELT) and/or Azure data services.
- Power BI administration experience (workspaces, deployment, row-level security, governance).
- Exposure to ERP and finance systems; understanding of cost accounting concepts relevant to engineering (e.g., maintenance cost, project cost, capex/opex).
- Experience building executive scorecards and operational drill-down reporting that supports business reviews.
- Lean/Continuous Improvement, reliability, or performance management exposure.
Skills Required
- Degree or advanced degree in an engineering discipline
- 2 to 5 years of experience
Ecolab Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Ecolab and has not been reviewed or approved by Ecolab.
-
Retirement Support — Feedback suggests the company provides strong retirement programs, including a 401(k) with employer matching and a pension, alongside options like an employee stock purchase plan. Offerings such as retiree healthcare benefits and diverse investment choices reinforce long-term financial support.
-
Healthcare Strength — Feedback suggests medical coverage is broad, with HSA plan options and company contributions, prescription benefits, dental and vision, and virtual care and mental health support. Company-paid wellness programs and income protection (short- and long-term disability, life and accident) further strengthen core coverage.
-
Parental & Family Support — Family-focused programs include fertility support, adoption assistance, and paid parental leave, complemented by counseling and resource services. These offerings are positioned as supportive of employee well-being across different life stages.
Ecolab Insights
What We Do
A trusted partner at nearly three million customer locations, Ecolab (ECL) is the global leader in water, hygiene and infection prevention solutions and services. With annual sales of $12 billion and more than 44,000 associates, Ecolab delivers comprehensive solutions, data-driven insights and personalized service to advance food safety, maintain clean and safe environments, 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. For more Ecolab news and information, visit www.ecolab.com, or follow us on twitter.com/ecolab, facebook.com/ecolab or instagram.com/ecolab_inc.
