Senior Commercial Data & Insights Analyst

Ecolab, Inc.; King of Prussia (PA); On-site; USD 86,000 - 129,000; Full time

Job summary

Ecolab, Inc. is seeking a Senior Commercial Data Analyst to strengthen our analytical capabilities in the commercial area.

This hands-on role leads data and reporting processes at the intersection of Sales, Commercial Finance and IT, translating needs into scalable dashboards and insights. You will partner with Sales and Finance to define KPIs, develop reporting logic, and build dashboards using Power BI or similar tools.

Qualifications

• Bachelor’s degree or equivalent experience.
• 5 years in commercial analytics, sales analytics, BI, commercial finance, revenue operations or a related field.
• Strong SQL and advanced Excel capabilities.
• Hands-on experience with Power BI, Tableau or a comparable BI platform.
• Experience translating business requirements into reports, dashboards or analytical solutions.
• Strong analytical and problem-solving ability, including data validation and reconciliation.
• Understanding of commercial measures such as revenue, margin, pricing, customers and products.
• Ability to communicate effectively with both business and technical stakeholders.
• Demonstrated self-direction and ownership of projects from initial question through implemented result.
• Immigration sponsorship not available for this role.

Responsibilities

• Lead assigned commercial data and reporting processes from business requirement through delivery and adoption.
• Partner with Sales and Commercial Finance to define KPIs, reporting requirements and analytical priorities.
• Translate business needs into data specifications, reporting logic, user stories and acceptance criteria.
• Develop and maintain dashboards, scorecards and recurring reporting using Power BI or comparable tools.
• Analyze revenue, volume, pricing, margin, customer, product and market performance data.
• Identify trends, risks, performance drivers and opportunities to support commercial growth.
• Reconcile data across commercial, financial and operational sources and coordinate resolution of discrepancies.
• Maintain documentation covering business definitions, mappings, reporting logic, data sources and process ownership.
• Identify opportunities to automate manual reporting and improve scalability.
• Partner with IT and data teams on source-system changes, integrations, data models and technical delivery.
• Support testing, user training and adoption of new reporting solutions.
• Present clear recommendations to business stakeholders and leadership.

Skills

SQL

Excel

Power BI

Tableau

Communication

Analytical thinking

Stakeholder communication

Data validation

Education

Bachelor’s degree or equivalent

Tools

Salesforce

SAP

Snowflake

Power Query

Alteryx

Python

Job description

Ecolab, Inc. is seeking a Senior Commercial Data Analyst to strengthen our analytical capabilities in the commercial area.

This hands-on role leads data and reporting processes at the intersection of Sales, Commercial Finance and IT, translating needs into scalable dashboards and insights. You will partner with Sales and Finance to define KPIs, develop reporting logic, and build dashboards using Power BI or similar tools.