Data Analyst III Job at Xoriant Corporation in Santa Clara

Overview

Job Title: Data Analyst III
Location: Santa Clara, CA
Duration: 12+ Months
Pay Rate: $70/hr-75/hr (as per Xoriant guidelines)

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

Responsibilities

• 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.
• Update and maintain supply planning files, ensuring accuracy and consistency.
• Validate data inputs and troubleshoot discrepancies in planning reports.
• Recommend improvements in tools or systems to support more efficient planning.
• Provide analysis on supply trends, gaps, or risks, and suggest corrective actions.
• 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 & Qualifications

• 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