Transact Expert [T24]

Datamatics; Dubai; On-site; AED 300,000 - 420,000; Full time

Job summary

Datamatics UAE seeks a senior data & reporting specialist with 10+ years in banking MIS and core banking support to join our analytics team in Dubai. You will design and optimize Oracle SQL/PLSQL queries, develop reporting datasets, and support Temenos Transact/T24 modules across Retail Lending and related products.

You will handle ad hoc data requests, validate data, and collaborate with business users, IT teams, and vendors under tight timelines, delivering reliable reports via SSRS and Power

Qualifications

• 10+ years of experience in banking MIS, data analytics, or core banking support.
• Significant hands-on Temenos Transact/T24 experience.
• Advanced SQL and Oracle DB expertise, including data extraction and reconciliation.

Responsibilities

• Develop complex Oracle SQL/PLSQL queries and reporting datasets across banking applications.
• Handle ad hoc data/reporting requests and validate data accuracy.
• Provide support for Temenos Transact/T24 modules and banking data.
• Troubleshoot data discrepancies, production incidents, and performance issues.
• Collaborate with business users, IT teams, and vendors to resolve issues.

Skills

Temenos Transact

Oracle SQL

PL/SQL

Banking MIS

Data analysis

Tools

Power BI

SSRS

Job description

• Develop complex Oracle SQL/PLSQL queries, scripts, procedures, and reporting datasets across banking applications.


• Handle business, operational, management, regulatory, and ad hoc data/reporting requests.


• Analyse and troubleshoot complex data discrepancies, report failures, performance issues, and production incidents.


• Provide functional and technical support for Temenos Transact and associated banking applications.


• Understand data structures, business processes, and transaction flows across Transact modules.


• Work closely with business users, operations, IT teams, application teams, and vendors to investigate and resolve reporting and data-related issues.


• Translate business requirements into accurate SQL logic and reporting solutions.


• Perform data reconciliation and validation across source systems and reports.


• Support critical reporting requirements under strict timelines and production pressure.


• Contribute to root‑cause analysis and permanent resolution of recurring reporting and data issues.


• Support existing SSRS and Power BI reporting solutions. Training can be provided where required.

Mandatory Skills & Experience

The three most critical requirements for this role are:

1. Temenos Transact Expertise: Strong functional knowledge of Temenos Transact / T24 Core Banking, including Retail Lending and preferably exposure across multiple Transact modules and banking products.

2. Advanced SQL & Oracle Expertise: Excellent hands‑on experience in Oracle SQL and PL/SQL, including complex queries, joins, subqueries, stored procedures, performance tuning, data extraction, reconciliation, and troubleshooting.

3. Banking Domain Knowledge and support project experiance: Strong understanding of banking products, processes, transactions, data structures, and reporting requirements, particularly within retail banking and lending.

Experience

• Minimum 10+ years of overall experience, preferably within banking technology, MIS, reporting, data analytics, or core banking support.


• Significant hands‑on experience working with Temenos Transact/T24.


• Strong experience supporting banking MIS, reporting, data extraction, and production environments.


• Prior experience working directly with demanding business stakeholders and handling critical/urgent requirements.


• Experience working directly with demanding business stakeholders and handling critical/urgent requirements.

Skills

• Oracle Database


• Advanced SQL


• PL/SQL


• Banking data and functional knowledge


• Retail Lending knowledge


• Data analysis and reconciliation


• Production issue investigation and troubleshooting


• Work independently with minimal supervision.


• Handle multiple priorities and tight deadlines.


• Perform effectively under pressure, particularly during critical banking incidents and urgent reporting requirements.


• Communicate confidently with senior business and technology stakeholders.


• Understand business requirements quickly and convert them into practical technical solutions.


• Take ownership of problems through investigation, resolution, and closure.