Lead data and AI Engineer

What is the opportunity?

Join our team as a Data Engineer to build modern data infrastructure using Dagster, dbt, and PostgreSQL. You will design and implement scalable ELT pipelines following medallion architecture patterns, while contributing to full-stack development with React and TypeScript. This role offers the opportunity to work at the intersection of data engineering and AI, integrating LLM capabilities into our data products.

What will you do?

• Design and develop data pipelines using Dagster for orchestration, including component-based architecture, YAML-driven asset definitions, sensors, and schedules

• Build and maintain dbt models with incremental materializations, snapshots, macros, and comprehensive testing frameworks

• Implement medallion architecture patterns across Bronze, Silver, and Gold layers to ensure data quality and accessibility

• Develop REST APIs using FastAPI with async endpoints to serve data products to internal and external consumers

• Build responsive frontend interfaces using React 19, TypeScript, and TanStack ecosystem components with TailwindCSS styling

• Integrate AI and LLM capabilities including RAG pipelines, Model Context Protocol, and tool use patterns into data applications

• Manage containerized deployments using Docker and maintain CI/CD workflows through GitHub Actions

• Collaborate with cross-functional teams to understand data requirements and deliver solutions that drive business value

What do you need to succeed?

Must Have

• Strong proficiency in Python and TypeScript for building production-grade applications

• Working knowledge of PostgreSQL for data warehousing and DuckDB for analytical workloads

• Frontend development skills with React for building user interfaces

• Familiarity with Docker containerization, Git version control, and CI/CD pipeline development

• Demonstrated experience designing and implementing ELT pipelines with data quality frameworks

Nice to Have

• Experience with dbt MetricFlow and semantic layer design for metrics definitions

• Experience with Dagster for data orchestration and dbt for data transformation and modelling

• Knowledge of GraphQL, LDAP directory services, and OAuth 2.0 authentication protocols

• Exposure to AI/LLM integration patterns including RAG, Model Context Protocol, and function calling

• Familiarity with the TanStack ecosystem including Query, Router, Table, and Start

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

• Opportunities to do challenging work

• Opportunities to take on progressively greater accountabilities.

#LI-Post

#TECHPJ

Job Skills

Actuarial Modeling, Big Data Management, Commercial Acumen, Data Mining, Data Science, Decision Making, Machine Learning (ML), Natural Language Processing (NLP), Predictive Analytics, Python (Programming Language)

Additional Job Details

90 WESTERN PKY:BEDFORDBedfordCanada37.5Full timeCAPITAL MARKETSRegularSalaried2026-04-172026-05-03

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

Our Employment Opportunities

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One 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.