IT Manager

Senior Financial IT Consultant - TM1 & SAP

Ref: 31| Posted: 11th Jun 2019

This vacancy is now closed

A leading international business with a market leading product within the retail market is looking to hire a Senior Financial Systems Consultant on an interim or permanent basis.

Working within the Commercial function this role will take a lead on the development of TM1 and SAP Master data.

Reporting to the Head of Commercial the role will be responsible for:

  • IBM Planning Analytics (“TM1”) Developer role – includes all technical aspects related to administration, process improvement and optimisation of the TM1 implementation including resolving support issues for end users.
  • Managing suite of reporting cubes including P&L, Margin, Balance Sheet, Cash Flow and Sales Reporting.
  • Supports Commercial Finnce team and management to identify and deliver financial reporting enhancements or brand new BI solutions in order to streamline and automate processes and deliver reporting insights.
  • Owns Extract-Transform-Load (“ETL”) processes and works closely with IT to manage flow of data from systems through Data Warehouse using SQL.
  • Owns and delivers standard reporting based on TM1.
  • Ensures data integrity and reconciliation of TM1 reporting numbers with other systems including SAP FICO and Cognos Controller.
  • Work as an internal consultant to support the Group Controlling team with issues and developments in the SAP Controlling (“CO”) module.
  • Provides user training and support for the central and global Group Controlling teams and maintains robust TM1 documentation.
  • Shares knowledge widely to raise technical knowledge of the team.
  • Supports and delivers BI solutions as required, which may include IBM Cognos Analytics or other BI tools.
  • Ad hoc support for Group Controlling projects or initiatives.

The ideal candidate will be:

  •  Accounting qualification (e.g. CIMA/ACCA) or Bachelor’s degree in Accounting, Finance, Information Systems or other technical discipline.
  •  >3 years’ Developer experience in IBM Planning Analytics (“TM1”) including detailed knowledge of TM1 Rules and advanced TurboIntegrator (“TI”) scripting.
  •  Detailed knowledge of ETL processes including experience with SQL.
  •  Experience developing in Planning Analytics Workspace (PAW).
  •  >3 years’ experience in SAP experience including mainly Controlling (“CO”), but also Finance (“FI”). Knowledge of SD, MM and Customising would be an advantage.
  •  Experience generating Excel-based reports in Planning Analytics Excel (PAX) is preferable.