Lead Data Engineer & Operations Support

ODAIA; Toronto; On-site; CAD 110,000 - 170,000; Full time

Benefits offered by this job

Total Rewards Program

Job summary

RBC in Toronto, Ontario seeks a senior analytics engineer to own end-to-end data solutions for an AI-ready platform. You will shape data flows, enable AI/ML consumption, and deliver production-grade analytics for decision-makers.

You will mentor teams, drive governance, and partner across data engineering, data science, and business units to ensure scalable, trusted insights across the enterprise.

Qualifications

• 10+ years of progressive experience in analytics/engineering with enterprise-scale delivery.
• Experience leading cross-functional data initiatives from requirements through production.

Responsibilities

• Lead requirements definition and translate business needs into technical specs for data, AI/ML features, and governance.
• Drive analyses on customer behavior, product performance, and campaign outcomes for AI-enabled insights.
• Architect and own dashboards, scorecards, and executive reporting frameworks for senior leadership.
• Bridge business stakeholders, engineering, and data science to validate mappings and ensure data quality for AI/ML pipelines.
• Lead production readiness reviews and continuous improvement to ensure scalable, accurate solutions.
• Mentor junior analysts and engineers in analytics engineering and data quality best practices.

Skills

Big Data Management

Cloud Computing

Database Development

Data Mining

Data Warehousing

ETL Processing

Group Problem Solving

Quality Management

Requirements Analysis

Tools

Kafka

Schema Registries

Debezium

GraphQL

ELK Stack

OpenShift

Kubernetes

S3

GitHub Actions

Job description

Job Description

What is the opportunity?

The Engineering team is driving multiple complex, enterprise-wide initiatives to build RBC's next-generation data platform — one that is AI-ready, scalable, and trusted across the organization. In this senior role, you will serve as a technical lead and strategic partner: shaping how data flows, how AI/ML systems consume it, and how analytics insights reach decision-makers. You will own end-to-end delivery — from requirements through production — while mentoring teams and influencing platform direction.

What will you do?

• Lead requirements definition and translate complex business needs into precise technical specifications: data contracts, transformation logic, AI/ML feature requirements, non-functional requirements, and acceptance criteria.

• Drive deep-dive analyses on customer behavior, product performance, campaign outcomes, and channel effectiveness — with a lens toward AI-augmented insight generation and predictive opportunity identification.

• Architect, build, and own dashboards, scorecards, and executive reporting frameworks; define standards for how data products are presented to senior leadership.

• Act as a technical bridge between business stakeholders, engineering, and data science teams — validating source-to-target mappings, enforcing data quality, and ensuring AI/ML pipelines consume reliable, well-governed data.

• Lead production readiness reviews, post-implementation validation, and continuous improvement cycles to ensure solutions are accurate, stable, and performing at scale.

• Mentor and guide junior analysts and engineers; establish best practices for analytics engineering, data quality, and AI-ready data design across the team.

• Data Pipeline Monitoring & Maintenance

• Troubleshooting & Incident Response

• Troubleshoot connections to databases, data warehouses, APIs, and external systems

• Data Connectivity & Integration Support

• Document troubleshooting procedures and known issues

• Help data analysts and business users troubleshoot data access issues

• Lead the implementation for proactive improvements like caching, indexing, and data partitioning strategies.

What do you need to succeed?

Must have:

• 10+ years of progressive experience as a data analyst, analytics engineer, or senior business systems analyst — with a track record of delivering at enterprise scale.

• Proven ability to lead complex, cross-functional data initiatives from ambiguous requirements through production delivery.

• Deep expertise in data mapping, acceptance criteria definition, UAT leadership, and production validation for analytics or data platform solutions.

• Expert-level SQL: complex multi-table joins, window functions, query optimization, and performance tuning on large enterprise datasets.

• Strong understanding of AI/ML workflows and how data platforms must be designed to support feature engineering, model training pipelines, and real-time inference.

• Hands‑on knowledge of Kafka, schema registries, and event streaming concepts — including schema evolution, data contracts, and event quality validation.

• Deep familiarity with modern data platform architectures: data warehouses, Lakehouses (e.g., Delta Lake, Iceberg), and how they serve both BI and AI use cases.

• Exceptional stakeholder communication skills: able to translate technical complexity into clear narratives for senior and executive audiences.

Nice-to-have:

• Domain experience in financial services — banking, credit data, or regulatory reporting.

• Familiarity with LLM/GenAI integration patterns: RAG pipelines, embedding workflows, or AI-assisted analytics.

• Experience with GitHub Actions and CI/CD for data pipelines.

• Knowledge of Debezium, GraphQL, or ELK Stack (Elasticsearch / Logstash / Kibana).

• Hands‑on experience with cloud-native platforms: OpenShift, Kubernetes, S3 object storage.

• MongoDB experience: querying semi‑structured data, aggregation pipelines for analytics use cases.

• Proficiency with BI tools (Tableau, Power BI) and data quality frameworks for trusted, governed reporting.

What’s in it for you?

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation and pension plan.

• Leaders who support your development through coaching and managing opportunities

• Work in a dynamic, collaborative, progressive and highly performing team

• Opportunities to do challenging work, making a difference and lasting impact on communities.

• Enjoy a comfortable work environment with the option to dress casually.

• Network and build lasting relationships with developers from diverse backgrounds from across Canada and the world.

Job Skills

Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Quality Management, Requirements Analysis

Additional Job Details

Address: RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTO

City: Toronto

Country: Canada

Work hours/week: 37.5

Employment Type: Full time

Platform: TECHNOLOGY AND OPERATIONS

Job Type: Regular

Pay Type: Salaried

Posted Date: 2026-08-20

Application Deadline: 2026-09-20

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.