Lead Database Developer, GFT

RBC • Toronto, ON

1d • Onsite

About The Position

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.

Requirements

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

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

Responsibilities

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

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed