data engineer Toronto
Job description
Come Work with Us!
At RBC, our culture is deeply supportive and rich in opportunity and reward. You will help our clients thrive and our communities prosper, empowered by a spirit of shared purpose.
Whether you’re helping clients find new opportunities, developing new technology, or providing expert advice to internal partners, you will be doing work that matters in the world, in an environment built on teamwork, service, responsibility, diversity, and integrity.
Job Title
Job Description
What is the opportunity?
Wealth Management Digital and Data Transformation 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 design, 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 DDT, the Data Engineering 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, data engineering 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 Engineering, Data Visualization and Data Science teams, including generating reporting data sets for business users and senior management using Tableau, Web-based, 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 a software engineering role using SQL Server or similar RDBMS environments, including stored procedures, views, and ETL processes (Extract, Transform, Load).
Experience developing complex SQL queries in order to generate data sets for our data science and data reporting & visualization teams.
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.).
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.
Programming experience in Unix shell scripting.
Expertise in Microsoft Excel.
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.
Leaders who support your development through coaching and managing opportunities
Opportunity to try new things, bring fresh ideas, innovation
Ability to make a difference and lasting impact
Work in a dynamic, collaborative, progressive, and high-performing team
Job Summary
Address:
City:
Country:
Work hours/week:
Employment Type:
Platform:
Job Type:
Pay Type:
Posted Date:
Application Deadline:
Inclusion and Equal Opportunity Employment
At RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work. We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.
We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.
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 rbc.com/careers.
About RBC
CEO: David I. McKay
Revenue: $10+ billion (USD)
Size: 10000+ Employees
Type: Company - Public
Website: www.rbc.com
Year Founded: 1869
