Associate Director, Regulatory Reporting Data Specialist

Opportunity to join RBC Capital Markets as a regulatory data specialist focused on translating FINRA reporting schemas (CAT, TRACE, CAIS) into granular field-level mappings, identifying data gaps and remediation, performing field-level reconciliation across source systems, and presenting data-quality insights to stakeholders, technology teams, and compliance functions. Responsibilities include decomposing requirements into field-level specifications, mapping regulatory fields to source systems and tables, identifying timing mismatches and data quality issues, conducting exception analysis, partnering with technology to remediate data-pipeline failures, and maintaining knowledge of evolving FINRA requirements to support governance and reporting accuracy.