Data Validation Risk Analyst – Consumer & Business Banking

Jobtailor; Colorado; On-site; USD 120,000 - 160,000; Full time

Job summary

Jobtailor is seeking a senior data/risk analyst to ensure data accuracy and integrity for risk and compliance activities in a Colorado-based role.

You will write advanced SQL/HQL scripts, develop stored procedures and views, and leverage SSMS, Databricks, Tableau, and Power BI to analyze data from diverse sources.

Qualifications

• Six+ years of relevant experience.
• Bachelor's degree or equivalent.
• Proficiency with Power Platform and data viz tools.

Responsibilities

• Write advanced SQL/HQL scripts, including stored procedures, functions and views.
• Analyze data from multiple sources to support risk/compliance activities.
• Validate data and ensure accuracy, governance, and controls.
• Collaborate with teams and adapt to evolving regulatory requirements.

Skills

SQL/HQL

Data analysis

Problem solving

Project management

Team collaboration

Education

Bachelor's degree

Tools

SSMS

Databricks

Tableau

Power BI

Python

C#

SharePoint

Copilot

Job description

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.

Requirements

• 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