Senior Data Engineer

Socket.dev; Vancouver; On-site; CAD 110,000 - 150,000; Full time

Job summary

RBC is seeking a Senior Data Engineer to develop, maintain, and enhance the Finance Data Platform. The role focuses on data ingestion, enrichment, reconciliation, analytics, and reporting for financial datasets using Airflow, Databricks, and related tools.

You will collaborate with product and engineering teams to translate business requirements into scalable data solutions, while ensuring documentation and training are in place and providing mentorship to peers.

Qualifications

• Total Experience 5+ years, with 2-3 years Spark experience.
• Solid experience with Hadoop/Hive ETL/data-pipelines or Cloudera.
• SQL/Oracle or ANSI SQL experience.
• Experience on Windows/Unix/Linux OS.
• Undergraduate CS/engineering degree.
• Strong communication and time management skills.

Responsibilities

• Collaborate with Product Owner/Manager/Lead to determine optimal tech solutions.
• Engage in detailed design and development, tracking issues.
• Ensure solutions align with data/architecture strategy.
• Document technical references and provide training.
• Support production issues for the application.
• Coordinate QA testing and verification with QA team.
• Mentor teammates and share knowledge.

Skills

Spark (Scala/Python)

Big Data

Databricks

Airflow

DBT

SQL

Oracle/PL-SQL

Windows/Unix/Linux

Communication

Time management

Education

Undergraduate degree/diploma in CS/Engineering

Tools

Hadoop/Hive

Cloudera

GitHub

Jenkins

Confluence

Docker

Kubernetes

Job description

Job Description

What is the opportunity?

In this role as a Senior Data Engineer, you will be responsible for development deliverables for the Finance Data Platform. The Platform, leverages Airflow and Databricks and serves as the central repository of finance related datasets, with capabilities including the ingestion of positional/trade, sub-ledger, general-ledger trial balances, and reference data; as well as data enrichment, adjustment, reconciliation, analytics and reporting functions.

What will you do?

• Work with the Product Owner, Product Manager, and Development Lead to understand and determine best mix of development and technical solutions to meet business requirements and project objectives.
• Work on detailed design and development phases of project initiatives; identifying, tracking and resolving technical issues.
• Ensure design/development solutions are aligned to the data/architecture strategy.
• Ensure adequate technical/reference documentation and training is in place.
• Provide assistance to the application support team in troubleshooting and resolving production issues.
• Coordinate with the Quality Engineering team on all aspects of testing and verification, ensuring quality assurance testing is performed for all changes.
• Impart knowledge, benefit of experience, and mentoring to other members of the team.

Must-have:

• Total Experience 5+ years’ , with atleast 2-3 years experience with Spark (Scala/Python) , Big Data ,Databricks, Airflow ,DBT
• Solid experience (as evidenced by resume) with Apache Hadoop/Hive ETL/data-pipelines or other big-data platform technology/tools Cloudera
• Solid experience (as evidenced by resume) with SQL, Oracle/PL-SQL or any ANSI-compliant RDBMS platform preferred.
• Experience on Windows/Unix/Linux OS.
• Undergraduate degree/diploma in computer science/engineering or related technology discipline.
• Solid communication and time management skills.

Nice-to-have:

• Demonstrable experience with DevOps tools/technologies, including continuous integration/delivery tools and technologies such as GitHub, Jenkins, Synk, JIRA, Confluence, Airflow
• Demonstrable experience with containerization tools and technologies such as Docker, Kubernetes, Redhat OpenShift Container Platform (OCP).
• Experience with Capital Markets or other financial technology services’ middle/back office environments.
• Experience with/exposure to cloud technology platforms such as PCF (on-prem), AWS. Azure (off-prem).
• Experience with/exposure to Business Intelligence (BI)/Analytics/Reporting tools, such as Tableau, Datameer, Power BI, Presto, Snowflake, Apache Superset, etc.
• Experience with/exposure with Test driven development (TDD) and automated unit testing.

Job Skills

Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Quality Management, Requirements Analysis

Additional Job Details

Address: 745 THURLOW ST:VANCOUVER

City: Vancouver

Country: Canada

Work hours/week: 37.5

Employment Type: Full time

Platform: TECHNOLOGY AND OPERATIONS

Job Type: Regular

Pay Type: Salaried

Posted Date: 2026-07-27

Application Deadline: 2026-11-29

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Our Employment Opportunities

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One RBC. We believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.