Data Engineer
Job Overview
Job title: Data Engineer
Job description: What is the opportunity?
Wealth Management Applied Analytics and Innovation (WM AI) is responsible for developing and implementing a data and analytics strategy that delivers data reporting key insights to Senior Management, Advisors and supporting functions across RBC Wealth Management. The team leverages deep experience in data engineering, programming, business strategy, data science, and visualization techniques to support its goal of empowering the organization with actionable insights to drive its ongoing success.
Within WM AI, the Data Science team is responsible for driving data reporting as well as advanced insight and innovation for the Wealth Management business by leveraging emergent big-data technologies, machine learning techniques, and data sources from across Wealth Management and RBC.
This Data Engineering role is an opportunity to perform product development, programming, ETL and database work in support of Data Science, Data Reporting & Visualization, and Product Development functions within a small team using technologies including but not limited to SQL Server, AWS, Python, C#, SSIS, AWS, Windows, Linux, and the Apache Hadoop ecosystem.
What will you do?
Design, develop, implement and support our emerging big data analytics capabilities through the development and maintenance of advanced data ingestion, processing, modeling and reporting capabilities.
Design and implement new or enhanced data processes or tools.
Ensure that your work is well-documented and developed in conjunction with other data engineers and the Data Visualization and Data Science teams.
Assist in current day-to-day support activities of Data Visualization and Data Science teams, including generating reporting data sets for business users using Tableau, Excel, or other delivery methods.
Be a part of a start-up like setting where fast-fail is highly valued, level of uncertainty is high and requirements are not all defined in advance.
The work is for someone interested in computer science, data, application and ETL development.
What do you need to succeed?
Must have
Bachelor’s Degree in Computer Science or related quantitative discipline (e.g., Engineering, Physics, Mathematics, Statistics, Economics)
3+ years’ proven experience in database design, data manipulation and/or software engineering role using SQL Server or similar RDBMS environments, including stored procedures, views, and ETL processes (Extract, Transform, Load).
Experience using cloud-enabled technologies such as Amazon Web Services (AWS), specifically S3, Athena, EMR, RDS, or other AWS database related products.
Drive to ensure data quality throughout all stages of acquisition and processing, including data sourcing/collection, normalization, and transformation.
Demonstrated knowledge of advanced SQL and at least one procedural/object-oriented programming language (Python, C, C#, Java, etc).
Excellent teamwork and collaboration skills.
Good communication with peers and end-users, to understand and translate the business requirements into data-related recommendations and solutions.
Nice-to-have
Experience with big data analytics technologies (e.g. Hadoop, Spark, Kafka); experience compiling, manipulating and analyzing large datasets, with a good understanding of data processing frameworks.
Experience developing SQL Server Integration Services would be beneficial.
Programming experience in Unix shell scripting.
Experience with dev-ops and continuous deployment models (e.g. Docker, Jenkins).
Experience using Git, Github, Zenhub.
Experience in agile design methodologies and frameworks.
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
Join our Talent Community
Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.
Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.
JOB SUMMARY
City: Toronto
Address: 155 Wellington Street West
Work Hours/Week: 37.5
Work Environment: Office
Employment Type: Permanent
Career Level: Experienced Hire/Professional
Pay Type: Salaried
Required Travel (%): 0
Exempt/Non-Exempt: N/A
People Manager: No
Application Deadline: 01/07/2022
Platform: Wealth Management
Req ID: 436116
Ad Code(s):
Company: Royal Bank of Canada
Expected salary:
Location: Toronto, ON
Job date: Sun, 19 Dec 2021 23:13:58 GMT
Job Source: Careerjet.ca