Data Quality Analyst

About the role

The Data Quality Analyst will be responsible for testing data accuracy and performing data analysis and record keeping in order to improve quality of data on key reports, data sets and databases. The Analyst works with reporting teams, business and IT to identify and document quality rules, requirements and lineage of data for various reports. The Analyst will design and execute necessary tests in diverse development platforms and computing environments including SQL, Oracle, Snowflake, Excel VBA, Python, and third‑party applications.

Responsibilities

• Participate in and lead discussions with cross‑functional teams to identify and document data quality rules for critical reports and data sets.
• Build Python applications and scripts for automated data collection, validation, and quality checks at scale.
• Deconstruct complex Excel workbooks and SQL scripts to identify data lineage, transformations, and dependencies.
• Write SQL queries and Python code to test data based on dimensions such as completeness, accuracy, conformity, precision, validity, uniqueness, and timeliness.
• Draft SQL rules (in Oracle, Snowflake, or other tools) and create test cases.
• Validate existing data quality rules to ensure they meet data governance requirements.
• Review transformation specifications from various work streams to propose additional data‑quality rules.
• Identify data quality issues and escalate them for remediation.
• Design and build interactive Tableau dashboards and visualizations to summarize complex data insights for stakeholders.

Requirements

• Minimum 3 years of experience with data quality testing.
• Minimum 5 years of experience with data analysis and reporting.
• Minimum 3 years of experience writing SQL statements.
• Bachelor’s degree preferably in Information Systems; Master’s degree in a related field is strongly desired.
• Knowledge of information access and delivery methods, analytics applications, tool portfolio, data sourcing, and integration methods.
• Understanding of data warehouse, ETL, data cleansing, and architecture.
• Ability to write SQL queries, Python code, and design Tableau dashboards independently.
• Advanced Excel skills, including formulas and pivot tables.
• Familiarity with financial‑institution regulatory initiatives such as Basel II, Basel III, Dodd‑Frank, and CCAR.
• Proficiency with MS Office applications (Project, Visio, PowerPoint, Excel, Access).
• Experience with ETL tools and data‑quality frameworks is highly desired.
• Understanding of data‑governance principles, including data lineage, quality standards, and best practices.
• Familiarity with tools such as Informatica, Collibra, or IBM Analytics is a plus.
• Strong interpersonal skills for interacting with data users, managers, and other stakeholders.
• Proven ability to collaborate effectively with reporting, operations, and technology teams.
• Strong critical‑thinking and problem‑resolution abilities.
• Ability to work independently with light to moderate supervision.
• Minimum 3 years of experience writing Python code.
• Minimum 3 years of experience developing and designing Tableau dashboards.

Compensation

Starting base salary: $87,027 – $138,965 per year. Exact compensation may vary based on skills, experience, and location. This position is eligible for bonus and/or commissions.

Benefits

• Comprehensive healthcare coverage (Medical, Dental, Vision) available the first of the month following start date.
• Generous 401(k) company matching contribution.
• Career development through tuition reimbursement and internal upskilling/training resources.
• Valued time‑away benefits including vacation, sick, and volunteer time.
• Specialized health and family‑planning benefits, including fertility support and programs for cancer, diabetes, and musculoskeletal conditions.
• Career mobility support from a dedicated recruitment team.
• Colleague Resource Groups to support networking and community engagement.

About City National Bank

Since day one, City National Bank has gone further than the competition to help clients, colleagues, and communities flourish. Founded in 1954 by entrepreneurs for entrepreneurs, the legacy of integrity, community, and unparalleled client relationships continues today. City National is a subsidiary of Royal Bank of Canada, one of North America’s leading diversified financial services companies.