Associate Director, Technical Data Specialist, Regulatory Reporting Data Strategy

Royal Bank of Canada • Jersey City, NJ

1d • $125,000 - $190,000 • Onsite

About The Position

RBC Capital Markets (RBC CM) is looking for a technical specialist responsible for documenting, validating, and maintaining end-to-end data lineage across Capital Markets technology ecosystem. This role goes beyond business-level data mapping to trace actual data flows across systems, tools, and platforms. The specialist will work closely with the Data Governance and Enterprise Data teams to identify control gaps, ensure data quality, and support enterprise data compliance initiatives.

Requirements

• Bachelor's degree in Computer Science, Information Technology, Data Science, or related field, or equivalent professional experience in data engineering or enterprise data architecture
• 5+ years of experience in data engineering, data governance, or enterprise data architecture roles
• Experience leading enterprise level program management initiatives
• Demonstrated experience building and maintaining data lineage in large, complex data environments
• Experience working with data warehouse architectures or transformation pipelines
• Experience working in large, complex data environments
• In-depth knowledge of financial regulations, compliance requirements, and industry best practices
• Strong strategic thinking, problem-solving, and decision-making skills
• Excellent communication and interpersonal abilities to effectively liaise with diverse teams and clients

Nice To Haves

• Master's degree in Computer Science, Data Science, or Business Administration
• Relevant certifications such as Collibra Certified Data Steward, Informatica certification, or cloud platform data engineering certifications (AWS, Azure, GCP)
• Designation or active pursuit of professional credentials in data governance or enterprise architecture

Responsibilities

• Build and maintain technical data lineage mappings that trace data flows across Capital Markets systems (e.g., OMS → Kafka/Event Streams → Data Lake architectures)
• Document and validate comprehensive data lineage across Capital Markets systems and infrastructure using Collibra Data Intelligence Platform and Informatica Enterprise Data Catalog
• Map data flows from source systems through transformation layers to end-user applications and reporting systems
• Read and interpret ETL jobs, stored procedures, and data pipelines to understand actual data movement and transformation
• Identify control gaps in data pipelines and recommend remediation strategies to strengthen data governance and reduce operational risk
• Collaborate with technology teams, data engineers, and business stakeholders to validate lineage accuracy
• Ensure alignment between documented flows and actual system behavior
• Support compliance reporting and audit requirements related to data provenance and data quality
• Own and drive regulatory data analysis work independently, managing field-level mapping projects from initiation through resolution

Benefits

• competitive compensation
• flexible benefits
• 401(k) program with company-matching contributions
• health, dental, vision, life, disability insurance
• paid-time off
• Leaders who support your development through coaching and managing opportunities.
• Ability to make a difference and lasting impact.
• Work in a dynamic, collaborative, progressive and high-performing team.
• Opportunities to do challenging work.
• Opportunities to build close relationships with clients.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level