Financial Analyst
AppleSummary 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: L…