CRM-Data Analytics Team Associate

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 position will conduct varies of credit risk management risk data related duties. The position focuses on the data analytics and risk reporting. 

Credit Risk Data Control and Analysis

• Assist to develop automated solutions to support business processes and report procedures.

• Build up applications or scripts for implementing automation functionalities.

• Database design for information storage purposes in both relationship and non-relationship infrastructures.

• Workflow and data pipeline design and development for meeting risk related reporting requirements.

• Develop data visualizations and dashboards to support the business intelligence progress.

• Communicate with appropriate stakeholders to ensure the data quality problems are identified, documented, and mitigated.

• Support process improvement, including workflow design, documentation, data security control, and identifying efficiency opportunities.

• Collaborate with credit officers, credit administration, data governance, IT, and business unit representatives to provide data analysis and governance ensure new and emerging data required for portfolio analysis is on-boarded into credit risk systems.

• Drive the automation of report and dashboard generation in a manner that drives consistency, accuracy and repeatability in credit risk reporting.

Credit Risk Reporting

• Periodic reporting on the loan portfolio. This includes report generation in a wide variety of formats including but not limited to Clicksense dashboards, Microsoft Excel report, PowerPoint presentations on a periodic as well as ad-hoc basis.
• Prepare portfolio report and analysis including but not limited to Key Risk Indicators, exposure, credit rating, concentration and exception management.
• Integrate and utilize data from a variety of sources in an efficient and accurate manner to drive excellence in risk reporting.
• Utilize knowledge of risk concepts to identify inconsistencies in the reports they generate.

Credit Risk Data Support

• Assist risk management in the design and implementation of risk reporting across a variety of media.
• Supply data to support the credit risk management, including but not limited to asset quality, change of portfolio composition, concentration, rating migration and changes of loan provisions.

• Bachelor's degree in Computer Science/Management Information System required, MBA/Master preferred.
• Minimum 1 year of working experience in data analysis and software development.
• Demonstrate proficiency in at least one core programing language (JAVA, C, C++).
• Experience in at least one supportive programing language (Python, JavaScript, TypeScript, HTML, CSS, VBA and etc).
• Demonstrate proficiency in one SQL language (MSSQL, MYSQL, SQLITE, and etc).
• Demonstrate knowledge in computer science programing, system design, database design, applied analytics, and machine learning.