Financial Analyst

Summary

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.

Minimum Qualifications

5 years of experience in the job offered or related occupation. Must be able to read, write, and speak Spanish. 5 years of experience with each of the following skills is required: Leveraging Excel, Tableau, and SQL to build and refine demand forecast models that incorporate inventory levels, historical sales data, seasonal patterns, and year-over-year trends. Conducting scenario planning to assess potential forecast risks and opportunities across multiple time horizons. Performing lifetime supply analysis to identify gaps, surplus risks, and strategic opportunities. Analyzing market data to evaluate market share and addressable market within key Consumer Electronics categories, highlighting potential risks or growth opportunities in both quarterly and long-term forecasts. Delivering actionable business insights by identifying underlying demand trends and translating them into strategic recommendations for senior leadership. Simplifying complex datasets through impactful visualizations and strategic storytelling tailored to executive audiences Applying understanding of Latin American markets and consumer behavior through including familiarity with key market dynamics, local holidays and promotional cycles, and cultural factors that impact consumer demand and channel inventory planning.

Preferred Qualifications

N/A

Description

APPLE INC has the following available in Coral Gables, Florida. Analyze weekly Sell-Trough (ST), number of units sold to end customers (consumers) during a given period, and Unbrickings (UB), first time device activation, trends by sub-Line of Business and projecting weekly UB/ST based on product demand trends, historical seasonalities, promotional periods, and offer elasticities. Pull all promotional co-founded offers from Demand Generation Portfolio (DGP) and add incremental units to forecast. Constrain current week and current week +1 forecast based on supply availability. Project quarterly SI units based on quarterly product demand and TWOS by partner to calculate Apple Quarterly Revenue by Product. Consolidate UB/ST and Sell-in (SI), sell-in is the number of units sold/shipped from Apple into the channel (retailers, carriers, resellers) during a given period of time, data in the forecast model and uploading it into the designated supply planning system in a timely manner as required by World Wide Sales Finance Team (WWSF). Prepare and drive the conversation and ask the right questions to gather all the necessary information that may influence product demands. Discuss current quarter product trends, promotions, commercial strategies, and political, macro-economic, and other variables that may impact product demands with Latin American Sales and operations Country Leads, Local Sales Finance, and Regional Sales Finance teams. Raise any identified risks and opportunities (R&O) during the discussion and assess if those Risks and opportunities should be incorporated into the forecast (e.g., current quarter demand generation performance, any changes in promotional activity, any product constraints, missing backlogs, etc.). Prepare for the call by analyzing each country's forecast trends in great detail by applying all Key Performance Indicators mentioned above, pulling data from the different systems, and validating the current week's trends through Rocket. Run Essbase report highlighting Actuals versus forecast main drivers by sub-Line of Business and country. Lead weekly flash calls with local strategy and sales teams to identify drivers of beats and misses to the forecast. Consolidate and summarize driver weekly beats and misses the forecast in a concise manner and deliver completed report to WWSF and ALAC Leadership and regional point of contact to explain forecast versus Actuals and addressing questions from WWSF and Latin America Region (ALAC) Leadership. Develop and maintain Demand Forecasting and Analytics (DF&A) team reports and analytics with the goal of automating and making the team's reports more efficient using the latest systems and technologies. Display forecast drivers in different ways (e.g., charts, graphics, run charts, waterfalls, written reports, etc.). Validate promotional uplifts by applying all the specialized knowledge referenced above and knowledge of product demand trends and price elasticities. Validate current WOS (weeks of supply by product) and Ship Plan to constrain forecast. Spanish is essential for understanding the underlying demand drivers of all non-iPhone products in the Latin America market. The role requires frequent interaction with Account Executives, Sales Operations, and Purchase Order staff across multiple countries, where most stakeholders are native Spanish speakers and, in some cases, do not speak English. 40 hours/week.