Job Title: Financial Analytics Developer (TM1)
Location: London, UK
Department: Information Technology
Employment Type: 12 Months Fixed Term Contract
Work Pattern: Full-Time (Hybrid: 3 days in the office)

Overview:

As part of the Financial Analytics team within IT, support the ongoing digital transformation of the bank, primarily the development of ABCIB’s IBM Planning Analytics (TM1) system to meet new business requirements and continuously improve existing processes. The role requires collaborating on projects within a small team and working closely with stakeholders to understand their data, upstream systems and associated processes.

Alongside TM1 development the role is required to support with various systems testing, documentation, model maintenance, running processes, end user queries and building advanced reports. In future there will be scope to support a Power BI platform and other new systems and data initiatives deriving from the bank’s digital transformation.

What You Will Be Doing:

• Support the development and maintenance of ABCIB’s IBM Planning Analytics (TM1) system including requirement analysis, design, testing, deployment, maintenance and documentation
• Work closely with key stakeholders across the bank to understand business logic and proactively identify system enhancement opportunities
• Support from a systems perspective Finance’s regular planning and reporting cycles
• Work collaboratively within the Financial Analytics team on wider transformation projects
• Make full use of TM1’s capabilities to automate processes and Excel models
• Support Finance with complex ad-hoc system queries and regular report builds
• Support with defining requirements and testing of changes to upstream systems
• Monitor regular data loads, troubleshoot and fix issues
• Follow development best practices, relevant IT policies and controls
• Train TM1 user base by sharing relevant knowledge and providing documentation
• Support TM1 user access control via joiners, movers and leavers process

Candidate Specification:

• TM1 Perspectives / Architect development skills – cubes, dimensions, advanced TI processes, rules, dynamic reporting (active forms), workflows
• Data modelling and warehousing principles
• Familiar with FP&A activities
• Advanced Excel including VBA
• Strong user interface and experience design principles
• Sufficient SQL to query source databases and build new ETLs and reports
• MDX for building dynamic subsets and views
• Development lifecycle, TM1 coding best practices and change management
• Experience with Cubewise tools such as Arc, Slice & TM1Py.
• IBM Planning Analytics for Excel (PAX) and Workspace (PAW)
• Power BI data modelling and dashboard development
• Financial and Regulatory Reporting principles within banking
• Qualified Accountant (preferable)
• 5+ years TM1 development experience, working on end-to-end projects ideally within small team within Financial Services 
• Self-motivated with ability to work independently and as part of a team
• Proactively seek opportunities to improve and automate processes
• Great customer service supporting end users
• Clear and concise communication to both technical and non-technical audiences.

Equal Employment Opportunity

Bank ABC is committed to the principles of equal employment opportunity for all employees and applicants and, in accordance with applicable laws, does not discriminate on the basis of sex, gender identity, gender expression, race, color, religion, national origin, ancestry, age, marital status, disability, medical condition, sexual orientation, or on any other basis prohibited by law.

We welcome applications from people with disabilities and are committed to providing reasonable adjustments, where necessary, to make interviews and jobs more accessible. Should you have any difficulty during the recruitment process, require any reasonable adjustments or an application to Access to work please contact the recruitment lead on: michael.williams@bank-abc.com