Associate Director, Data Lineage & Metadata Lead, Regulatory Reporting Data Strategy

What is the Opportunity?

RBC Capital Markets (RBC CM) is looking for a lead responsible for owning and evolving the end-to-end data lineage framework across Capital Markets. This role provides strategic oversight of data flows spanning front-office through middle-office and back-office systems, in critical regulatory and reporting platforms such as CAT, TRACE, and CAIS. The lead will establish standards for metadata modeling, data ownership, and critical data element identification to ensure compliance, auditability, and business intelligence across the organization.

What will you do?

• Own the end-to-end data lineage framework across all Capital Markets systems, from front-office trading through middle-office risk management to back-office settlement and regulatory reporting
• Map and document trade lifecycle flows (order execution allocation reporting) and regulatory reporting flows (FINRA CAT, TRACE, OATS legacy systems)
• Define and enforce golden sources of truth, data ownership structures (RACI matrices), and critical data elements (CDEs) across the organization
• Design and maintain comprehensive metadata models that capture both technical and business lineage
• Deliver audit-ready lineage documentation and traceability maps spanning multiple levels of detail (L1-L4)
• Build and govern a centralized data catalog that serves as the single source of truth for data provenance and lineage across Capital Markets
• Collaborate with front-office, middle-office, and back-office teams to validate lineage accuracy and ensure business alignment
• Support regulatory compliance and audit requirements by maintaining current, accurate lineage documentation

What do you need to succeed?

Must Have:

• Bachelor's degree in Computer Science, Information Technology, Data Science, or related field, or equivalent professional experience in data engineering or enterprise data architecture
• 7-10 years of experience in data governance, enterprise data architecture, or data management roles
• Minimum 5 years working in Capital Markets or financial services environments
• Demonstrated experience building and managing enterprise-wide data lineage frameworks in large, regulated organizations
• Expert-level proficiency with enterprise data lineage and cataloging tools: Collibra Data Intelligence Platform, Informatica Enterprise Data Catalog, and Alation
• Deep expertise in metadata modeling, including both technical and business lineage design
• Strong understanding of Capital Markets trade lifecycle and regulatory reporting requirements
• Ability to define and document golden sources, data ownership models, and critical data elements
• Advanced SQL and data architecture knowledge to validate technical lineage across complex systems
• Experience designing governance frameworks and documentation standards at enterprise scale

Nice to Have:

• Master's degree in Computer Science, Data Science, Business Administration, or Finance
• Relevant certifications such as Collibra Certified Data Steward, Informatica certification, or Certified Data Management Professional (CDMP)
• Active involvement in data governance communities or thought leadership in metadata management

What's in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• A comprehensive Total Rewards Program include competitive compensation and flexible benefits, such as 401(k) program with company-matching contributions, health, dental, vision, life, disability insurance, and 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.

The expected salary range for this position is $125,000 - $190,000 USD, depending on your experience, skills, and registration status, market conditions and business needs.

You have the potential to earn more through RBC's discretionary variable compensation program which gives you an opportunity to increase your total compensation, provided the business meets its performance targets and you meet your individual goals.

RBC's compensation philosophy and principles recognize the importance of a highly qualified global workforce and plays a critical role in attracting, engaging and retaining talent that:

• Drives RBC's high performance culture

• Enables collective achievement of our strategic goals

• Generates sustainable shareholder returns and above market shareholder value

Job Skills

Additional Job Details

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Our Employment Opportunities

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One RBC. We believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.