Description:
Xylem is a leading global water technology company with operations in more than 150 countries; a passionate, talented, and experienced workforce; well-known industry-leading brands and water solution products.
Xylem Water Solutions SA seeks to appoint a FP&A Analyst, to be established in Johannesburg, South Africa.
The main purpose of this position is the responsibility of the planning and analyses function with regards to :
Customer and Margin analysis. Sales analysis Annual Budgeting and Quarterly Forecasting Commercial Business partnering, Resource to the FP&A Manager - Africa
Duties & Responsibilities
Customer and margin analysis
Analyze margins on open orders on a weekly basis Analyze low margins, negative margins and high margins per customer and product on a weekly basis, and correct as necessary Track factory credits for low margin products. Ensure discount structures and pricing is authorized per the Delegation of Authority and contract. Review transfer pricing on products Budgeting and forecasting
Assisting the FP&A manager with compiling budget templates for the Sales teams Review of budget submissions for sales and orders for reasonability Input of budget sales and orders onto financial system (Onestream) Allocation of sales and order budgets to product groups Calculation of margins per product group Balance sheet and P&L budgeting Loading of budget and forecast data on Onestream Quarterly and monthly reporting as per group requirements – per agreed timelines.
Analyze sales and margin variances to budgets/ forecast and prior year for monthly Flux file. Provide input into monthly MBR, budget and forecast Decks. Prepare and present the monthly GDP file Prepare price realization template and investigation negative price realization. Prepare quarterly localization , sales and order variance analysis reports Prepare quarterly analysis of direct and indirect customers for sales and orders. Maintain purchase pricing as per approved price lists Business Partnering and Support
Assist in setting up rebate structure for distributors. Ad hoc business support and analysis of numbers as requested Assist in List Price and Discount DOA set up Creating systems and processes to streamline reporting and analysis on Tableau (BI Tool) Preparation, analysis and distribution of department Income statement on a monthly basis All Other Ad hoc Activities
Supporting weekly outlook meetings Other ad hoc analysis and reporting as requested by Leadership Team members
Minimum Requirements:
Qualification
B. Degree in Accounting CIMA or Qualified and registered CA (a must have) ACMA, ACCA qualification a benefit
Experience
5 years post-qualification experience in FP&A function Experience in business systems implementation Must have been a FP&A / Finance business partner before Must have multinational experience – multi currency/ multi country analysis Must have costing experience in a manufacturing environment
Key Skills and Competences
Advanced Microsoft Excel, PowerPoint. OneStream/ Iscala/ SAP Highest standards of accuracy and precision; highly organized. Articulate with excellent verbal and written communication skills Profound analytical skills for identifying and solving problems Clear communication and synthesis skills Deadline driven and ability to work under pressure Ability to manage and control staff compliment from different background
19 hours ago
report
Report this job