Inventory Analyst

As an Inventory Analyst, you will focus on inventory analysis and/or execution of strategies and processes to ensure that inventory and service levels are optimized. You will prepare and analyze data for various projects and initiatives, including interpreting and summarizing findings.

• 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.

• Bachelor's Degree in Mathematics, Statistics, Operations Research, Computer Science, Engineering, Supply Chain, Logistics or a similar quantitative discipline
• APICS, CPFM, CPM preferredi>
• 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