Applied Materials is hiring a Data/Finance Analyst Intern to support the AGS Sourcing organization. The intern will analyze historical spend and forecast data from a financial perspective, create Excel summaries and PowerPoint presentations, and communicate with Account Managers about cost and spend variances.
Responsibilities
Historical Spend data by part number, commodity, supplier, etc
Planning Forecast data by part number, commodity, supplier, etc
Analyzing data from a financial perspective (Purchase Price Variance, Cost, Spend, Revenue, etc)
Using Excel to summarize data by Supplier, Commodity, Account Manager Creating summarized tables, charts, graphs in MS Excel Creating Powerpoint slides summarizing the analyzed data with visual graphs, key bullets, takeaways
Communicating with Account Managers for their input on key variances in cost, spend
Qualification
Required
Heavily proficient in MS Excel – Vlookups, Pivot Tables, Automated functions, Calculations and development of Cost models
Proficient in MS Powerpoint – Creating slides with visual charts, graphs, key takeaways
Bachelors Degree in Business, Finance, Management Information Systems
Preferred
Knowledge of MS Access / User interfaces to various databases is a plus
3.0 or above GPA preferred
Knowledge of Supply Chain processes is a plus
A supportive work culture that encourages you to learn, develop, and grow your career
Programs and support that encourage personal and professional growth and care for you at work, at home, or wherever you may go
Candidates may be eligible for participation in a bonus and a stock award program, as applicable
Applied Materials is a semiconductor and display equipment company that offers materials engineering solutions.