Lead Database Developer at RBC

Elevate your career with RBC as a Lead Database Developer focused on designing and optimizing scalable data systems. You will modernize our data infrastructure while driving impactful analytics and business intelligence solutions.
As a Lead Database Developer at RBC, you will leverage over 8 years of database experience to shape data architectures and mentor junior engineers. Your main tasks include designing schemas, developing ETL pipelines, and optimizing complex database queries to support data-driven decisions throughout the organization.
Key Responsibilities:
• Design and implement efficient database schemas across SQL Server and PostgreSQL
• Develop and maintain complex ETL pipelines and data integration solutions
• Optimize reporting data models including dimensional models and star schemas
• Write and optimize T-SQL, PL/pgSQL, and database code for performance
• Conduct performance tuning and implement data governance practices
Requirements:
• 8+ yea...