Data Quality Engineer: Automate Validation & Dashboards

City National Bank; Newark (DE); On-site; USD 87,000 - 139,000; Full time

Benefits offered by this job

Comprehensive healthcare coverage

Generous 401(k) matching

Tuition reimbursement and upskilling

Time away benefits

Supportive professional development

Job summary

City National Bank is seeking a Data Quality Analyst to test data accuracy and perform data analysis to improve data quality on key reports, datasets, and databases.

The role collaborates with reporting teams, business and IT to document quality rules, data lineage, and testing across SQL, Oracle, Snowflake, Excel VBA, Python and Tableau, with a strong emphasis on data governance and ETL concepts.

Qualifications

• Minimum 3 years of experience with data quality testing.
• Minimum 5 years of experience with data analysis and reporting.
• Minimum 3 years of experience with writing SQL statements.

Responsibilities

• Participate in and lead cross-functional discussions to 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 (Completeness, Accuracy, Conformity, etc.)
• Draft SQL rules (Oracle, Snowflake) and create test cases
• Validate existing Data Quality rules to meet Data Governance requirements
• Review transformation specs to propose additional DQ rules
• Identify Data Quality issues and escalate for remediation
• Design and build interactive Tableau dashboards to summarize data insights for stakeholders

Skills

Data quality testing

Data analysis

SQL

Python

Tableau

Excel VBA

Data governance

ETL concepts

Education

Bachelor’s degree in Information Systems

Master’s degree preferred

Tools

ETL tools (Informatica, Collibra, IBM Analytics)

SQL databases Oracle/Snowflake

Job description

City National Bank is seeking a Data Quality Analyst to test data accuracy and perform data analysis to improve data quality on key reports, datasets, and databases.

The role collaborates with reporting teams, business and IT to document quality rules, data lineage, and testing across SQL, Oracle, Snowflake, Excel VBA, Python and Tableau, with a strong emphasis on data governance and ETL concepts.