Description
Are you looking for an exciting opportunity to join a dynamic and growing team in a fast paced and challenging area? This is a unique prospect for you to work in the Analytics team to partner with the Business.
As an Analyst within the Consumer & Community Banking (CCB) Remediation and Correction functional area, you will perform end-to-end testing of the case requirements and analysis on code against those requirements and execution plans; while confirming correct usage of data sources, standard code, adherence to guidelines and regulations, and following best practice standard. The Analyst is expected to perform validation on cases resulting from difficult, complex, multilayered, data intensive business problems.
Job Responsibilities:
- Identify scenarios based on Correction Case requirements
- Effectively communicate with BA/Developers and PMs on the issues identified
- Ability to work under tight deadlines
- Develop test plan, code and macro validation procedures, job aids, tools and approaches and effective communication of defects
- Perform code to business requirement validation
- Develop test scenarios for each logic and business requirements
- Write queries and run frequencies to validate population and output files
-
Ensure correct formatting and logic of all output files
Required qualifications, capabilities, and skills :
- Under Graduation / Post-Graduation degree in a quantitative discipline; Math, Finance, Statistics, Economics, or equivalent work/training is required.
- 5+ years of experience in requirements a SQL and SAS Developer or related role
- Must have ability to understand complex SQL queries
- Banking experience in one or more US consumer credit portfolios (Mortgage, Credit Card, Auto, Consumer and Business Banking)
- Querying skills in SAS, SQL , Python, Snowflake and Alteryx environment
- Focused attention to detail, analytical & inquisitive with high standards for quality and accuracy