Data Analyst III

• Develop and maintain complex Excel models for forecasting, planning, and analysis.
• Automate data processing and reporting tasks using advanced Excel functions and VBA.
• Create dynamic dashboards and visualizations to support decision-making processes.
• Ability to consume various data sets and build user friendly excel models for business users.
• Develop models to support demand forecasting, supply planning (safety stock/buffer calc.), EOL/NPI Planning and Inventory Reporting.
• Assist in the creation of S&OP meeting materials, including data analysis.
• Write and optimize SQL queries to extract and manipulate data from various databases (Google Cloud Platform).
• Integrate SQL data with Excel models and Tableau to ensure accurate and up-to-date reporting.
• Assist in the maintenance and improvement of SQL databases to support business needs.
• Ensure data accuracy and consistency across various reporting tools and platforms.
• Collaborate with stakeholders to understand requirements and build excel models that can support the business.
• Document processes and logic behind automation.

Skills

• Advanced proficiency in Excel, including functions, pivot tables, and VBA.
• Ability to write SQL Queries
• Ability to consume and analyze large sets of data
• Understanding of Supply Chain Planning is a plus
• Excellent Analytical and Problem Solving Skills
• Strong Communication skills and should be able to collaborate with multiple teams
• Knowledge of statistical analysis and forecasting models

Education

Bachelors in Business, Supply Chain, Data Science or related field