Prepare, execute, reconcile, audit, and validate scheduled and on-demand reports.
Maintain production reports, report contact databases, user access, and backups; make approved changes to report data, Excel macros, and Oracle databases.
Assist with ad hoc report development by writing or modifying SQL, running reports, and formatting data in Excel.
Perform cycle counts, stock checks, and inventory audits, and record material movements in ERP or inventory systems.
Summarised from the posting by AI and can be wrong. The full description is the source.
Requirements
Licenses and certifications
APICS certification (preferred)
CPFM certification (preferred)
CPM certification (preferred)
Experience
1 year of related experience
Related experience in the distribution industry (preferred)
Education
Bachelor’s degree in Mathematics, Statistics, Operations Research, Computer Science, Engineering, Supply Chain, Logistics, or a similar quantitative discipline
Skills
Expert knowledge of Microsoft Excel, including creating and editing macros and using advanced functionality
Knowledge of Microsoft Access, including creating basic queries, code, and reports
Understanding of relational databases, including creating SQL statements
Knowledge of Microsoft Word, PowerPoint, and Outlook
Knowledge of distribution, supply chain, purchasing, and inventory concepts, practices, and procedures
Other requirements
Ability to follow established processes and schedules for timely, consistent report execution
Full job description
From Wesco’s careers site
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.
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.
Show full descriptionShow less
Maintains production reports, makes approved changes to report data by modifying data, formatting Excel macros, and Oracle 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.
Perform cycle counts, stock checks, and inventory audits to maintain accurate system records.
Record material movements in ERP or inventory management systems with high attention to detail.
Identify and report discrepancies, damaged goods, or inventory issues promptly.
Support root-cause investigations for inventory variances and help implement corrective actions.
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 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