Senior Analyst - Inventory

Wesco
Miamisburg, OH Full Time
POSTED ON 8/10/2022 CLOSED ON 11/16/2022

What are the responsibilities and job description for the Senior Analyst - Inventory position at Wesco?

The majority of job is focused on inventory analysis and/or execution of strategies and processes to ensure that inventory and service levels are optimized.
  • 3 years required, 5 years preferred of supply chain and distribution industry, and knowledge of industry terminology, concepts, and metric. 
  • 2 years required, 3 years preferred of hands on report design, development and implementation.  
  • 2 years required, 3 years preferred of hands on data mining, decision support, analytics, and Teradata SQL programming. SQL Server or other databases a plus. 
  • Ensures execution of daily, weekly and monthly production reports, including validating report data, maintaining source codes, and making changes.
  • Develops and executes on demand and ad-hoc reports, including modifying report parameters or source code based on specific needs, ability to explain report, and summarizing findings.
  • Provides field support by answering questions on report logic or data, including ability to identify problems and recommend right tools and reports to meet specific needs and requests.
  • Handles report design and development from gathering requirements to writing Teradata SQL, setting up Microsoft Access databases and writing macros in Excel.
  • Gathers and reviews change requests, implements or coordinates implementation of approved changes.
  • Works with other functional departments including data services and information systems to identify problems and enhancement opportunities to perform user acceptance testing and other required tasks
  • Provides data to support purchasing and inventory related analysis to all levels of the organization, including applying queries and data and writing and modifying complex SQL data retrieval to gather information.
  • Translates business questions into quantitative measurable variables, analyzes large and complex data sets and presents findings in appropriate format for various audiences.
  • Manages concurrent requests and meet deadlines.
  • Validates and processes all field requests to handle one time demand/usage adjustments.
  • Maintains approved parent/child relationships, and runs yearly audit of all parent/child settings.
  • Administers in-house automated stock replenishment program (ASR), sets up and maintains branch operations and supplier lines, maintains integrity of quantity breaks and other setting/attributes.
  • Supports in-house ASR program, answer field questions, validates and troubleshoots issues, and works with IT, purchasing teams and customer service to resolve problems and correct impact
  • Handles functional support for purchasing and inventory tools and systems across all organizational levels. Answers questions, validates data, gathers information for IT and other departments
  • Translates business questions into report or analytics requirements and finds solutions based on existing tools and repots, or proposes possible solutions and presents these to management.
  • Handles all centralized maintenance tasks ranging from mass upload of inventory attributes to cost markup and markdown programs.
  • Administers corporate level programs, including limits of purchasing authorities.

Experience:

  • 2 years required, 3 years preferred of proven ability to use advanced functionality of Microsoft Access and Excel for data analysis and report formatting. Statistical software a plus.  

Education:

  • Bachelors’ Degree in Mathematics, Statistics, Operations Research, Computer Science, Engineering, Supply Chain, Logistics or similar quantitative discipline. 
  • APICS, CPFM, CPM preferred.   

Skills:

  • Knowledge of data extraction, data mining and statistical analysis.
  • SQL development skills, ability to write complex SQL queries. Familiarity with Teradata a plus.
  • Solid communication and support skills. Ability to explain complex concepts and analytics to non-technical audience.
  • Strong PC skills, extensive experience with advanced functionality in Microsoft Access (VBA coding) and Excel (macros, pivot tables, data lookups, etc.)
  • Attention to details, passion for problem-solving, creative thinking and comfort with ambiguity of requirements and expected results.
  • Ability to work independently, check your results, troubleshoot problems and exercise judgment.
  • Excellent multi-tasking skills, ability to prioritize and handle many projects at once with ever shifting priorities and deadlines.
  • Ability to follow established processes and schedule to deliver timely and consistent report execution.
  • Strong verbal and written communication skills
  • Knowledge of distribution industry and supply chain, purchasing and inventory concepts, practices, and procedures.   

Working Environment:

  • General Office – Work is generally performed within an office environment, with standard office equipment. Lighting and temperature are adequate and there are no hazardous or unpleasant conditions caused by noise, dust, etc. 

 

WESCO International, Inc., including its subsidiaries and affiliates ("WESCO"), is an Equal Opportunity and Affirmative Action Employer. It is the policy of WESCO to not discriminate against any job applicant or employee based on age, race, religion, color, handicap, sex, physical condition, disability, sexual orientation, gender identity, national origin, or protected veteran status or any other protected status. This policy includes but is not limited to the following: recruitment and employment, promotion, demotion, transfer, compensation, selection for training including apprenticeship, layoff, or termination. 

Senior Analyst (24-41 Senior Analysts)
Reef Systems -
Dayton, OH
Senior Capabilities Analyst
Apogee Engineering, LLC -
Patterson, OH
Senior Acquisition Support Analyst
Odyssey Systems Consulting Group, Ltd. -
Dayton, OH

For Employer
Looking for Real-time Job Posting Salary Data?
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

Sign up to receive alerts about other jobs with skills like those required for the Senior Analyst - Inventory.

Click the checkbox next to the jobs that you are interested in.

  • BI Analytics/Reporting Tools Skill

    • Income Estimation: $89,313 - $118,123
    • Income Estimation: $96,338 - $126,011
  • Advanced Analytics Skill

    • Income Estimation: $93,329 - $121,905
    • Income Estimation: $92,138 - $124,169
This job has expired.
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Wesco

Wesco
Hired Organization Address Jackson, MS Full Time
As a Senior Representative - Outside Sales, you will be responsible for developing new prospects and interacting with as...
Wesco
Hired Organization Address Morocco, IN Full Time
As a Senior Accountant you will maintain financial records and ensures that financial transactions are properly recorded...
Wesco
Hired Organization Address Butte, MT Full Time
As a Specialist - Strategic Accounts, you will support strategic customer relationships that are part of significant, lo...
Wesco
Hired Organization Address Salt Lake, UT Full Time
As a Senior Administrator - Customer Care you will be responsible for completing administrative daily tasks for assigned...

Not the job you're looking for? Here are some other Senior Analyst - Inventory jobs in the Miamisburg, OH area that may be a better fit.

Inventory Counter / Auditor

PICS Inventory Specialists, New Lebanon, OH

Part-Time Inventory Specialist

PICS Inventory Specialists, New Lebanon, OH