AVP, Data Quality Analyst

Are you enthusiastic, highly motivated, and have a strong work ethic? If yes, come join our team! At Cathay Bank – we strive to provide a caring culture that supports your aspirations and success. We believe people are our most valuable asset and we proudly foster growth and development empowering you to achieve your professional goals. We have thrived for 60 years and persevered through many economic cycles due to our team members’ drive and optimism. Together we can make a difference in the financial future of our communities.The Data Quality Analyst will be responsible for testing data accuracy and performing data analysis and record-keeping in order 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.ESSENTIAL FUNCTIONSOther 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 escalate issues to the respective remediation team(s).QUALIFICATIONSEducation:Bachelor’s degree or equivalent work experience.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/Ability: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.Strong interpersonal skills.OTHER DETAILS

$120K – $135K / yearPay determined based on job-related knowledge, skills, experience, and location.Cathay Bank offers its

full-time

employees a competitive benefits package which is a significant part of their total compensation. It is our goal to provide employees with a comprehensive benefits package to fit their needs which includes, coverage for medical insurance, dental insurance, vision insurance, life insurance, long-term disability insurance, and flexible spending accounts (FSAs), health saving account (HSA) with company contributions, voluntary coverages, and 401(k).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 is an Equal Opportunity and Affirmative Action Employer. We believe in diversity, equity, and inclusion in the workplace. 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 endeavors to make www.CathayBank.com 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 (626) 582-7370 or mickey.hsu@cathaybank.com .

This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.

#J-18808-Ljbffr