Senior Data Engineer

Job Description

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.

• 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

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

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

• 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

Address: 250 NICOLLET MALL:

MINNEAPOLIS

City:
Minneapolis

Country:
United States of America

Work hours/week: 40

Employment Type:

Full time

Platform: TECHNOLOGY AND OPERATIONS

Job Type: Regular

Pay Type:

Salaried

Posted Date:

Final date to receive applications:

Note:

Applications will be accepted until 11:59 PM on the day prior to the Final date to receive applications date above

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.