What are the responsibilities and job description for the Analyst - Inventory position at Wesco?
As an Analyst - Inventory, your focus will be on inventory analysis and the execution of strategies and processes to ensure that inventory and service levels are optimized.
Responsibilities:
- Executes accurate, scheduled daily, weekly, and monthly reports.
- Reconciles report data to ensure data integrity.
- Audits processing errors or bad data points before releasing reports.
- Maintains report contact database, controls user access to shared network drives and other common resources, and executes regular backups.
- Maintains production reports, makes approved changes to report data by modifying Teradata SQL, formatting Excel macros, and Access databases.
- Executes on demand processes and reports, adjusts input parameters, data, and formatting prior to execution, and validates report data prior to publishing results.
- Assists in ad-hoc report development and execution, including modifying existing or developing new SQL, running reports, and formatting data using advanced Excel capabilities.
- Prepares and analyzes data for various projects and initiatives, including interpreting and summarizing findings in PowerPoint or MicroSoft Word format.
Qualifications:
- Bachelors’ Degree in Mathematics, Statistics, Operations Research, Computer Science, Engineering, Supply Chain, Logistics or a similar quantitative discipline.
- APICS, CPFM, CPM preferred.
- 1 year required of related experience, preferably in distribution industry.
- Ability to follow established processes and schedule to deliver timely and consistent report execution.
- Ability to work independently, check your results, troubleshoot problems and exercise judgment.
- Expert knowledge of Microsoft Excel, including creating and editing macros and utilizing other advanced functionality.
- Knowledge of Microsoft Access, including creating basic queries, code and reports.
- Understanding of relational databases, including creating SQL statements.
- Knowledge of Power BI, including data collection and reporting.
- Excellent analytical and problem solving skills, proven ability to apply these in business environment.
- Strong verbal and written communication skills.
- Knowledge of distribution industry, supply chain, purchasing, and inventory concepts, practices, and procedures.
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.
#LI-TM1
