Wesco→
Inventory Analyst at Wesco in 2600 Weaver Rd, Macon, GA, 31217
Entry LevelOn-siteFull-time2600 Weaver Rd, Macon, GA, 31217$49k–$61k/yr
Skills
microsoft excelsqlmicrosoft accessapics certificationanalytical skillsdistribution knowledgecommunication skillsproblem solving
Job Description
Summary: Wesco is a leading provider of business-to-business distribution, logistics services, and supply chain solutions. They are seeking an Inventory Analyst to focus on inventory analysis and execution of strategies to optimize inventory and service levels, preparing and analyzing data for various projects and initiatives.
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
Required Qualifications:
- Bachelors' Degree in Mathematics, Statistics, Operations Research, Computer Science, Engineering, Supply Chain, Logistics or a similar quantitative discipline
- 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 other applications, including Microsoft Word, PowerPoint and Outlook
- 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
Preferred Qualifications:
- APICS, CPFM, CPM preferred
Required Skills: Microsoft Excel, SQL
Important Skills: Microsoft Access, APICS certification, Analytical skills
Nice-to-Have Skills: Distribution knowledge, Communication skills, Problem solving
Benefits: Paid time off, Medical, dental, and vision coverage, Retirement savings plans
Benefits
Paid time off
Medical, dental, and vision coverage
Retirement savings plans