Analyst - Inventory

Job Description

We are seeking an Inventory Analyst to join our team! 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.
• 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.
  
  

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
  
  

Wesco International, Inc., including its subsidiaries and affiliates (“Wesco”) provides equal employment opportunities to all employees and applicants for employment. Employment decisions are made without regard to race, religion, color, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, or other characteristics protected by law. US applicants only, we are an Equal Opportunity and Affirmative Action Employer.

Los Angeles Unincorporated County Candidates Only: Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act.

About The Team

At Wesco, we build, connect, power and protect the world. As a leading provider of business-to-business distribution, logistics services and supply chain solutions, we create a world that you can depend on.

Our company’s greatest asset is our people. Wesco is committed to fostering diversity and inclusion across our workforce by embracing the unique perspectives, authenticity and individuality of more than 20,000 Wesco employees around the globe. Through our Business Resource Groups , comprehensive benefits plan and our community outreach initiatives, you can be a part of a welcoming work community who provides platforms for your success.

Learn more about Working at Wesco here and apply online today!

Founded in 1922 and headquartered in Pittsburgh, Wesco is a publicly traded (NYSE: WCC) FORTUNE 500 company.

Job Description

We are seeking an Inventory Analyst to join our team! 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.
• 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.
  
  

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
  
  

Wesco International, Inc., including its subsidiaries and affiliates (“Wesco”) provides equal employment opportunities to all employees and applicants for employment. Employment decisions are made without regard to race, religion, color, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, or other characteristics protected by law. US applicants only, we are an Equal Opportunity and Affirmative Action Employer.

Los Angeles Unincorporated County Candidates Only: Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act.

About The Team

At Wesco, we build, connect, power and protect the world. As a leading provider of business-to-business distribution, logistics services and supply chain solutions, we create a world that you can depend on.

Our company’s greatest asset is our people. Wesco is committed to fostering diversity and inclusion across our workforce by embracing the unique perspectives, authenticity and individuality of more than 20,000 Wesco employees around the globe. Through our Business Resource Groups , comprehensive benefits plan and our community outreach initiatives, you can be a part of a welcoming work community who provides platforms for your success.

Learn more about Working at Wesco here and apply online today!

Founded in 1922 and headquartered in Pittsburgh, Wesco is a publicly traded (NYSE: WCC) FORTUNE 500® company.