Apply on Employer Site

Cathay Bank · 3 hours ago

AVP, Data Quality Analyst

El Monte, CA

Full-time

Onsite

Mid Level

$105K/yr - $110K/yr

3+ years exp

Cathay Bank is committed to fostering a caring culture that supports the aspirations and success of its team members. The Data Quality Analyst will be responsible for testing data accuracy and performing data analysis to improve the quality of critical reports and databases.

BankingFinanceFinancial Services

H1B Sponsor Likely

Responsibilities

Deconstruct complex Excel workbooks and SQL scripts to identify data lineage, transformations, and dependencies

Profile data manually and set up profiling tasks in the Enterprise Data Governance Tool

Write SQL queries to test data based on various dimensions (i.e., Completeness, Accuracy, Conformity, Validity, Uniqueness, etc.)

Draft SQL rules on behalf of data domain stewards and CDE owners; create test cases

Validate data quality rules around Enterprise CDEs to ensure they meet Data Governance requirements

Review transformation specifications especially around risk data aggregation and reporting, to propose additional DQ rules as necessary

Identify Data Quality issues and escalate issues to the respective remediation team(s)

Qualification

Data GovernanceSQLData Quality TestingData AnalysisExcelData ManagementCommunication SkillsInterpersonal Skills

Required

Bachelor's degree or equivalent work experience

3 - 5 years of Data Governance/ Data Management experience; experience with financial services is preferred

Minimum 3 years of experience with data analysis and reporting

Minimum 3 years of experience with data quality testing and writing SQL statements

Knowledge of information access and delivery methods, analytics applications and tool portfolio, data sourcing and integration methods

Ability to write SQL queries independently

Understanding of data warehouse, ETL, data cleansing and architecture

Knowledge of advanced formulas & pivot tables in Excel

Thorough understanding of data quality testing principles

Ability to work independently with minimal supervision in various areas of responsibility

Excellent written and verbal communication

Strong interpersonal skills

Preferred

Master's degree or Data Governance certification (CDMP, CIMP, DGSP, etc.) a plus

Experience in any data quality and reporting tools/applications is highly desired (e.g.: Informatica, Collibra, IBM Analytics)

Experience and confidence in working with stakeholders across a wide variety of roles, including senior management

Experience working and effectively collaborating with reporting, operations, and technology teams

Experience building data quality rules and documenting business requirements

BCBS 239 experience is a plus

Benefits

Medical insurance

Dental insurance

Vision insurance

Life insurance

Long-term disability insurance

Flexible spending accounts (FSAs)

Health saving account (HSA) with company contributions

Voluntary coverages

401(k)

Company

Cathay Bank

Glassdoor3.1

Cathay Bank is a financial services company originally founded to support Los Angeles’ growing Chinese American community. It is a sub-organization of Cathay General Bancorp.

Founded in 1962

El Monte, California, USA

1001-5000 employees

https://www.cathaybank.com/

H1B Sponsorship

Cathay Bank has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2020 (1)