Job DescriptionWhat is the Opportunity?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 12 Kafka/Event Streams 12 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
What19s in it for you? - 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 SkillsAccounting Finance, Financial Instruments, Financial Statement Analysis, Investment Management, Investment Operations, Investment Reporting, Operational Delivery, Performance Management (PM), Resource Coordination
Additional Job DetailsAddress:GOLDMAN SACHS TOWER, 30 HUDSON STREET:JERSEY CITY
City:Jersey City
Country:United States of America
Work hours/week:40
Employment Type:Full time
Platform:CAPITAL MARKETS
Job Type:Regular
Pay Type:Salaried
Posted Date:2026-05-14
Application Deadline:2026-07-10
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
