TM1 Developer

Delta Capita Group; Sheffield; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading consultancy firm in Sheffield is seeking a TM1 Developer to work on client-facing projects, delivering enterprise planning and reporting solutions. This full-time position requires a strong technical foundation in TM1 development, excellent communication skills, and collaboration across diverse industries. Applicants must have hands-on development experience and be comfortable with performance tuning and technical documentation. A valid UK working permit is required.

Qualifications

• Hands-on experience with TM1/Planning Analytics required.
• Strong understanding of TM1 architecture and performance tuning techniques.
• Proficiency in MDX, SQL, Excel, and VBA essential.

Responsibilities

• Design and develop TM1 models without relying on wizards.
• Optimize TM1 performance through efficient cube design.
• Implement and manage TM1 security models.

Skills

TM1 development experience

Performance tuning

MDX

SQL

Excel

VBA

TM1 REST API

Technical documentation

Communication skills

Agile methodologies

Tools

Cognos TM1 v10.2

TM1 Web

Planning Analytics for Excel (PAfE)

Job description

Sheffield - Contract

Role Overview

We are seeking a talented TM1 Developer to join our consultancy team, working on client-facing projects that deliver enterprise planning and reporting solutions using IBM Planning Analytics (TM1). This role requires a strong technical foundation, excellent communication skills, and the ability to work across diverse industries and client environments.

Role Responsibilities

• Design and develop TM1 models including Cubes, Dimensions, Rules, and TI Processes without relying on wizards.
• Optimize TM1 performance through efficient cube design, feeder tuning, and rule optimization.
• Implement and manage TM1 security models including group-based and element-level security.
• Develop and maintain TM1 reports and dashboards using TM1 Web, Perspectives, and Planning Analytics for Excel (PAfE).
• Integrate TM1 with external systems using TM1 REST API and scripting languages (e.g., Python, Perl).
• Work with relational databases such as SQL Server, DB2, or Oracle for data integration and validation.
• Write and optimize MDX queries and SQL scripts for data extraction and reporting.
• Collaborate with business stakeholders to gather requirements and translate them into technical solutions.
• Participate in Agile ceremonies and contribute to iterative delivery using Scrum, Kanban, or Disciplined Agile methodologies.
• Provide operational support and maintenance for TM1 environments.

Required Skills and Experience

• Hands-on TM1/Planning Analytics development experience.
• Strong understanding of TM1 architecture and performance tuning techniques.
• Proficiency in MDX, SQL, Excel, and Visual Basic for Applications (VBA).
• Experience with TM1 REST API and scripting for automation and integration.
• Familiarity with Cognos TM1 v10.2 and Planning Analytics components (PAW, PAfE).
• Experience in documenting technical and functional requirements.
• Strong communication skills with the ability to explain complex solutions to non-technical stakeholders.
• Ability to work independently and collaboratively in a team environment.
• Exposure to Behaviour-Driven Development (BDD) or Test-Driven Development (TDD) is a plus.

How We Work

Delta Capita is an equal opportunity employer. We positively encourage applications from suitably qualified and eligible candidates regardless of age, colour, disability, national origin, ancestry, race, religion, gender, sexual orientation, gender identity and/or expression, veteran status, genetic information, or any other status protected by applicable law.

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. If you require any reasonable adjustments through your interview process, please use the designated space within the application questionnaire.

This is a full-time contract position located in Sheffield, England. As the selection and interview process is ongoing, please submit your application in English as soon as possible; if your profile is selected, a member of our team will contact you within 4 weeks. For this role a valid working permit for the UK is mandatory.

Expectations regarding hybrid working

As we are a Service Provider and Consulting firm servicing clients, our policy for physically working from the office (which may be the client’s offices or our own offices depending on the client) aligns to what our client’s policies and expectations are and these vary. Most of our client’s now require a minimum of 3 days per week in the office, 2 days from home, and accordingly this is also the minimum expectation that Delta Capita require.

Who We Are

Delta Capita Group is a global managed services, consulting and solutions provider with a unique combination of experience in Financial Services and technology innovation capability. Our mission is to reinvent the financial services value chain providing technology based mutualized services for financial institutions for non-differentiating services.

Our 3 offerings are

• Managed Services
• Consulting & Solutions
• Technology

To know more about Delta Capita and our culture click here: Working at DC - Delta Capita.