Data Analyst III

Job Title: Data Analyst III

Duration: 6+ Months

Location: Santa Clara, CA (Onsite)

Xoriant reasonably expects the pay rate for this position to be within the following range: $70/hour-$75/hour.

Role:

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

Regards,

Akangsha