Financial Analyst

Apple, Inc.; Coral Gables (FL); On-site; USD 90,000 - 130,000; Full time

Job summary

Apple Inc. Coral Gables, FL is seeking a senior forecast analytics professional to analyze weekly ST, UB, and SI trends, pull promos from the DGP, and project quarterly UB/ST based on demand trends and seasonalities.

You’ll work with LATAM sales and finance to validate forecasts and drive data-driven decisions. Ideal candidates will have 5+ years in forecasting, strong skills in Excel, Tableau, and SQL, and fluency in Spanish.

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 Excel, Tableau, and SQL to build demand forecast models.
• Conducting scenario planning to assess forecast risks and opportunities.
• Performing lifetime supply analysis to identify gaps and risks.

Responsibilities

• Analyze weekly Sell-Through (ST), UB, and Sell-in (SI) trends to forecast product demand.
• Pull promotional offers from Demand Generation Portfolio and account for incremental units.
• Lead discussions with Latin America Sales and Finance teams to validate forecasts.
• Prepare reports and present forecast drivers and risks to leadership.

Skills

Excel

Tableau

SQL

Scenario planning

Lifet ime supply analysis

Spanish language

Tools

Essbase

Job description

Coral Gables, Florida, United States Corporate Functions

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 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.

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

This position is not subject to the application limits.

Apple is an equal opportunity employer that is committed to inclusion and diversity. We seek to promote equal opportunity for all applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, Veteran status, or other legally protected characteristics. Learn more about your EEO rights as an applicant

At Apple, we believe accessibility is a fundamental human right. You’ll find that idea reflected in everything here — in our culture, our benefits and our digital tools. By welcoming as many perspectives as possible, we help you build a career where you feel like you belong.
Learn about accessibility in Apple’s workplace
Learn about reasonable accommodations for job applicants

Apple accepts applications to this posting on an ongoing basis.