Business Intelligence Analyst

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.

Description

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. At Apple, base pay is one part of our total compensation package and is determined within a range. This provides the opportunity to progress as you grow and develop within a role. The base pay range for this role is between $137,900 - $207,300/yr and your base pay will depend on your skills, qualifications, experience, and location.

PAY & BENEFITS: Apple employees also have the opportunity to become an Apple shareholder through participation in Apple's discretionary employee stock programs. Apple employees are eligible for discretionary restricted stock unit awards, and can purchase Apple stock at a discount if voluntarily participating in Apple's Employee Stock Purchase Plan. You'll also receive benefits including: Comprehensive medical and dental coverage, retirement benefits, a range of discounted products and free services, and for formal education related to advancing your career at Apple, reimbursement for certain educational expenses - including tuition. Additionally, this role might be eligible for discretionary bonuses or commission payments as well as relocation. Learn more about Apple Benefits: https://www.apple.com/careers/us/benefits.html.

Note: Apple benefit, compensation and employee stock programs are subject to eligibility requirements and other terms of the applicable plan or program.

Preferred Qualifications

N/A

Minimum Qualifications

Master's Degree or foreign equivalent in Industrial Engineering or related field and 3 years of experience in the job offered or related occupation.

3 years of experience with each of the following skills is required:

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.