Consultant – Regulatory Reporting Data Validation Testing

Domain: Fintech
Career Path: RTech, DataBridge, AgileData, Connect
Type: Full Time preferred

Seniority: Mid senior level
Location: New York City


Proficient knowledge of US regulatory reporting requirements, external reporting control concepts, and financial services related products

Experience with data enhancement / data quality projects

Experience with database management, data sourcing and application testing

Proficient knowledge of GAAP and/or IFRS as well as BCBS 239 principles

High level degree of proficiency in Microsoft Excel and database systems used in financial reporting

CPA Strongly Preferred


Bachelor of Science degree in Accounting


Minimum of 5 years related experience


We are seeking a Regulatory Reporting Data Consultant to join our Financial Services consulting team working on a critical Data Validation Testing program at one of our multinational investment banking clients. As a Consultant, you will work on-site (virtually) at our client as part of a cohesive consulting team and have interactions with senior stakeholders in addition to opportunities to own deliverables.

You will ensure that the data used for Regulatory, Risk and Management Reporting is of high quality and aligned with the Basel principles for effective risk data aggregation and risk reporting (BCBS 239) and supports evolving regulatory requirements. You will be responsible for gathering evidence on data controls, quality and operations used for the attestation of regulatory and risk reporting. You will also be responsible for the data control framework and the test of designs and effectiveness of data related controls. You will define and test various key data elements and transactions used by regulatory reporting to ensure the information captured by the system is accurate compared to source/legal documentation.

Essential Duties & Responsibilities

Risk assessments on US Branch regulatory and management reports data elements for specific data controls between systems to identify and mitigate risk

Review the data lineage, data movements and cartography for the key data elements to comprehend and analyze the potential risks

Interview data stewards, IT team, and the businesses to understand the report/control requirements and business rules required

Communicate and track the risk assessment findings; ensure the proper controls were implemented to mitigate the risks identified

Identify issues with the data dictionary and escalate to the appropriate teams for review and remediation

Create and document the risk assessment and cartography procedures

Resolve data validity issues in the regulatory reporting tool as well as improve the mapping between financial ledgers and the MDRMs

Assist in the ongoing regulatory reporting data quality process and monitoring framework

Focus on improving processes, controls and drive change to build efficiencies

Maintain process / controls inventory for each report and monitor it for quality control and obtain sign off from process owners

UAT Testing of the report aggregation, reconciliation and analysis of the US Branch reports and other key reports

Interact with Internal Audit and external Auditors on a periodic basis for quarterly reviews and annual audits. Maintain all the working papers for external audit

Liaise with external auditors for various audited financials and maintain audit documentation for various audited entities


Yearly Gross Salary: $120k – $180k


Consultant – Regulatory Reporting Data Validation Testing

Submit CV now.

Arrayo is an Equal Employment Opportunity employer and as such does not discriminate against any applicant for employment or employee on the basis of race, color, religious creed, gender, age, marital status, sexual orientation, national origin, disability, veteran status or any other classification protected by applicable discrimination laws.