Staff Platform/Data Engineer

Key Skills

Data Engineering, Data science techniques, Data security, Data Visualization, Infrastructure-as-code-IaC, PowerBI, Tableau, Terraform

Job Description

We are seeking a highly skilled and experienced Staff Platform Engineer / Data Engineer to join our dynamic team at RBC Borealis. The ideal candidate will have extensive experience with Snowflake and a strong background in platform engineering. This senior role will be pivotal in designing, implementing, and maintaining our data platform to ensure efficient and secure data operations, as well as mentoring junior team members and leading key projects.

Your responsibilities include:

• Design and Development: Architect, develop, and maintain scalable data pipelines and ETL processes using Snowflake;
• Data Integration: Integrate data from various sources into Snowflake, ensuring data quality and consistency;
• Performance Optimization: Optimize Snowflake performance, including query tuning and resource management;
• Security and Compliance: Implement and manage data security measures to ensure compliance;
• Leadership: Mentor and guide junior platform engineers, providing technical leadership and fostering a collaborative team environment;
• Project Management: Lead key platform engineering projects, ensuring timely delivery and alignment with business objectives;
• Collaboration: Work closely with data scientists, analysts, and other stakeholders to understand data requirements and deliver solutions;
• Monitoring and Maintenance: Monitor data platform performance and troubleshoot issues as they arise;
• Documentation: Create and maintain comprehensive documentation for data processes, architectures, and workflows.

You're our ideal candidate if you have:

Must have:

• Bachelor’s degree in Computer Science, Information Technology, or a related field;
• 7+ years of experience in data engineering or a related field;
• Proven experience with Snowflake, including data modelling, performance tuning, and security;
• Experience with ETL tools and processes;
• Deep Knowledge of Snowflake is a MUST.
• Familiarity with other data platforms and tools (e.g., AWS, Azure, Databricks, Hadoop, etc.) is a plus;
• Familiarity with Rundeck, Redhat Openshift, Github;
• Proficiency in SQL and experience with complex queries;
• Experience with programming languages such as Python, Java, or Scala;
• Knowledge of data warehousing concepts and best practices;
• Familiarity with data governance and data quality frameworks;
• Knowledge of IaC technologies (Terraform);
• Proven ability to lead and mentor a team of engineers;
• Strong project management skills and experience leading complex projects;
• Strong problem-solving skills and attention to detail;
• Excellent communication and collaboration skills;
• Ability to work in a fast-paced, dynamic environment.

Nice to have:

• Experience in the banking or financial services industry;
• Certifications in Snowflake or related technologies;
• Experience with data visualization tools (e.g., Tableau, Power BI).

What's in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable;
• Leaders who support your development through coaching and managing opportunities
• Ability to make a difference and lasting impact;
• Work in a dynamic, collaborative, progressive, and high-performing team;
• A world-class training program in financial services;
• Flexible work/life balance options;
• Opportunities to do challenging work.

About RBC Borealis

RBC Borealis is the driving force behind Royal Bank of Canada’s AI and data innovation. As part of Canada’s largest financial institution, we bring together a team of architects, engineers, scientists, and product experts on a mission to revolutionize finance through world-class research, solutions, and a resilient data platform. With locations across Toronto, Waterloo, Montreal, Calgary, and Vancouver, we’re at the forefront of AI research and platform development. With a focus on cutting-edge research in areas like time series forecasting, causal machine learning, and responsible AI, we are seamlessly integrating AI research and data engineering, to solve critical challenges in the financial industry. We are building intelligent, and scalable, data-driven solutions that will help communities thrive and drive innovation for our customers across the bank.

Inclusion and Equal Opportunity Employment

RBC is an equal opportunity employer committed to diversity and inclusion. We are pleased to consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veterans status, Aboriginal/Native American status or any other legally-protected factors. Disability-related accommodations during the application process are available upon request.