Job DescriptionWhat is the opportunity?Are you a hands-on database developer who loves designing scalable data systems, optimizing complex queries, and building robust data solutions? RBC is looking for a Lead Database Developer to help build and modernize our data infrastructure, creating high-performance databases and data warehouses that power critical analytics, reporting, and business intelligence systems.
You'll spend the majority of your time designing schemas, developing ETL pipelines, optimizing database performance, and building reporting data models that enable teams across the organization to make data-driven decisions. If you're excited about solving complex data challenges, mentoring junior database engineers, and shaping the data architecture that powers RBC's operations, let's talk.
What will you do?- Design and implement efficient database schemas, data models, and dimensional structures optimized for both transactional and analytical workloads across SQL Server, PostgreSQL, and Snowflake.
- Develop, optimize, and maintain complex ETL pipelines and data integration solutions that reliably move data from source systems to target databases, data warehouses, and data marts.
- Build and optimize reporting data models including dimensional models, star schemas, and slowly changing dimensions that enable self-service analytics and business intelligence.
- Write and optimize T-SQL, PL/pgSQL, and other database code including stored procedures, functions, triggers, and views to ensure performance and maintainability.
- Conduct performance tuning and optimization of queries, indexes, and execution plans to meet SLAs and support growing data volumes and user concurrency.
- Design and implement data governance practices including data quality validation, monitoring, and lineage to ensure data accuracy and trustworthiness.
- Collaborate with analytics teams, business intelligence teams, and application developers to translate requirements into robust database solutions.
- Develop and maintain ETL validation frameworks and data quality checks to catch issues early and maintain system reliability.
- Lead database migration projects from legacy systems to modern platforms like Snowflake, ensuring data integrity and minimal downtime.
- Stay current with emerging database technologies and best practices, evaluating new tools and approaches that could improve data delivery and performance.
- Implement monitoring, alerting, and backup strategies to ensure database availability, disaster recovery, and business continuity.
What do you need to succeed?Must have:- 8+ years of hands-on experience developing and optimizing relational databases in production environments.
- Expert-level proficiency in SQL Server including T-SQL development, query optimization, indexing strategies, and performance tuning.
- 5+ years of experience with PostgreSQL including schema design, query optimization, and production administration.
- 3+ years of hands-on experience with Snowflake or similar cloud data warehouse platforms including schema design, optimization, and cost management.
- 5+ years of ETL development experience designing, building, and maintaining data integration pipelines using tools such as SSIS, Python, Airflow, dbt, or similar technologies.
- Proven experience designing and building dimensional data models, star schemas, and reporting database solutions.
- Deep understanding of database design principles including normalization, indexing strategies, constraints, and query optimization.
- Strong SQL skills including ability to write complex queries, stored procedures, functions, and views for both analytical and transactional workloads.
- Experience with data modeling tools and techniques including entity-relationship diagrams and dimensional modeling approaches.
- Proficiency with version control systems like Git for managing database code and scripts.
- Strong problem-solving skills and ability to troubleshoot complex database performance issues.
- Excellent written and verbal communication skills with ability to explain technical concepts to both technical and non-technical stakeholders.
Nice to have:- Knowledge of cloud platforms like AWS, Azure, or Google Cloud Platform and their data warehouse services.
- Experience with advanced ETL tools like Informatica, Talend, or enterprise data platforms.
- Familiarity with data governance frameworks, metadata management, and data lineage tools.
- Experience with machine learning pipelines and feature engineering data models.
- Understanding of data security, encryption, and compliance requirements in regulated industries.
What's in it for you?We believe in supporting our people to reach their potential and do meaningful work that makes a difference. You'll join a team where your technical expertise is valued and your contributions shape how data flows through the organization.
- Competitive compensation and benefits including flexible health and wellness options and stock where applicable.
- Leaders who support your development through coaching, technical mentorship, and career advancement opportunities.
- Access to modern data tools, cloud infrastructure, and technologies to work efficiently and innovate.
- Opportunity to work on large-scale data systems that power critical business operations across the organization.
- Professional development opportunities including training, certifications, and conference attendance.
- Clear career progression with opportunities to take on leadership roles or specialize in emerging technologies.
- Impact across the organization as your data solutions enable informed decision-making at scale.
#LI-POST
#TECHPJ
Job SkillsActive Learning, Agile Methodology, Application Development, Application Integrations, Database Design, Database Schemas, Database Technologies, Data Mart, Data Modeling, Data Warehouse, Detail-Oriented, Emerging Technologies, Enterprise Application Delivery, Extract Transform Load (ETL), Generative AI, Group Problem Solving, Machine Learning (ML), Programming Languages, Relational Database, Software Development Life Cycle (SDLC), Structured Query Language (SQL)
Additional Job DetailsAddress: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-04-15
Application Deadline:2026-06-15
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
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.
