What are the responsibilities and job description for the Inventory Analyst position at WESCO International?
Job Description
You will focus on inventory analysis and/or execution of strategies and processes to ensure that inventory and service levels are optimized.
Responsibilities:
Qualifications:
You will focus on inventory analysis and/or execution of strategies and processes to ensure that inventory and service levels are optimized.
Responsibilities:
- Execute accurate, scheduled daily, weekly, and monthly reports.
- Reconcile report data to ensure data integrity.
- Audit processing errors or bad data points before releasing reports.
- Maintain report contact database, control user access to shared network drives and other common resources, and execute regular backups.
- Maintain production reports, make approved changes to report data by modifying Teradata SQL, formatting Excel macros, and Access databases.
- Execute on-demand processes and reports, adjust input parameters, data, and formatting prior to execution, and validate report data prior to publishing results.
- Assist in ad-hoc report development and execution, including modifying existing or developing new SQL, running reports, and formatting data using advanced Excel capabilities.
Qualifications:
- Bachelor's 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 the 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 other applications, including Microsoft Word, PowerPoint, and Outlook.
- Excellent analytical and problem-solving skills, proven ability to apply these in a business environment.
- Strong verbal and written communication skills.
- Knowledge of the distribution industry, supply chain, purchasing, and inventory concepts, practices, and procedures.
