AVP, Data Quality Analyst

Cathay Bank values the drive and optimism of its team members and is committed to fostering growth and development to help you achieve your professional goals.

The Data Quality Analyst will be responsible for testing data accuracy and performing data analysis and record-keeping to improve the quality of data on critical reports, data sets and databases. The Analyst will work with reporting teams, data domain stewards and Technology to document the lineage of critical data elements (CDEs) and implement data quality rules on CDEs with the use of the Enterprise Data Governance Tool.

Other responsibilities of the Data Quality Analyst include:

• 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 escalating to the respective remediation team(s).

Education:

• Bachelor's degree or equivalent work experience.
• Master's degree or Data Governance certification (CDMP, CIMP, DGSP, etc.) a plus.

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.
• 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.

Skills/Abilities:

• 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.

$105K – $110K / year. Pay determined based on job-related knowledge, skills, experience, and location. This position may be eligible for a discretionary bonus.

Cathay Bank offers full‑time employees a competitive benefits package including medical, dental, vision, life, long‑term disability, flexible spending accounts, health savings account with company contributions, voluntary coverages, and 401(k).

Cathay Bank is an Equal Opportunity and Affiliative Action Employer. We welcome applications for employment from all qualified candidates, regardless of race, color, ethnicity, ancestry, citizenship, gender, national origin, religion, age, sex (including pregnancy and related medical conditions, childbirth and breastfeeding), reproductive health decision-making, sexual orientation, gender identity and expression, genetic information or characteristics, disability or medical condition, military status or status as a protected veteran, or any other status protected by applicable law.

Cathay Bank may collect personal information from potential job candidates and applicants. For more information on how we handle personal information and your applicable rights, please review our Privacy Policy.

Cathay Bank endeavors to make  accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact Mickey Hsu, FVP, Employee Relations Manager, at  or  This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.