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

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

Job summary

Bank of China Limited, New York Branch is seeking a technical leader for reports automation and data analysis. The role involves developing SQL codes, conducting data analysis, and creating data visualizations using business intelligence tools.

Responsibilities include collaborating with IT, maintaining a centralized risk data repository, and facilitating RDA Program Management activities. Candidates should possess a bachelor’s degree in relevant fields and at least 1 year of experience for Associate or 4 years for AVP roles.

Qualifications

• 1+ years of data analysis experience for Associate, or 4+ years for AVP.
• Solid coding skills in SQL and Python.
• Experience in financial industry preferred.

Responsibilities

• Analyze business requirements and automate reports.
• Perform data analysis and create visualizations.
• Support IT system implementation testing.

Skills

SQL

Data analysis

Python

Business analysis

Education

Bachelor’s degree in relevant fields

Master’s degree preferred

Tools

Business Intelligence tools

SQL Server

Data warehousing

Job description

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.