Finance Systems Analyst / Developer (TM1 / Power BI / SQL)

Overview

This global FTSE100 require a Finance Systems Analyst / Developer to work with the Group Head of Consolidation & Reporting and wider Group Finance Teams to ensure the accuracy and integrity of TM1 (IBM financial consolidation system). You will be pivotal in enhancing the maintenance and evolution of the TM1 environment and lead the creation of high-impact Power BI dashboards for analytics.

Whilst our client is seeking a Finance Systems specialist with TM1 experience, they will also consider candidates with experience of any of the main Financial Consolidation / Planning Accounting Platforms combined with a strong knowledge of SQL for Data Extraction and Power BI dashboarding / analytics.

This is a Hybrid role with a minimum of 2 days per week onsite.Key responsibilities:

• Systems Architecture: Support the build and maintenance of our TM1 finance consolidation system, ensuring finance logic (like forecasts, planning and actuals) is flawlessly automated.
• Data Engineering: Use SQL to navigate and extract data from our datasets, ensuring the wider Finance team has a "Single Source of Truth."
• BI & Storytelling: Design and maintain professional Power BI/TM1 dashboards that provide real-time insights into P&L performance, cash flow, and commercial trends.
• Data Integrity: identifying discrepancies in the source system and ensuring our "Single source of Truth" remains accurate.
• Process Automation: Identity manual, repetitive tasks and use technology to automate. Working closely with Group Finance and wider teams to resolve reporting issues and correct submission mistakes.
• Teaching & Knowledge Sharing: Provide expertise, support and training to users on best practice use of TM1 suite of tools.
• Non-financial data owner: Supporting operating company submissions and reporting for several non-core financial collections.

Key Skills & Experience:

• Essential: 1-3 years of hands-on experience with IBM TM1 or another equivalent system (navigating cubes, basic TI processes).
• Essential: Proficient in SQL (joining tables, filtering data, and aggregating large datasets).
• Essential: Strong BI Dashboarding experience (Power BI or equivalent) with a focus on financial reporting.
• Desirable: Part-qualified in CIMA / ACCA / ACA (or equivalent experience in a financial environment).
• Desirable: An "Automation Mindset" - you naturally look for ways to make processes faster and more accurate.