Commercial Data Analyst

Role Description

Usalco is the essential catalyst for clean water — and our commercial team is on the front lines of that mission every day. As our Commercial Data Analyst, you will serve as the connective tissue between our ERP system, Salesforce CRM, and the commercial decisions that drive our business forward. The Commercial Data Analyst generates insights and reports for sales and account management teams to make confident decisions.

Key Responsibilities

• Reporting & Data Operations
  • Own the commercial reporting layer — pipeline, win/loss trends, customer service metrics, revenue by customer, segment, region, and product.
  • Reconcile self-reported new and lost business entries in Salesforce against ERP actuals to improve data integrity and accuracy.
  • Build and maintain dashboards in Salesforce and/or Power BI that support daily decision-making for the commercial team.
  • Define and audit commercial KPIs; assess customer segmentation to identify and target high-value accounts.
  • Maintain customer master data segmentation fields and work with sales to update gaps.
  • Identify root causes of master data quality gaps across the ERP and Salesforce, and work with IT and operations to resolve them.
  • Deliver regular commercial performance summaries to commercial leadership with clear, actionable takeaways.
• Commercial Strategy & Initiative Support
  • Partner with commercial teams to support and track execution of key commercial initiatives — not just own reporting, but drive accountability and visibility into progress.
  • Partner with commercial operations on bid optimization and margin defense; support bids and contract reviews by the Senior Leadership Team under existing Delegation of Authority.
  • Support pricing analysis, territory performance reviews, and customer growth and churn reporting.
• Intelligence & Advanced Analytics
  • Leverage best-in-class AI tools to surface deeper commercial insights and accelerate analysis — including predictive modeling and anomaly detection.
  • Build a predictive analytics and early warning operating system that enables the commercial team to act on leading indicators, not just lagging results.
  • Track and analyze market intelligence and key industry trends at a regional and local level to inform commercial strategy and competitive positioning.

Qualifications

• Required
  • 4 – 6 years of experience in a commercial, sales operations, or business analyst role.
  • Hands-on Salesforce experience — reports, dashboards, and data hygiene — is a must.
  • Advanced Excel proficiency; Power Query experience preferred.
  • Demonstrated ability to identify and flag data quality issues before they surface in reporting.
  • Strong communication skills — able to translate data findings into plain-language business insights.
• Preferred
  • Experience in specialty chemicals, water treatment, distribution, or industrial manufacturing.
  • Proficiency in SQL or Power BI.
  • Familiarity with ERP systems and ERP-to-CRM data flows.
  • Salesforce Administrator certification or equivalent experience.

Performance Expectations

• In the first 90 days, you will have mapped the current state of commercial reporting, identified the top five data quality gaps, and delivered at least one new dashboard that the commercial team uses daily.
• Within six months, the commercial team will spend meaningfully less time on self-built analysis and more time acting on insights.

Company Description

USALCO is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected veteran status, age, or any other characteristic protected by law. As a general policy, USALCO does not offer employment visa sponsorships upon hire or in the future.