Overview
Skills
Job Details
Data Analyst III (Backfill position)
Onsite Santa Clara, CA Office
Duties:
-
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