What is the opportunity?

RBC’s AML are looking to expand our data ingestion platform team. You’ll be working as part of a team to build automation solutions for data ingestion from various sources into S3 and Snowflake for terabytes of data.

What will you do?

• Work within an Agile product team to design, develop and maintain data ingestion flows and evolve the platform to orchestrate them.

• Design and implement data pipelines and ETL processes.

• Ensure data quality, security, and performance.

• Develop and optimize SQL queries, stored procedures, and views.

• Integrate Snowflake with other data sources and BI tools.

• Collaborate with data engineers, analysts, and business stakeholders.

• Monitor and troubleshoot data jobs and platform issues.

• Collaborate with our developers and cross-functional teams to integrate data capabilities into existing and new applications.

• Develop and maintain comprehensive documentation for data pipelines, transformations and data models.

• Foster knowledge and collaborative functions

• Gather functional requirements and translate them into technical specifications. This includes interfacing with other engineers, project managers, business analysts and end users.

• Collaborate with other team members on resolving technical issues, improving current products and developing new features.

What do you need to succeed?

Must Have:

• 5+ years of Experience with Big Data technologies used for ETL: Spark, Yarn, Hive, Hadoop

• Strong SQL skills and knowledge of data modeling.

• Experience with Scala & Snowflake cloud data platform.

• Experience with ETL tools (e.g., Informatica, Talend, Apache Airflow).

• Familiarity with cloud platforms (AWS, Azure, or GCP).

• Knowledge of Python or other scripting languages is a plus.

• Excellent problem-solving and communication skills.

• Bachelor’s or master’s degree in computer science, Data Engineering and, or a related field.

• Knowledge of SCM, Infrastructure-as-code, and CI/CD pipelines.

Nice to Have:

• Experience with workflow management tools like: Apache Airflow

• Experience with Continuous Integration tools - Jenkins, GitHub, Automated Testing tools, Git, or similar tools.

• Experience with Docker/Kubernetes/Containers

What's in it for you?

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable
• 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
• A world-class training program in financial services
• Flexible work/life balance options
• Opportunities to do challenging work
• Opportunities to take on progressively greater accountabilities    
• Opportunities to building close relationships with clients
• Access to a variety of job opportunities across business and geographies

#LI-POST

#TECHPJ

Job Skills

Active Learning, Agile Methodology, Application Integrations, Detail-Oriented, Enterprise Application Delivery, Group Problem Solving, Programming Languages, Software Development Life Cycle (SDLC)

Additional Job Details

410 GEORGIA ST W, FLOOR 3:VANCOUVERVancouverCanada37.5Full timeTECHNOLOGY AND OPERATIONSRegularSalaried2026-01-122026-02-27

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

Inclusion and Equal Opportunity Employment

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