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
EducationBachelor of Science degree in Accounting
ExperienceMinimum of 5 years related experience
DescriptionWe 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 & ResponsibilitiesRisk 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.