Senior Data analyst- SQL query writing expert

🏢 Datamatics Consulting
📍 United Arab EmiratesFull-timeOn-site
📅 Posted: 1w ago🔄 Updated: 1w ago
CV%
✨ AI Summary
Datamatics Consulting is seeking a Senior Data Analyst with a minimum of 16 years of experience, specifically requiring expertise in SQL query writing and optimization. The role is based in Dubai and requires the candidate to have extensive experience in the banking or finance domain. Key responsibilities include performing in-depth data analysis, identifying and addressing data quality and integrity issues, supporting data cleansing and enrichment, and contributing to report development processes. The analyst will also be involved in documenting processes, coordinating with internal teams and vendors, and presenting findings to senior stakeholders. Knowledge of risk domain is considered a plus. This is a permanent, full-time position.
Required Skills
Soft Skills & Professional Competencies
Data Analysis
Information Technology
Data Transformation
Engineering, Construction & Trades
Validation
Other
Exception Rules CompletenessData Sources IdentificationReport development processesBusiness Logic Reconciliation
Requirements
Minimum 16 years of experience with very strong SQL skills for query writing and optimization. Must have banking or finance domain experience. Responsibilities include data analysis, data quality assessment, data cleansing, supporting report development, and coordinating with various teams for data integration and validation.
Description
Role: Sr. Data analystLocation: DubaiWork mode: Work from officeExperience required: Minimum 15yrs of expMust have: Banking experience16+ years of exp, Dubai locationVery strong in SQL skills, query writing, query optimizationStrong in data analysis, data and database conceptsShould have worked in banking or finance domain project/sShould be open and show eagerness to reskillRisk domain knowledge is good to have (not a mandatory skill)Data Discovery /Data Sources IdentificationAnalyzing data for data quality and data integrity issuesSupport in data cleansing and data EnrichmentSuggest and coordinate for improvements in data Document processes / suggest improvements to systemsSupporting Vendor for documenting Business Rules /Validation of RulesInternal Team Coordination / Validating Recon processFunctional 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 solutionDefine 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 othersParticipate 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 processesParticipate in data workshops to align data structures of key subsidiaries and international entitiesLiaison 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. Data Testing related to subsidiaries.Validating Recon process
✨ Premium Match Details
Deep-dive CV analysis, customized Cover Letters, and Interview prep!
📊 Match Analysis
Insights against your active CV
📊
Personalized Match Analysis
Upload your CV to see exact matching percentages, detailed skills mapping, and gap analysis for this role.
🎯 Overalli74%
⚡ Skillsi85%
View Breakdown
Ontology Match: 85.0
Matched:✓ Requirements Matching✓ Ontology Skills Mapping
📜 Eligibilityi49%
View Breakdown
Local: 19600%
🏗️ Career Fiti91%
View Breakdown
Seniority: 91.0
📋 Requirementsi67%
View Breakdown
Domain: 67.0
🔥 Motivationi78%
View Breakdown
Title Fit: 78.00