Data Quality Analyst: Elevate Data Integrity & Dashboards

City National Bank; Belgique; Sur place; EUR 75 000 - 120 000; Plein temps

Avantages offerts par ce poste

Healthcare coverage

401(k) matching

Career development & training

Paid time off & volunteer time

Fertility and health programs

Career mobility support

Colleague resource groups

Résumé du poste

City National Bank is seeking a Data Quality Analyst to test data accuracy, analyze data, and document data lineage for key reports. You will work with reporting teams, business units, and IT to design tests across platforms including SQL, Oracle, Snowflake, Excel VBA, Python, and third-party tools.

The role emphasizes building automated data collection and validation scripts, deconstructing complex data sets, and developing governance-aligned data quality rules.

Qualifications

• 3+ years data quality testing experience
• 5+ years data analysis and reporting experience
• 3+ years writing SQL statements

Responsabilités

• Lead discussions to document data quality rules for critical reports and data sets
• Build Python applications for automated data collection, validation, and quality checks at scale
• Analyze Excel workbooks and SQL scripts to identify data lineage and dependencies
• Write SQL and Python code to test data across dimensions (Completeness, Accuracy, Conformity, Precision, Validity, Uniqueness, Timeliness)
• Draft SQL rules in Oracle/Snowflake and create test cases
• Validate data quality rules for governance requirements
• Review transformation specs to propose additional data quality rules
• Identify and escalate data quality issues for remediation
• Design and build interactive Tableau dashboards to summarize insights to stakeholders

Connaissances

Data quality testing

Data analysis

SQL

Python

Formation

Bachelor’s Degree in Information Systems

Master’s Degree in related field

Outils

Tableau

ETL tools

Informatica

Collibra

IBM Analytics

Description du poste

City National Bank is seeking a Data Quality Analyst to test data accuracy, analyze data, and document data lineage for key reports. You will work with reporting teams, business units, and IT to design tests across platforms including SQL, Oracle, Snowflake, Excel VBA, Python, and third-party tools.

The role emphasizes building automated data collection and validation scripts, deconstructing complex data sets, and developing governance-aligned data quality rules.