Senior Data Engineer

Royal Bank of Canada•Minneapolis, MN

8d•$80,000 - $140,000

About The Position

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

Requirements

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 Haves

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

Responsibilities

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

Benefits

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

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume