Business Intelligence Analyst

Apple•Cupertino, CA

21h•Onsite

About The Position

Imagine what you can do here. Apple is a place where extraordinary people gather to do their lives best work. Together we create products and experiences people once couldn't have imagined, and now, can't imagine living without. It's the diversity of those people and their ideas that inspires the innovation that runs through everything we do. APPLE INC has the following available in Cupertino, California and various unanticipated locations throughout the USA. Plan and create long-term supply and demand forecasts for AppleCare product components and whole units in a reverse supply chain for service parts. Work closely with Global Commodity Management, Engineering, Planning and Procurement, and Worldwide Materials teams to provide comprehensive Lifetime Supply/Demand analysis to ensure availability of service materials. Manage the last time buy planning function within the demand planning organization to ensure that the service parts are available in the right quantity for Apple customers. Responsible for continued development of processes including gathering consensus with cross-functional teams on the last time buy proposal and securing the approval from leadership and tools including Oracle, Snowflake database, Tableau, MS Excel, SAP, and Apple internal tools in support of creating more accurate forecasts, better tracking of material consumption and supply/demand oversight. Perform sensitivity analyses to assess material excess or shortage risks. Escalate global planning issues to senior management, identify root causes, and drive corrective actions. Reduce the last time buy cost by identifying alternate parts and/or excess inventory in the reverse service supply chain. 40 hours/week.

Requirements

Master’s Degree or foreign equivalent in Industrial Engineering or related field
3 years of experience in the job offered or related occupation
3 years of experience with performing end of life (“EOL”) buy analysis, including modelling the interdependencies between vendors and manufacturers in a reverse service supply chain.
3 years of experience utilizing Oracle and Snowflake to develop long-term sourcing reports and forecasting.
3 years of experience generating component forecasts by using bill of material, cost, inventory, service parts demand data, and repair strategy in a reverse service supply chain.
3 years of experience utilizing Excel for data and statistical analysis to make forecasting recommendations.
3 years of experience supporting project management and process improvement for supply and sourcing initiatives.
3 years of experience running cross-functional meetings to drive consensus among business teams.
3 years of experience building Tableau dashboards to show SKU level demand/supply data and projecting shortage/excess.
3 years of experience identifying supply risks by performing scenario and sensitivity analysis in last time buy proposals for components in a reverse service supply chain.
3 years of experience presenting last time buy proposals to leadership in a reverse service supply chain.
3 years of experience driving requirement gathering and user acceptance testing (UAT) for supply chain automation in a reverse service supply chain.

Responsibilities

Plan and create long-term supply and demand forecasts for AppleCare product components and whole units in a reverse supply chain for service parts.
Work closely with Global Commodity Management, Engineering, Planning and Procurement, and Worldwide Materials teams to provide comprehensive Lifetime Supply/Demand analysis to ensure availability of service materials.
Manage the last time buy planning function within the demand planning organization to ensure that the service parts are available in the right quantity for Apple customers.
Responsible for continued development of processes including gathering consensus with cross-functional teams on the last time buy proposal and securing the approval from leadership and tools including Oracle, Snowflake database, Tableau, MS Excel, SAP, and Apple internal tools in support of creating more accurate forecasts, better tracking of material consumption and supply/demand oversight.
Perform sensitivity analyses to assess material excess or shortage risks.
Escalate global planning issues to senior management, identify root causes, and drive corrective actions.
Reduce the last time buy cost by identifying alternate parts and/or excess inventory in the reverse service supply chain.
Performing end of life (“EOL”) buy analysis, including modelling the interdependencies between vendors and manufacturers in a reverse service supply chain.
Utilizing Oracle and Snowflake to develop long-term sourcing reports and forecasting.
Generating component forecasts by using bill of material, cost, inventory, service parts demand data, and repair strategy in a reverse service supply chain.
Utilizing Excel for data and statistical analysis to make forecasting recommendations.
Supporting project management and process improvement for supply and sourcing initiatives.
Running cross-functional meetings to drive consensus among business teams.
Building Tableau dashboards to show SKU level demand/supply data and projecting shortage/excess.
Identify supply risks by performing scenario and sensitivity analysis in last time buy proposals for components in a reverse service supply chain.
Presenting last time buy proposals to leadership in a reverse service supply chain.
Drive requirement gathering and user acceptance testing (UAT) for supply chain automation in a reverse service supply chain.