Senior Data analyst- SQL query writing expert

Role: Sr. Data analyst Location: Dubai Work mode: Work from office 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 • Internal Team Coordination / Validating Recon process • 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. • Data Testing related to subsidiaries. • Validating Recon process Show more Show less

16+ years of experience in Dubai; banking/finance domain experience; very strong in SQL skills (query writing, query optimization); data analysis skills; knowledge of data discovery, data sources identification, data cleansing and data enrichment; experience with reconciliation processes and data rules; ability to present findings to senior stakeholders; experience supporting data integration activities with systems (e.g., FIS Balance-sheet manager); experience in creating test scenarios, test scripts, and validating test results; ability to coordinate with vendors and cross-functional teams (Risk, Finance, IT); willingness to reskill; risk domain knowledge is a plus.

Analyze data and ensure data quality and data integrity; identify data sources and perform data discovery; support data cleansing and data enrichment; document processes and suggest improvements to systems; support vendor for documenting business rules and validation; coordinate internal teams and validate reconciliation processes; finalize functional specifications (business rules, data mapping, reconciliation/exception rules, completeness); present findings to senior stakeholders; support integration activities with FIS Balance-sheet manager; define entry/exit criteria for SIT/UAT; participate in test scenario creation, test scripts, and validation; support Go Live and post-go-live issues; develop and support reporting processes; conduct data workshops to align data structures across subsidiaries; liaise with subsidiary data, Risk, Finance, and IT teams; understand subsidiary business rules and automate them; data discovery and data cleaning/testing for subsidiaries; validate recon processes.