Senior Financial Systems Developer (IBM Planning Analytics / TM1)

Location: London, hybrid

Employment Type: 12 month FTC

About the Role

Codex’s client is seeking a Senior TM1 Developer to lead the design and delivery of their new regulatory reporting project.

This is a high-impact role focused on transforming the way regulatory reporting is produced by replacing manual, Excel-based processes with a scalable, automated solution built using IBM Planning Analytics (TM1) and supporting technologies including SQL, Python, Excel/VBA and Power BI.

Working closely with Prudential Regulatory Reporting, Finance and IT stakeholders, you will take ownership of the technical solution from requirements gathering through to design, development, testing and implementation. You’ll play a key role in improving reporting efficiency, strengthening data governance and delivering a robust platform that supports critical regulatory reporting obligations.

Key Responsibilities

• Lead the design, development and implementation of an end-to-end automated FINREP reporting solution using IBM Planning Analytics (TM1).
• Replace manual Excel-based reporting processes with scalable, automated and controlled system solutions.
• Partner with Prudential Regulatory Reporting and Finance stakeholders to translate complex regulatory requirements into technical designs and reporting logic.
• Design, build and maintain TM1 cubes, dimensions, rules and TurboIntegrator (TI) processes supporting FINREP Balance Sheet, Profit & Loss and Expected Credit Loss (ECL) reporting.
• Develop and optimise SQL-based data pipelines and ETL processes to source, transform and load data into TM1 from multiple upstream systems.
• Design and implement reconciliation routines, data quality controls and exception reporting to ensure reporting accuracy, completeness and auditability.
• Produce high-quality technical documentation and ensure governance standards are embedded throughout the solution lifecycle.
• Collaborate with IT and business teams to support testing, deployment and ongoing enhancement of the reporting platform.
• Identify opportunities to improve system performance, automation and reporting capability.
• Provide technical leadership and guidance to colleagues, promoting best practice across financial systems development.

About the Team

The Financial Systems team is responsible for delivering and supporting the firm’s critical financial planning, reporting and regulatory systems.

As part of a major transformation programme, the team is modernising regulatory reporting through increased automation, improved data governance and enhanced reporting capabilities. This role will be instrumental in delivering a strategic solution that strengthens regulatory compliance while reducing manual effort and operational risk.

About You

You’ll be an experienced TM1 developer with strong technical expertise and a proven track record of delivering enterprise-scale financial systems solutions. Comfortable working directly with senior stakeholders, you’ll combine excellent analytical skills with the ability to translate complex regulatory requirements into practical, sustainable technology solutions.

Essential Skills & Experience

• Extensive experience developing solutions using IBM Planning Analytics (TM1).
• Strong knowledge of TM1 architecture, cubes, dimensions, rules and TurboIntegrator (TI) processes.
• Advanced SQL skills with experience developing ETL processes and integrating multiple data sources.
• Experience delivering financial or regulatory reporting solutions within a banking or financial services environment.
• Strong understanding of financial data structures, reporting processes and controls.
• Experience implementing reconciliation processes, data quality controls and audit-ready reporting solutions.
• Proven ability to gather and interpret business requirements and translate them into scalable technical designs.
• Excellent stakeholder management, communication and problem-solving skills.
• Experience producing technical documentation and supporting governance frameworks.

Desirable Skills

• Python development experience for automation and data processing.
• Advanced Excel and VBA skills.
• Experience developing Power BI reporting solutions.
• Knowledge of data governance and financial systems architecture.
• Experience leading or mentoring developers within technical project teams.

If you’re interested, please apply here or forward your CV directly to bethany.jones@wearecodex.team.

Unfortunately this role does not offer visa sponsorship.