Data Quality Automation Engineer

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

Benefits offered by this job

Healthcare coverage

401(k) plan

Tuition reimbursement

Paid time off

Fertility benefits

Career development

Job summary

City National Bank in Delaware seeks a Data Quality Analyst to test data accuracy, analyze data, and document quality rules and lineage for reports and data sets across SQL, Oracle, Snowflake, Excel VBA and Python.

You will build automated checks, deconstruct complex workbooks, design Tableau dashboards, and partner with reporting teams, business and IT to ensure data governance. Bachelor's in Information Systems preferred; Master’s strongly desired.

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.
• Experience with Python programming and Tableau dashboard design.
• Knowledge of data governance concepts and data lineage.

Responsibilities

• Lead discussions with cross-functional teams to document data quality rules for key reports.
• Build Python apps and scripts for automated data collection, validation, and quality checks at scale.
• Deconstruct Excel workbooks and SQL scripts to map data lineage and transformations.
• Write SQL and Python to validate data across dimensions: completeness, accuracy, timeliness.
• Draft SQL rules (Oracle/Snowflake) and create test cases.
• Validate data quality rules against governance requirements.
• Review transformation specs to propose additional DQ rules.
• Identify data quality issues and escalate remediation; design Tableau dashboards for stakeholders.

Skills

Data quality testing

Data analysis

SQL

Python

Tableau

Excel VBA

Education

Bachelor’s Degree preferably in Information Systems

Master’s Degree strongly desired

Tools

Informatica

Collibra

IBM Analytics

Tableau

Snowflake

Oracle

Job description

City National Bank in Delaware seeks a Data Quality Analyst to test data accuracy, analyze data, and document quality rules and lineage for reports and data sets across SQL, Oracle, Snowflake, Excel VBA and Python.

You will build automated checks, deconstruct complex workbooks, design Tableau dashboards, and partner with reporting teams, business and IT to ensure data governance. Bachelor's in Information Systems preferred; Master’s strongly desired.