Associate Director, Technical Data Specialist, Regulatory Reporting Data Strategy

Technical Specialist

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.

What will you do?

• 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

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
• 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 Have :

• 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

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