Analyst - Commercial Analytics

Wesco; Pittsburgh (Allegheny County); On-site; USD 66,000 - 86,000; Full time

Benefits offered by this job

Bonus or sales incentive plan

Retirement savings plan

Medical, dental and vision coverage

Paid time off

Job summary

Wesco is seeking an Analyst - Commercial Analytics in Pittsburgh to deliver end‑to‑end reporting, from requirements gathering and data extraction to deriving insights for sales, margin, and inventory analytics. You will build dashboards and support decision makers with market and customer insights.

The role requires 2 years of data analysis experience, SQL/database familiarity, and strong Excel skills. A BA/BS in a relevant field is preferred; this is a data‑driven, cross‑functional position

Qualifications

• 2 years required of analyzing data to identify insights.
• 1 year required of working with relational database (ex: AWS, Teradata, MS SQL Server, Azure, MS Access, etc.)
• 1 year preferred of working with B2B selling environments
• Proficiency in mathematical calculations and concepts (algebra, geometry) required
• Proficiency in Microsoft Office Products – highly proficient in Excel required
• Critical thinking – demonstrated ability to turn data into information into insight required
• Demonstrated ability to communicate complex information in a straightforward manner using precise language, especially to non‑technical audiences required
• Familiarity with statistical/probabilistic calculations and concepts required; proficiency preferred
• Familiarity with SQL or other data‑oriented programming languages required; proficiency preferred
• Familiarity with data science concepts preferred

Responsibilities

• Execute regular and ad‑hoc reports in support of commercial teams.
• Design & build data visualizations, reports and dashboards in team BI tools to be shared with internal audiences.
• Analyze customer and company data to identify trends and potential opportunities, and measure achievement toward goals, for Wesco’s customers, suppliers, operating businesses and internal functions.
• Conduct research to support business decision making, with emphasis in sales and marketing activities.
• Collect, enter and maintain data pertaining to business performance, customer behavior, market intelligence and/or competitive intelligence.
• Support commercial and cross‑functional project teams with data, analysis, information and insights.
• Collaborate with other analysts on reporting or analysis projects.

Skills

Data analysis

Excel proficiency

SQL knowledge

Communication of complex data

Statistical concepts

Education

Bachelor’s degree in Finance/Statistics/IS/Marketing/Mathematics

High School Degree or equivalent

Tools

SQL

AWS

Teradata

MS SQL Server

Azure

MS Access

Job description

As a Analyst - Commercial Analytics you will be responsible for providing reports and analytical support around internal systems data (sales & margin, purchases, inventory, etc.) and helping to drive business measurement and opportunity identification in commercial functions. You will complete reporting projects end-to‑end by gathering requirements, designing solutions, extracting data and deriving insights. Works cross-functionally and cross‑organizationally to ensure reporting quality and consistency in reporting activities in internal systems as well as delivering external data collection and market, customer and competitor insights for leaders and decision makers.

As a Analyst - Commercial Analytics you will be responsible for providing reports and analytical support around internal systems data (sales & margin, purchases, inventory, etc.) and helping to drive business measurement and opportunity identification in commercial functions. You will complete reporting projects end‑to‑end by gathering requirements, designing solutions, extracting data and deriving insights. Works cross‑functionally and cross‑organizationally to ensure reporting quality and consistency in reporting activities in internal systems as well as delivering external data collection and market, customer and competitor insights for leaders and decision makers.

Responsibilities

• Execute regular and ad‑hoc reports in support of commercial teams.
• Design & build data visualizations, reports and dashboards in team BI tools to be shared with internal audiences.
• Analyze customer and company data to identify trends and potential opportunities, and measure achievement toward goals, for WESCO’s customers, suppliers, operating businesses and internal functions.
• Conduct research to support business decision making, with emphasis in sales and marketing activities.
• Collect, enter and maintain data pertaining to business performance, customer behavior, market intelligence and/or competitive intelligence.
• Support commercial and cross‑functional project teams with data, analysis, information and insights.
• Collaborate with other analysts on reporting or analysis projects.

Qualifications::

• High School Degree or equivalent experience required. Bachelor’s degree in Finance, Statistics, Information Systems, Marketing, or Mathematics preferred.
• 2 years required of analyzing data to identify insights
• 1 years required of working with relational database (ex: AWS, Teradata, MS SQL Server, Azure, MS Access, etc.)
• 1 years preferred of working with business‑to‑business (B2B) selling environments
• Proficiency in mathematical calculations and concepts (algebra, geometry) required
• Proficiency in Microsoft Office Products – highly proficient in Excel required
• Critical thinking – demonstrated ability to turn data into information into insight required
• Demonstrated ability to communicate complex information in a straightforward manner using precise language, especially to non‑technical audiences required
• Familiarity with statistical/probabilistic calculations and concepts required; proficiency preferred
• Familiarity with SQL or other data‑oriented programming languages required; proficiency preferred
• Familiarity with data science concepts preferred

Compensation Details: $66,477 - $86,420 Annually

This amount is what we reasonably believe we will pay for the position; however, offer amounts may vary based on factors such as geographic location, relevant education, experience, qualifications, skills, shift, or any collective bargaining agreements.

For eligible positions, compensation may include participation in a bonus or sales incentive plan, subject to the terms and conditions of the applicable plan documents. For certain sales roles, Wesco also offers a commission structure that provides additional compensation based on sales results, as defined by the applicable commission plan.

In addition, Wesco offers a benefits program for eligible employees, which may include paid time off, medical, dental, and vision coverage, and retirement savings plans. Additional details about benefits are available here .

About The Team

At Wesco, we build, connect, power and protect the world. As a leading provider of business‑to‑business distribution, logistics services and supply chain solutions, we create a world that you can depend on.

Our Company’s greatest asset is our people. Wesco is committed to fostering a workplace where every individual is respected, valued, and empowered to succeed. We promote a culture that is grounded in teamwork and respect. With a workforce of over 20,000 people worldwide, we embrace the unique perspectives each person brings. Through comprehensive benefits and active community engagement, we create an environment where every team member has the opportunity to thrive.

Founded in 1922 and headquartered in Pittsburgh, Wesco is a publicly traded (NYSE: WCC) FORTUNE 500® company.

Wesco International, Inc., including its subsidiaries and affiliates (“Wesco”) provides equal employment opportunities to all employees and applicants for employment. Employment decisions are made without regard to race, religion, color, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, or other characteristics protected by law. US applicants only, we are an Equal Opportunity Employer.

Los Angeles Unincorporated County Candidates Only: Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act.

This posting is for a current, active vacancy intended for immediate hire.