Business Intelligence Analyst 1

## TEAM OVERVIEW You will be supporting the AGS (Applied Global Services) Sourcing organization. Our team of Supplier Account Managers work 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 our Supply Chain team to understand data and reporting needs from a business perspective - Communicating those business requirements to the Technical Business Intelligence team for automated reports, user-interfaces, local database storage - Financial analysis of spend/revenue data – MCOS, PPV, Gross Margin, P&L - Pulling data from AMAT user-interfaced databases (Historical Spend data by part number, commodity, supplier, 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 ## TECHNICAL SKILLS - 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, key takeaways - Proficient in internal user based databases such as SAP, MS Access, Tableau - Financial Analysis – MCOS, PPV, Gross Margin, P&L statements ## REQUIREMENTS/EDUCATION - Bachelors 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