Data Engineer

What is the opportunity?

We are seeking a skilled and motivated Data Engineer to join our Business Insights and Analytics team. The ideal candidate will have a strong background in designing, building, and maintaining scalable data pipelines and architectures. You will work closely with data scientists, analysts, and software engineers to ensure efficient data flow and optimize data systems. This role sits at the intersection of technology and business, providing a unique opportunity to influence the digital vision for Wealth Management.

Within WM Business Initiatives and insights, the Data Engineering team is responsible for driving 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. 

We are looking for an innovative data engineer with familiarity in software engineering best practices, who are interested in building robust, scalable, and reproducible ETL and data pipelines. This role will be in support innovative products and allocations, Data Science POCs, and longer-term reports and analytics within a lean and agile team. We utilize a range of technologies including but not limited to Snowflake Cloud, AWS, MSSQL Server, PostgreSQL, MongoDB, Hadoop, and Azure cloud.

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.

• 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.

• Work with cloud platforms (AWS, Azure, GCP) to deploy and manage data infrastructure.

• Ensure data quality, integrity, and accuracy through validation and cleansing processes.

• Document technical processes, configurations, and data flow diagrams.

• Collaborate with cross-functional teams to understand data requirements and translate them into technical solutions.

• Be a part of a start-up like setting where “failing fast" is highly valued, level of uncertainty is high, and requirements are not all defined in advance.

These job duties are ideal for someone interested in applying software engineering best practices (including testing, CI/CD, and code readability.

What do you need to succeed?

Must have

• Bachelor’s degree in computer science or related quantitative discipline (e.g., IT, 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 (like PostgreSQL), including stored procedures, views, and ETL processes (Extract, Transform, Load).

• Experience with other data stacks, including data warehouses (e.g., Snowflake), AND NoSQL databases (e.g., MongoDB)

• Proficiency in programming languages such as Python

• Strong software engineering fundamentals, including version control (git), CI/CD, and the ability to write readable, maintainable code that can go through code reviews by experienced developers.

• Experience developing and optimizing complex SQL queries in order to generate data sets for our data science and data reporting & visualization teams.

• Experience with writing testable, robust code that ensures data quality throughout all stages of acquisition and processing, including data sourcing/collection, normalization, and transformation.

• Sound understanding of the differences between databases, data warehouses and data lakes, and the various file formats in ETL workflows (e.g., Parquet, Avro, Trino)

• Excellent problem-solving skills and ability to work in a fast-paced environment.

Nice-to-have

• Experience with big data technologies, including streaming (e.g., Spark, Kafka, Flink).

• Experience in pipelining end-to-end ETL workflows via tools like Airflow or Prefect.

• Experience with building local development workflows in Docker containers and docker-compose.

• Experience using cloud-enabled technologies such as Amazon Web Services (AWS), specifically S3, Athena, EMR, RDS, or other AWS database related products.

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 and innovation to existing workflows.

• Ability to make a difference and lasting impact.

• Work in a dynamic, collaborative, progressive, and high-performing team.

Job Skills

Big Data, Big Data Management, Cloud Computing, Data Administration, Data Architecture, Database Development, Database Structures, Data Management, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Management Reporting, Parsing, Processing, Programming Languages, Quality Management, Requirements Analysis, Unstructured Data

Additional Job Details

RBC CENTRE, 155 WELLINGTON ST W:TORONTOTORONTOCanada37.5Full timeWEALTH MANAGEMENTRegularSalaried2024-10-172024-11-02