Job Title: Senior Financial Systems Developer
Location: London, U.K.
Department: IT
Employment Type: 12 Months Fixed Term Contract
Work Pattern: Full-Time

Overview:

Within the Financial Systems team, the Senior Financial Systems Developer will play a key role in driving the digital transformation of Finance via development of new reporting, analytics and process automations. Leveraging TM1, SQL, Power BI and other relevant technology, the developer will be responsible for sourcing, extracting, transforming and modelling data to streamline Finance’s processes and improve the overall data quality, consistency and accessibility for the bank.

The role will lead development projects, collaborating with other developers and analysts where required to meet the team’s objectives. The developer will need to build strong relationships with stakeholders across the Finance function to help understand their data requirements, upstream systems and associated processes.

What You Will Be Doing:

• Develop and maintain 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
• Make full use of TM1’s capabilities to automate processes and Excel models
• Develop SQL to extract, transform and load required data into TM1
• Build data models and dashboards in Power BI using TM1 and other data sources
• Implement data quality checks, automated reconciliations and exception reports to improve consistency and accuracy of financial and regulatory reporting
• Collaborate with Group IT and business to development requirements and test changes to upstream systems
• Support Financial Systems Analysts troubleshooting and fixing issues
• Follow development best practices, aligning with relevant policies and controls
• Create and maintain technical documentation

Candidate Specification:

• TM1 development skills – cubes, dimensions, complex TI processes, rules, dynamic reporting (active forms), workflows
• Power BI data modelling (DAX & M) and dashboard development
• SQL development skills for new ETLs and understanding upstream databases
• Advanced MDX, VBA and Excel
• Development lifecycle, TM1 coding best practices and change management
• Familiar with financial and regulatory reporting, planning and analysis requirements within banking
• Data management principles
• Experience with Cubewise TM1 tools such as Arc, Slice & TM1Py.
• IBM Planning Analytics Workspace (PAW) development
• Python
• Data Lakes & Warehousing principles
• Qualified Accountant (preferable)
• Relevant technical certifications in TM1, SQL & Power BI
• 5+ years TM1 & SQL development experience, working on end-to-end projects ideally within small team within Financial Services
• 2+ years developing models and dashboards on Power BI
• Self-motivated with ability to work independently with stakeholders
• Proactively seek opportunities to improve and automate processes
• Clear and concise communication to both technical and non-technical audiences.
• Willingness to share knowledge to support and develop others.

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