About this role
As an Associate Analyst - Inventory you will be focused on inventory analysis and/or 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:
• High School Degree or equivalent experience required. Bachelor’s degree in business related field preferred. • 4-year degree or equivalent combination of education and work experience • 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.