Commercial Analytics & Data Management Manager

ECOLAB; King of Prussia (PA); On-site; USD 120,500 - 180,700; Full time

Job summary

ECOLAB is seeking a seasoned data analyst in King of Prussia to manage customer and product data foundations while enabling confident decision-making across pricing and strategy. This pivotal role demands strong SQL and Power BI skills, alongside significant experience in data-oriented roles.

The qualified candidate will possess a Bachelor's degree, with at least 8 years of analytics experience. Responsibilities include maintaining data accuracy, segmenting datasets, and resolving data discrepancies to enhance overall commercial performance.

Qualifications

• 8 years of experience in analytics or data-oriented role.
• 3 years of experience with Power BI.
• 5 years of SQL skills (data extraction, transformation, and validation).

Responsibilities

• Build and maintain consistent customer master structures.
• Design standardized datasets for revenue and margin analysis.
• Identify and resolve discrepancies between operational, financial, and reporting data.

Skills

SQL skills

Power BI

Master Data Management

Data transformation tools (e.g., Alteryx)

Microsoft Office (Excel)

Autonomy

Education

Bachelor's degree in Business, Finance, Analytics, Engineering, or related field

Tools

ThoughtSpot

Alteryx

Job description

The Global Commercial Data & Analytics owns the customer, product, industry and commercial data foundations that underpin net sales, volume, pricing, margin, and performance decisionmaking across the business.

This role ensures leaders operate from a single, consistent, and trusted view of customers, products, and commercial performance across reporting, analytics, and selfservice tools.

This is a highimpact, handson role for someone who enjoys turning complex, fragmented data into clarity. You will directly build, maintain, and evolve the commercial data foundations used by leaders worldwide, enabling more confident decisions on pricing, margin, customers, and product strategy.

Sitting at the intersection of finance, marketing, operations, analytics, and enterprise data initiatives, the role translates business logic into clean, governed, and usable commercial datasets.

What will you do:

Customer & Product Data Foundations

• Build and maintain consistent customer master structures
• Define, document, and manage product hierarchies and classification logic
• Coordinate across teams and stakeholders to route issues, establish ownership, and drive resolution
• Execute higher-risk data corrections, ensuring accuracy, and governance compliance
• Resolve duplicates, inconsistencies, and misalignments across SAP, NHBA, OneStream, and reporting layers
• Enrich commercial datasets with businessrelevant customer and product attributes to support analysis, segmentation, and decisionmaking
• Work closely with the Corporate Customer Master Data team and ensure alignment with enterprise customer and product data standards

Commercial Data Modeling

• Design standardized datasets for:
  • Revenue and margin analysis
  • Pricing and discounting
  • Customer and product segmentation
• Ensure consistent definitions across Power BI, ThoughtSpot, and management reporting

Segmentation & Classification

• Develop and maintain customer, product, and industry segmentation logic
• Apply primarily rulebased approaches, with selective use of clustering where businessrelevant
• Ensure segmentation is applied consistently across dashboards and selfservice analytics

Analytics Enablement

• Build and maintain certified, trusted datasets used across the organization
• Enable business users with stable, wellstructured commercial data
• Act as the owner of the single version of truth for commercial analytics

Data Quality & Reconciliation

• Identify and resolve discrepancies between operational, financial, and reporting data
• Act as the first point of triage when conflicting numbers arise
• Maintain clear documentation of data logic, mappings, and KPI definitions

Minimum Qualifications

• Bachelor's degree in Business, Finance, Analytics, Engineering, or a related field (or equivalent practical experience)
• 8 years of experience in analytics or dataoriented role
• 5 years of SQL skills (data extraction, transformation, and validation)
• 3 years of experience with Power BI
• 3 years of experience Master Data Management experience
• 2 years experience building and enabling self-service analytics in ThoughtSpot or similar platforms
• Immigration sponsorship not available for this role

Preferred Qualifications

• Experience working in manufacturing or industrial companies with complex, ERPdriven data environments (products, customers, geographies, plants, assets, and cost structures)
• Experience using data transformation tools (e.g., Alteryx) to automate data cleaning, validation, and repeatable logic
• Proven ability to influence and coordinate crossfunctional teams without direct authority
• Strong ability to work autonomously, prioritize effectively, exercise judgment, and drive issues to resolution
• Demonstrated comfort working with ambiguity, including nonstandard or highrisk data scenarios
• Advanced proficiency with Microsoft Office, particularly Excel for analysis and reporting
• Strong understanding of business processes and their upstream and downstream data impacts
• Experience working with large, transactional datasets

Experience with ThoughtSpot or similar selfservice analytics platforms

Experience with ThoughtSpot or similar selfservice analytics platforms.

Annual or Hourly Compensation Range

The base salary range for this position is $120,500.00 - $180,700.00. This position is eligible for annual bonus pay based on performance, per plan terms. Many factors are taken into consideration when determining compensation, such as experience, education, training, geography, etc. We comply with all minimum wage and overtime laws.

Benefits

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

Potential Customer Requirements Notice

To meet customer requirements and comply with local or state regulations, applicants for certain customer-facing roles may need to:

• Undergo additional background screens and/or drug/alcohol testing for customer credentialing.
• Be fully vaccinated for COVID-19, including a booster if eligible, unless a religious or medical accommodation is requested by the applicant and approved by Ecolab.

Americans with Disabilities Act (ADA)

Ecolab will provide reasonable accommodation (such as a qualified sign language interpreter or other personal assistance) with our application process upon request as required to comply with applicable laws. If you have a disability and require accommodation assistance in this application process, please visit the Recruiting Support link in the footer of each page of our career website.

Our Commitment to a Culture of Inclusion & Belonging

At Ecolab, we believe the best teams are inclusive. We are on a journey to create a workplace where every associate can grow and achieve their best. We are committed to fair and equal treatment of associates and applicants and recruit, hire, promote, transfer and provide opportunities for advancement based on individual qualifications and job performance. In all matters affecting employment, compensation, benefits, working conditions, and opportunities for advancement, we will not discriminate against any associate or applicant for employment because of race, religion, color, creed, national origin, citizenship status, sex, sexual orientation, gender identity and expressions, genetic information, marital status, age, disability, or status as a covered veteran.

In addition, we are committed to furthering the principles of Equal Employment Opportunity (EEO) through affirmative action (AA).

We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, and the New York City Fair Chance Act.