TM1 Developer

Delta Capita
Sheffield, United Kingdom
24 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Sheffield, United Kingdom

Tech stack

Microsoft Excel
Agile Methodologies
Data analysis
Behavior-Driven Development
Data Integration
Data Mining
IBM DB2
Relational Databases
Perl
Python
MultiDimensional EXpressions
Microsoft SQL Server
Oracle Applications
Performance Tuning
Scrum
SQL Databases
Scripting (Bash/Python/Go/Ruby)
Test Driven Development
Cognos Tm1
Vba Programming Language
REST

Job description

  • 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.

Requirements

Do you have experience in VBA?, Do you have a Bachelor's degree?, 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., * 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.

About the company

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.

Apply for this position