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.
What you will do
- 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 explicit 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 automa
📌 Sr Project Engineer (Pune)
🏢 Ecolab
📍 Pune