Financial Analyst

Role Overview

The Financial Analyst will 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.

What You Will Do

The Financial Analyst will 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, and consolidate UB/ST and Sell-in (SI) data in the forecast model and uploading it into the designated supply planning system in a timely manner.

Why It Might Be a Fit

The Financial Analyst will 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, and raise any identified risks and opportunities (R&O) during the discussion and assess if those Risks and opportunities should be incorporated into the forecast.

Requirements

• 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: 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