Summer 2027 Data/Finance Analyst Intern- Bachelor's (Santa Clara, CA)
About The Position
The Data/Finance Analyst Intern will support Applied Global Services (AGS) Sourcing. The team works with strategic external suppliers to support Applied Materials’ needs for parts and materials across multiple commodities, with a focus on cost, lead time, and quality. The intern will work with historical spend and planning forecast data organized by part number, commodity, and supplier. They will analyze financial measures such as purchase price variance, cost, spend, and revenue; summarize findings in Excel tables, charts, and graphs; and create PowerPoint presentations with visualizations, key bullets, and takeaways. The role also involves communicating with Account Managers to gather input on significant cost and spend variances.
Requirements
- Bachelor’s degree in Business, Finance, or Management Information Systems.
- Strong proficiency in Microsoft Excel, including VLOOKUPs, pivot tables, automated functions, calculations, and cost model development.
- Proficiency in Microsoft PowerPoint, including creating slides with visual charts, graphs, and key takeaways.
Nice To Haves
- GPA of 3.0 or above.
- Knowledge of Microsoft Access or user interfaces to various databases.
- Knowledge of supply chain processes.
Responsibilities
- Review historical spend data by part number, commodity, supplier, and other relevant dimensions.
- Review planning forecast data by part number, commodity, supplier, and other relevant dimensions.
- Analyze data from a financial perspective, including purchase price variance, cost, spend, and revenue.
- Use Excel to summarize data by supplier, commodity, and Account Manager.
- Create summarized tables, charts, and graphs in Microsoft Excel.
- Create PowerPoint slides presenting analyzed data, visual graphs, key bullets, and takeaways.
- Communicate with Account Managers to gather input on key cost and spend variances.
Benefits
- Comprehensive benefits package.
- Candidates may be eligible for participation in a bonus program and a stock award program, as applicable.
- Supportive work culture that encourages learning, development, and career growth.
- Programs and support focused on employee health, wellbeing, and personal and professional growth.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Intern
