Data Analyst III

Position: Data Analyst III
Location: Santa Clara, California
Duration: Contract
Job ID: 170263

Job Overview:
We are seeking a highly skilled and detail-oriented Data Analyst III to join our team. The ideal candidate will have advanced proficiency in Excel, SQL, and data visualization tools, with a strong ability to develop and maintain complex models for forecasting, planning, and analysis. This role involves automating data processes, creating dynamic dashboards, and collaborating with stakeholders to support business decision-making. A background in supply chain planning and statistical analysis is a plus.

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.
• Consume various data sets and build user-friendly Excel models for business users.
• Develop models to support demand forecasting, supply planning, 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 (GCP).
• 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 support the business.
• Document processes and logic behind automation.

Qualifications:

• Advanced proficiency in Excel, including functions, pivot tables, and VBA.
• Ability to write SQL queries and analyze large data sets.
• Understanding of supply chain planning is a plus.
• Excellent analytical and problem-solving skills.
• Strong communication skills and ability to collaborate with multiple teams.
• Knowledge of statistical analysis and forecasting models.
• Bachelor’s degree in Business, Supply Chain, Data Science, or a related field.

About PTR Global: PTR Global is a leading provider of information technology and workforce solutions. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit www.ptrglobal.com

At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to:

• Pay any fee to be considered for, submitted to, or selected for any opportunity.
• Purchase any product, service, or gift cards from us or for us as part of an application, interview, or selection process.
• Provide sensitive financial information such as credit card numbers or banking information. Successfully placed or hired candidates would only be asked for banking details after accepting an offer from us during our official onboarding processes as part of payroll setup.

Pay Range: $70hr - $75hr on w2

The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work.

If you receive a suspicious message, email, or phone call claiming to be from PTR Global do not respond or click on any links. Instead, contact us directly at +1 214-740-2424. To report any concerns, please email us at [email protected] ```