Senior Data Engineer
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
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.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
Number of Employees
5,001-10,000 employees
