Fp&a Analyst

**Xylem |ˈzīləm|**:
1) The tissue in plants that brings water upward from the roots;
2) a leading global water technology company.

Xylem, a leading global water technology company dedicated to solving the world’s most challenging water issues, is the leading global provider of efficient, innovative and sustainable water technologies improving the way water is used, managed, conserved and re-used. Our international team is unified in a common purpose: creating advanced technology and other trusted solutions to solve the world’s water challenges. We are committed to creating an organization of inclusion and diversity, where everyone feels involved, respected, valued and connected, and where everyone is free to bring their authentic selves and ideas.

Xylem Water Solutions South Africa seeks to appoint a **Financial Planning & Analysis Analyst **, to be established in **Kempton Park**, 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

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

- Qualified Accountant CA, ACMA, ACCA, B. Degree required.
- CIMA qualification a benefit
- 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/Competencies**
- 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 work with people from different backgrounds

Consideration will be given to the company’s Employment Equity Plan.