Lead Database Developer, GFT

Royal Bank of Canada Voir toutes les offres

  • Toronto, ON
  • Permanent
  • Temps-plein
  • Il y a 1 jour
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:
  • Experience with multiple database platforms and ability to evaluate trade-offs between different technologies.
  • 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 streaming data platforms like Kafka or similar message-oriented systems.
  • Knowledge of business intelligence and analytics tools like Tableau, Power BI, or similar.
  • Experience with machine learning pipelines and feature engineering data models.
  • Understanding of data security, encryption, and compliance requirements in regulated industries.
  • Experience building data lakehouse architectures or modern data stack implementations.
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.
Job Skills Active 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:TORONTOCity: TorontoCountry: CanadaWork hours/week: 37.5Employment Type: Full timePlatform: TECHNOLOGY AND OPERATIONSJob Type: RegularPay Type: SalariedPosted Date: 2026-04-15Application Deadline: 2026-05-19Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date aboveOur Employment OpportunitiesAt 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.Join our Talent CommunityStay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at .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.

Royal Bank of Canada