Senior Data analyst- SQL query writing expert

Datamatics; Dubai; On-site; AED 1,440,000 - 1,760,000; Full time

Job summary

Datamatics is seeking a senior data analytics specialist with extensive banking experience and strong SQL skills to lead data quality and enrichment initiatives. The role requires expertise in data discovery, mapping, and governance across subsidiaries and finance teams.

You will collaborate with IT, Risk and Finance to document business rules, validate data flows, and support go-live activities, ensuring reconciliation and accuracy across platforms.

Qualifications

• Banking/finance domain experience is required.
• Experience with SQL development and performance tuning.
• Strong data analysis and data modeling capabilities.
• Knowledge of data quality, data cleansing and enrichment.
• Familiarity with data mapping, business rules and data reconciliation.

Responsibilities

• Present findings to senior stakeholders on data challenges.
• Support integration activities with FIS Balance-sheet manager solution.
• Define SIT/UAT entry and exit criteria for data processes.
• Create and review test scenarios covering data quality, reconciliation and completeness.
• Develop and support data reporting processes and data workshops.
• Coordinate with subsidiaries to align data structures and business rules.

Skills

SQL skills

Query writing

Query optimization

Data analysis

Database concepts

Data discovery

Data quality

Data cleansing

Reporting

Job description

Experience required: Minimum 15yrs of exp

Must have: Banking experience

• 16+ years of exp, Dubai location
• Very strong in SQL skills, query writing, query optimization
• Strong in data analysis, data and database concepts
• Should have worked in banking or finance domain project/s
• Should be open and show eagerness to reskill
• Risk domain knowledge is good to have (not a mandatory skill)
• Data Discovery /Data Sources Identification
• Analyzing data for data quality and data integrity issues
• Support in data cleansing and data Enrichment
• Suggest and coordinate for improvements in data
• Document processes / suggest improvements to systems
• Supporting Vendor for documenting Business Rules /Validation of Rules
• Functional Specification document finalization (Business Rules, Data Mapping Business Logic, Reconciliation /Exception Rules, Completeness)
• Present findings to senior stakeholders on the data challenges
• Support integration activities with FIS Balance-sheet manager solution
• Define entry/ exit criteria for SIT and UAT.
• Participate in creation of Test scenarios covering exceptions, DQ, recon, completeness, reports validation, business rules validation, data flow, adjustments and others
• Participate in creation of Test Scripts (iterative cycle)
• Validation of Test Results (iterative cycle)
• Support for Go Live / Support post go live
• Identify post live issues and support in resolution
• Developing and supporting report development processes
• Participate in data workshops to align data structures of key subsidiaries and international entities
• Liaison with subsidiary data, Risk, Finance and IT teams.
• Understanding subsidiary business rules and automation of business rules.
• Data discovery, Data cleaning activities related to subsidiaries.