Team Overview and Job responsibilities
We are looking for a FP&A Specialist to join our team.
Based in Vila Velha, Brazil, reporting to FP&A Manager, you will be responsible to create short, medium and long-term scenarios, together with the heads of the business units, which allow the P&L and cash flow of each business to be consistently projected, as well as the clear identification of risks and opportunities in terms of price, volume, cost, mix in order to guarantee the company's planned result.
Roles & Responsibilities:
- Build the monthly short, medium and long term projections of each business unit (flash, Rolling Forecast, Budget), consolidating the volume and sales information by product, family, channel and customer, and calculate the price effects, exchange, cost, volume and mix, in order to clearly understand the variations in the contribution margin in view of the result realized in several periods (Month, last year, BAT and YTD)
- Calculate and project the production costs for the short (flash) and long-term (Rolling Forecast) projections in order to guarantee the appropriate cost for future scenarios due to variations in the hedge in the price of materials, exchange hedge and international commodity prices.
- Validate the calculation of industrial, logístical and R&D efficiencies proposed by those responsible for the areas, with the objective of ensuring consistency in the numbers to be projected, as well as explaining their variations in relation to the budgeted (Budget) or planned result (Flash / forecast) ).
- Prepare and present to the FP&A Manager, explanations of the monthly results of the business units under his responsibility, in view of the projection of short (Flash) medium and long term (Rolling Forecast and Budget), last year, identifying the main variations and its effects (price, exchange rate, cost, volume, mix).
- Promote periodic discussions with the leaders of the business units, as well as participate in the commercial discussions, which allow to clearly identify opportunities and risks for the projections of the short, medium and long term results, as well as the action plans to maintain them under control.
- Report monthly on Oracle (HFM) the company's reports, with quality and within the corporate deadlines.
- Prepare and carry out periodic maintenance on the company's financial modeling / control tools, in order to ensure their correct functioning.
(Excel spreadsheets, dashboards)
Who are we looking for?
- We are looking for a professional with the following skills and motivations:
- Complete higher education in Accounting, Economics or Engineering.
- Postgraduate degree in finance, economics or data science.
- Solid experience in FP&A, controllership, strategic planning, minimum 5 years in the industry.
- Domain of advanced Excel (PivotTables, data segmentation, Power Pivot, creation of forms, macros, creation of buttons), VBA will be a differential.
- Solid knowledge in SAP system, CO-SD-FI modules
- Solid knowledge in reporting and loading information in Oracle Hyperion Financial Management (HFM)
- Solid experience in financial modeling and corporate finance.
- Resilience, proactivity, creativity, hands on, team worker are indispensable characteristics.
Visão Geral da Equipe e Responsabilidades do Trabalho
Estamos procurando um Especialista em FP&A para se juntar à nossa equipe.
Baseado em Vila Velha, Brasil, reportando ao Gerente de FP&A, você será responsável por criar cenários de curto, médio e longo prazo, junto com os líderes das unidades de negócios, que permitam que o P&L e o fluxo de caixa de cada negócio sejam projetados de forma consistente, bem como a identificação clara de riscos e oportunidades em termos de preço, volume, custo e mix, a fim de garantir o resultado planejado da empresa.
Funções e **Responsabilidades**:
- Construir as projeções mensais de curto, médio e longo prazo de cada unidade de negócio (flash, Rolling Forecast, Budget), consolidando as informações de volume e vendas por produto, família, canal e cliente, e calcular os efeitos de preço, câmbio, custo, volume e mix, a fim de entender claramente as variações na margem de contribuição em vista do resultado realizado em vários períodos (Mês, ano passado, BAT e YTD).
- Calcular e projetar os custos de produção para as projeções de curto (flash) e longo prazo (Rolling Forecast) a fim de garantir o custo adequado para cenários futuros devido a variações no hedge do preço dos materiais, hedge cambial e preços internacionais de commodities.
- Validar o cálculo das eficiências industriais, logísticas e de P&D propostas pelos responsáveis pelas áreas, com o objetivo de garantir consistência nos números a serem projetados, bem como explicar suas variações em relação ao resultado orçado (Budget) ou planejado (Flash / forecast).
- Preparar e apresentar ao Gerente de FP&A, explicações dos resultados mensais das unidades de negócios sob