Taro Logo

Lead Portfolio Data Engineer

Royal Bank of Canada is a global financial institution with approximately 84,000 employees serving 16+ million clients in Canada, the US, and 34 other countries.
Data
Senior Software Engineer
In-Person
5,000+ Employees
3+ years of experience
Finance

Description For Lead Portfolio Data Engineer

RBC, one of the largest banks in the world, is seeking a Lead Portfolio Data Engineer to join their team in Toronto. This role sits at the intersection of data engineering and investment technology, where you'll be responsible for building and maintaining scalable data infrastructure that powers critical business analytics.

The position requires expertise in modern data engineering tools, particularly Snowflake and SQL, combined with knowledge of investment data systems like Bloomberg AIM. You'll be working on designing and implementing data pipelines, optimizing performance, and ensuring data quality while collaborating with various stakeholders including Tableau developers and machine learning teams.

This is an excellent opportunity for an experienced data engineer who wants to work with financial data at scale. The role offers a comprehensive benefits package and significant career growth potential within a leading financial institution. RBC's commitment to innovation and their global presence provides an environment where you can make a meaningful impact while working with cutting-edge technologies.

The ideal candidate will bring both technical expertise in data engineering and an understanding of investment concepts, making this role perfect for someone looking to advance their career in financial technology. With RBC's collaborative culture and focus on employee development, you'll have opportunities to grow while working on challenging projects that support the bank's global operations.

Last updated 8 days ago

Responsibilities For Lead Portfolio Data Engineer

  • Design, build, and maintain extracts and design pipelines to ingest and transform data from investment and ALM systems
  • Structure data for optimal Tableau performance using Snowflake as the core data platform
  • Clean, enrich and normalize investment data for analysis
  • Develop and maintain scalable data models and schema design in snowflake
  • Implement data quality frameworks, validation and exception rules
  • Partner with Tableau Developers and machine learning developers
  • Automate and optimize query performance and data refresh cycles
  • Develop reusable pipelines for recurring processes

Requirements For Lead Portfolio Data Engineer

Python
  • Bachelor's or master's degree in computer science, data science, information systems or related field
  • 3+ years of experience in data engineering with Snowflake
  • Strong SQL skills and advanced experience in Snowflake schema design
  • Experience pulling data from Bloomberg AIM
  • Experience integrating investment data into BI environments like Tableau
  • Programming proficiency in Python, R, or similar (preferred)
  • Understanding of investment data concepts (preferred)
  • Excellent communication skills

Benefits For Lead Portfolio Data Engineer

Medical Insurance
Dental Insurance
Vision Insurance
  • Comprehensive Total Rewards Program including bonuses and flexible benefits
  • Competitive compensation
  • Professional development and coaching
  • Career growth opportunities
  • Collaborative and progressive work environment

Interested in this job?

Jobs Related To RBC Lead Portfolio Data Engineer