Remote Data Quality & Analytics Specialist

City National Bank; Newark (CA); Remote; USD 87,000 - 139,000; Full time

Benefits offered by this job

Healthcare coverage

401(k) matching contribution

Tuition reimbursement

Job summary

City National Bank in Newark, CA is seeking a Data Quality Analyst to test data accuracy and perform data analysis. You will design tests using SQL, Oracle, Snowflake, Python, and Excel; build automated data collection scripts; and create rules to ensure data quality across key reports and datasets.

You will collaborate with reporting teams, IT, and business partners to document quality rules, lineage, and governance expectations while delivering actionable insights through Tableau dashboards.

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 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 various dimensions (Completeness, Accuracy, Conformity, Precision, Validity, Uniqueness, Timeliness).
• Draft SQL rules (in Oracle, Snowflake or other tools), and create test case
• Validate existing Data Quality rules to ensure they meet Data Governance requirements
• Review the transformation specifications written by various work streams to propose additional DQ rules
• Identify Data Quality issues and escape issues to be remediated
• Design and build interactive Tableau dashboards and visualizations to summarize complex data insights to stakeholders

Skills

SQL Queries

Python Scripting

Tableau

Data Quality Testing

Data Analysis & Reporting

Excel Proficiency

Education

Bachelor’s Degree in Information Systems

Master’s Degree in related field

Tools

Oracle

Snowflake

Tableau

Excel VBA

Python

Job description

City National Bank in Newark, CA is seeking a Data Quality Analyst to test data accuracy and perform data analysis. You will design tests using SQL, Oracle, Snowflake, Python, and Excel; build automated data collection scripts; and create rules to ensure data quality across key reports and datasets.

You will collaborate with reporting teams, IT, and business partners to document quality rules, lineage, and governance expectations while delivering actionable insights through Tableau dashboards.