Senior Data Engineer

What is the opportunity?

The Sr. Data Engineer will be responsible for the ingestion, transformation, and maintenance of US Wealth Management data used to serve reporting and analytics needs for the business.  Working closely with Data Analyst and Data Architects, you will use your technical skills to understand and execute business requirements.

What will you do?

• Develop data ingestion using RBC Integrated Data Pipeline to move data from RBC network to Snowflake
• Build transformation layer following the medallion architecture in Snowflake
• Apply standardization and create facts and dimensions in Snowflake data warehouse
• Create reports and data products for business to consume
• Ensure quality of data pipelines via analysis and unit tests
• Set development standards and lead code reviews
• Mentor other team members to develop their skillsets and abilities

What do you need to succeed?

Must-have

• 5-10 years of experience working with ETL, databases & data warehouses
• Understanding Snowflake roles and user security
• Familiarity with Snowflake features such as SnowSQL, Snowpipe, Streams, and Tasks
• Experience designing solutions leveraging Snowflake native capabilities
• Hands-on experience with data ingestion and transformation
• Practical knowledge of SQL and Python

Nice-to-have

• Experience with cloud platforms such as AWS and Azure
• Automation and scripting experience
• Experience working in other programming languages such as Java & .NET

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
• Flexible work/life balance options
• Opportunities to do challenging work
• Opportunities to take on progressively greater accountabilities  
• Access to a variety of job opportunities across business

The good-faith expected salary range for the above position is $80,000 - $140,000 depending on factors including but not limited to the candidate’s experience, skills, registration status; market conditions; and business needs.  This salary range does not include other elements that comprise our total compensation package, which includes the following: commission sharing eligibility for select roles, a discretionary bonus, a paid time-off plan, our 401(k) program with company-matching contributions, and our health, dental, vision, life and disability insurance.

RBC’s compensation philosophy and principles recognize the importance of a highly qualified global workforce and plays a critical role in attracting, engaging and retaining talent that:

·       Drives RBC’s high performance culture

·       Enables collective achievement of our strategic goals

·       Generates sustainable shareholder returns and above market shareholder value

Job Skills

Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehouse ETL, Data Warehousing (DW), ETL Development, ETL Pipelines, ETL Processing, Extract Transform Load (ETL), Group Problem Solving, Python (Programming Language), Quality Management, Requirements Analysis, Snowflake (Platform), Snowflake Data Warehouse, Snowflake GenAI, Snowflake Schema

Additional Job Details

250 NICOLLET MALL:MINNEAPOLISMinneapolisUnited States of America40Full timeTECHNOLOGY AND OPERATIONSRegularSalaried2025-12-312026-01-07

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

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

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.