Associate Director, Technical Data Specialist, Regulatory Reporting Data Strategy

Technical Specialist – Data Lineage

RBC Capital Markets (RBC CM) is seeking a technical specialist responsible for documenting, validating, and maintaining end‑to‑end data lineage across the Capital Markets technology ecosystem. The role goes beyond business‑level data mapping to trace actual data flows across systems, tools, and platforms, and supports enterprise data governance and compliance initiatives.

• 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 and 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.

• Bachelor's degree in Computer Science, Information Technology, Data Science, or related field; or equivalent professional experience.
• 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.
• 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 liaise effectively with diverse teams and clients.

• 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.

• Competitive compensation and flexible benefits, including a 401(k) program with company‑matching contributions.
• Health, dental, vision, life, and disability insurance.
• Paid time off.
• Opportunities for coaching and professional development.
• Dynamic, collaborative, and high‑performing team environment.
• Chance to make a meaningful impact on clients and communities.

The expected salary range for this position is $125,000 – $190,000 USD, depending on experience, skills, and market conditions. Additional discretionary variable compensation may be available based on performance targets.