Business Intelligence Analyst

Apple•Cupertino, CA

10d•$137,900 - $207,300•Hybrid

About The Position

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.

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.
Provide comprehensive Lifetime Supply/Demand analysis to ensure availability of service materials.
Manage the last time buy planning function within the demand planning organization.
Develop processes for gathering consensus on last time buy proposals and securing leadership approval.
Utilize tools including Oracle, Snowflake database, Tableau, MS Excel, SAP, and Apple internal tools to create more accurate forecasts, track material consumption, and provide 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 last time buy cost by identifying alternate parts and/or excess inventory in the reverse service supply chain.
Perform end of life (“EOL”) buy analysis, including modelling the interdependencies between vendors and manufacturers in a reverse service supply chain.
Develop long-term sourcing reports and forecasting using Oracle and Snowflake.
Generate component forecasts using bill of material, cost, inventory, service parts demand data, and repair strategy in a reverse service supply chain.
Utilize Excel for data and statistical analysis to make forecasting recommendations.
Support project management and process improvement for supply and sourcing initiatives.
Run cross-functional meetings to drive consensus among business teams.
Build 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.
Present 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.