Business Intelligence Analyst I, New College Grad

About the Role

This role supports the AGS (Applied Global Services) Sourcing organization, where Supplier Account Managers work with strategic, external suppliers to fulfill Applied Materials' needs for parts and materials across multiple commodities, focusing on Cost, Lead-Time, and Quality.

Key Responsibilities

• Understand data and reporting needs from a business perspective in collaboration with the Supply Chain team.
• Communicate business requirements to the Technical Business Intelligence team for automated reports, user-interfaces, and local database storage.
• Perform financial analysis of spend/revenue data, including MCOS, PPV, Gross Margin, and P&L.
• Extract data from internal user-based databases (e.g., Historical Spend data by part number, commodity, supplier; planning forecast data by part number, commodity, supplier).
• Analyze data from a financial perspective (e.g., Purchase Price Variance, Cost, Spend, Revenue).
• Summarize data by Supplier, Commodity, and Account Manager using MS Excel.
• Create summarized tables, charts, and graphs in MS Excel.
• Develop PowerPoint slides that summarize analyzed data with visual graphs, key bullets, and takeaways.
• Communicate with Account Managers to gather their input on key variances in cost and spend.

Requirements & Tech Stack

• Heavily proficient in MS Excel, including Vlookups, Pivot Tables, automated functions, calculations, and development of cost models.
• Heavily proficient in MS PowerPoint, including creating slides with visual charts, graphs, and key takeaways.
• Proficient in internal user-based databases such as SAP, MS Access, and Tableau.
• Experience with Financial Analysis (MCOS, PPV, Gross Margin, P&L statements).

Qualifications

• Bachelor's Degree in Business, Finance, Management Information Systems, or a related field.
• A GPA of 3.0 or above is preferred.
• Knowledge of the Semiconductor Industry is a plus.
• Knowledge of Supply Chain Management is a plus.