Senior Data analyst- SQL query writing expert

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