Our client is looking fro a Senior Business Analyst with extremely strong data skill, specifically SQL expertise Must haves ndash bull Hands on Recent SQL Experience - 7 years bull Data Analysis, Data Profiling and metadata ndash 7 years bull Knowledge of database (Oracle) and TOAD SQL Developer ndash 7 years bull UAT BAT Testing Experience with in financial regulatory risk reporting domains bull Previous experience working in FI Banking domain 5yrs Nice to have ndash bull CCAR, Regulatory Reporting (Y9C, 14AQ) and or treasury experience desirable This candidate will be supporting the finance business line within the RRDW (Risk and Regulatory Reporting data warehouse). The role will be primary focused on UAT BAT testing, presenting results to business stakeholders and requires deep SQL and data analysis understanding Job description - The ability to extract data from a source and compare that data to a legacy source in order to perform impact analysis is also required. Candidate will be validating transformation logic, validating that data has been loaded without record loss, truncation, etc. Candidate will be asked to perform reference data testing, and must be comfortable reviewing and understanding data dictionaries, metadata and lineage, data modelER diagrams, etc.
Associated topics: analyst, business, business analyst, financial analytic, financial reporting analyst, government, inspect, refine, refinement, valuation analyst