Associate Analyst - Inventory
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.
- Affords assistance in ad-hoc report development and execution, including modifying existing or developing new SQL, running reports, and formatting data using advanced Excel capabilities.
- Presents 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.
- Ability to lift up to 50lbs.
- Ability and willingness to work in the warehouse/yard.
- 1 year forklift experience preferred.
- Knowledge of distribution industry, supply chain, purchasing, and inventory concepts, practices, and procedures.
Pay
Compensation Details: $20.79 - $25.99 Per Hour. This amount is what we reasonably believe we will pay for the position; however, offer amounts may vary based on factors such as geographic location, relevant education, experience, qualifications, skills, shift, or any collective bargaining agreements. For eligible positions, compensation may include participation in a bonus or sales incentive plan, subject to the terms and conditions of the applicable plan documents. For certain sales roles, Wesco also offers a commission structure that provides additional compensation based on sales results, as defined by the applicable commission plan. In addition, Wesco offers a benefits program for eligible employees, which may include paid time off, medical, dental, and vision coverage, and retirement savings plans. Additional details about benefits are available here.