Business Intelligence Analyst I, New College Grad

About the Role

• Supporting the AGS (Applied Global Services) Sourcing organization.
• Working with strategic, external suppliers to support Applied Material’s needs for parts and material across multiple commodities, excelling in Cost, Lead-Time and Quality.

Key Responsibilities

• Working with the Supply Chain team to understand data and reporting needs from a business perspective.
• Communicating business requirements to the Technical Business Intelligence team for automated reports, user-interfaces, and local database storage.
• Performing financial analysis of spend/revenue data, including MCOS, PPV, Gross Margin, and P&L.
• Pulling data from AMAT user-interfaced databases (e.g., Historical Spend data by part number, commodity, supplier; planning forecast data by part number, commodity, supplier).
• Analyzing data from a financial perspective (e.g., Purchase Price Variance, Cost, Spend, Revenue).
• Using Excel to summarize data by Supplier, Commodity, Account Manager, creating summarized tables, charts, and graphs.
• Creating Powerpoint slides summarizing analyzed data with visual graphs, key bullets, and takeaways.
• Communicating with Account Managers for their input on key variances in cost and spend.

Requirements & Tech Stack

• Heavily proficient in MS Excel – Vlookups, Pivot Tables, Automated functions, Calculations, and development of Cost models.
• Heavily proficient in MS Powerpoint – Creating slides with visual charts, graphs, and key takeaways.
• Proficient in internal user-based databases such as SAP, MS Access, Tableau.
• Knowledge of Financial Analysis – MCOS, PPV, Gross Margin, P&L statements.

Qualifications

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