Data Validation Risk Analyst – Consumer & Business Banking

Ensure the accuracy, integrity, and reliability of data used in risk and compliance activities.

Write advanced SQL/HQL scripts, including stored procedures, functions, and views.

Leverage various tools such as SSMS, Batch Data Processing (BDP), DBeaver, SAS, Python to gather and analyze complex data from multiple, disparate sources.

Customer Remediation Validation:
Support issue and business line management with validation of data analysis, documentation and execution to ensure compliance with the bank’s Customer Remediation Policy.

Understand data cycle/data flow between processes, systems, and sources.

Identify trends, patterns and/or outliers in data using various statistical techniques and tools.

Possess understanding of front-end systems (e.g. Hogan, CA-View, Fusion, Common Transactions, Safe Box Inquiry, Net-O, MSP, CACS, Doc Velocity) for the various business line processes.

Maintain awareness of bank, regulatory, and industry changes and trends.

Learn and leverage new technology.

Ensure all data practices adhere to enterprise governance, compliance, and data management standards.

Perform other duties as assigned.

• Typically more than six years of applicable experience
• Bachelor's degree, or equivalent work experience
• Proficiency with Power Platform (Power Automate, Power Apps)
• Experience with data visualization tools (Tableau, Power BI)
• Competence with cloud-based platforms such as Microsoft Azure and Databricks
• Expertise in general-purpose programming languages (Python, C#)
• Experience using SharePoint and AI tools such as Copilot
• Comfortable working in a team environment with layers of required review/approval
• Strong problem-solving, process facilitation, project management, and analytical skills
• Advanced understanding of CBB products, services, systems, and associated risks/controls, as well as supporting operational functions
• Thorough knowledge of Risk/Compliance/Audit competencies