Enterprise Risk Management Department-Risk Data Aggregation and Risk Reporting (RDA) AVP/Associate

Bank of China Limited, New York Branch; New York (NY); On-site; USD 65,000 - 150,000; Full time

Job summary

Bank of China Limited, New York Branch is seeking a data analytics professional to lead automated reporting and risk data analysis in the ERM-RDA program. You will build SQL/Python solutions, develop BI dashboards, and work with IT to ensure data accuracy and issue resolution.

The role requires strong data skills, knowledge of SQL Server/data warehousing and a collaborative approach to drive risk reporting and program execution in a banking environment.

Qualifications

• Bachelor's degree in preferred fields; Master's degree preferred.
• 1+ years (Associate) or 4+ years (AVP) of data analysis, reporting and related experience.
• Solid coding skills in SQL, Python and data analysis with large datasets.
• Understanding of SQL Server, data warehousing and financial data concepts.

Responsibilities

• Analyze business requirements and develop SQL codes to automate reports for risk and business departments.
• Perform data analysis and create data visualization dashboards with business intelligence tools.
• Conduct data requirements analysis and testing to support IT system implementations.
• Maintain data mapping and data model of the centralized risk data repository and enhance it.
• Coordinate with IT to identify, investigate and resolve data issues.
• Support RDA program management activities and collaborate with stakeholders.

Skills

SQL

Python

Data analysis

Data visualization

BI tools

Testing

Education

Bachelor's degree

Master's degree

Tools

SQL Server

Data warehousing

Job description

Introduction

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.

Overview

This position is to lead from technical perspective the reports automation and data analysis related efforts to support the ERM-RDA Team Lead in running the overall RDA program at the bank. The main responsibilities for this role include, but are not limited to, analyzing business requirements and developing the codes for reports automation, conducting data analysis with risk/business data from various systems, creating data visualization with business intelligence tools, leading the data related testing in the user acceptance test in the relevant IT system implementation projects, and working closely with IT team to support data issue investigation and resolutions, etc.

Responsibilities

Include but are not limited to:

Data Analysis and Risk Reporting

• Analyze business requirements and develop SQL codes to automate reports for risk and business departments
• Perform data analysis and create data visualization dashboards with business intelligence tools
• Conduct data requirements analysis and testing to support relevant IT system implementation projects and initiatives
• Maintain the data mapping and data model of the centralized risk data repository and enhance it when needed
• Coordinate with IT team and support the identification, investigation and resolutions to relevant data issues
• Communicate with stakeholders from business and risk management to address their data/reporting needs
• Create business requirements specification and other documentation for reports automation and system implementation
• Support the senior team member and lead the junior team members from technical perspective in reports automation and data analysis related work, such as creating plans with specific actions in line with the team's overall prioritization, guiding the junior members in their assignments, and reviewing their work to provide feedback, etc

RDA Program Management

• Facilitate with the RDA Program Management related activities and initiatives, e.g. RDA Working Group (WG) related activities, gap analysis and self-evaluations against the RDA regulatory requirements
• Contribute to the implementation of the RDA compliance actions and coordination with other relevant systems
• Support the RDA related requests from the Head Office and/or regulators

Qualifications

• Bachelor's degree required; majors in Financial Engineering, Computer Science, Business Analysis, Statistics, Finance, Economics, or related fields preferred. Master's degree preferred
• 1+ years (Associate) or 4+ years (AVP) of data analysis, business analysis, and reporting experience; 1+ years (Associate) or 4+ years (AVP) of system development or project management experience. 1+ years of financial or banking industry experience preferred
• Risk management experience preferred (credit risk, market risk, etc.); Banking experience and management experience preferred for AVP
• Demonstrate solid coding and programming skills, such as SQL, Python, etc., and strong data analysis skills to work with large scale of dataset and systems
• Solid understanding of database and information systems concepts, including SQL Server and data warehousing, and general understanding of financial products, banking and lending products, and industry practices
• Understanding of financial regulatory requirements (e.g., BCBS 239) preferred, especially for AVP
• Professional certifications such as CBAP, FRM, PMP, or CFA preferred
• Bilingual ability in Chinese preferred but not required

Pay Range

Actual salary is commensurate with candidate's relevant years of experience, skillset, education and other qualifications.

USD $65,000.00 - USD $150,000.00 /Yr.