Established in 1912, Bank of China is one of the largest banks in the world, with over $3 trillion in assets and a footprint that spans more than 60 countries and regions. Our long-term outlook, institutional weight and global breadth provide our clients with a stable and reliable financial partner, whether in Corporate or Personal Banking or our Trade Services, Commodities, Financial Institutions and Global Markets lines of business.

The Data Quality (DQ) and Analytics Associate is responsible for end-to-end data quality measurement, monitoring, and metrcs reporting on the critical data elements (CDEs) certified across all enterprise data domains, following the bank’s data management framework. The individual collaborates with business data stewards, and technology and governance teams to perform DQ issue root cause analysis, identify solutions and manage the issue remediation. This role also carries on DQ testing and assurance for IT system development / enhancement projects, and supports business departments on their data analytics needs and Ad Hoc data inquiries

Data Quality Monitoring, Reporting and Support (45%)

• Develop and maintain Data Quality validation rules and monitoring logic using SQL and Python to assess the timeliness, completeness, accuracy, and consistency of Critical Data Elements (CDEs).
• Perform data profiling and trend analysis across internal systems / databases to identify anomalies, inconsistencies, and potential data quality issues.
• Execute and enhance the automated DQ BAU process.
• Design and enhance the data quality dashboards and scorecards, using BI tools, to provide visibility into data health metrics and data quality key risk indicators (KRIs).
• Perform data validation, and data quality test and assurance for IT system development / enhancement projects. 

Data Quality Issue Management and Remediation (25%)

• Conduct the root cause analysis (RCA) on identified DQ issues and identify remediation solutions.
• Coordinate and plan remediation activities with Data Governance Team, technology team, and business data stewards and stakeholders to resolve data defects timely.
• Report the enterprise Data Quality status and KRIs to the Data Governance Working Group (DGWG) and the Data Governance Committee (DGC). 

Support Business Departments on Data Analytics (10%)

• Help formulate their business data analytics requirements and design solutions accordingly.
• Build and maintain business data analytics dashboards, including development of automated ETL/ELT pipelines and analytical data layer, to improve their operational and reporting efficiency and increase their data-driven decision-making ability.
• Support business departments on their Ad Hoc data inquiries.

Data Governance Support Activities (20%)

• Assist Data Governance with Data Dictionary maintenance and enforcing the data ownership and accountability in the bank.
• Document metadata, data definitions, and data lineage to support transparency between source systems and reporting layers.

• BA/BS degree required, MBA/MS degree preferred
• A minimum of 1 year of experience in data analysis, SQL and BI tools (e.g., PowerBI, Tableau, or Qlik Sense)
• Solid knowledge and experience in SQL, data analysis, and data visualization