Director of Engineering

RBC; Calgary; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading financial services company in Calgary is looking for an experienced data engineer to drive the development of scalable data pipelines. The successful candidate will have over 10 years of experience in Python and SQL, with strong knowledge of data architecture and the ability to collaborate with various business stakeholders. This role offers a flexible benefits program, competitive compensation, and opportunities for development in a dynamic team environment.

Benefits

Competitive compensation

Comprehensive Total Rewards Program

World-class training program

Qualifications

• BSc in computer science or technical field; coding experience preferred.
• 10+ years of experience in Python and SQL development.
• Extensive experience with data architecture and dimensional data modeling.

Responsibilities

• Develop scalable, high-performance data pipelines.
• Lead the integration of data with cloud platforms.
• Collaborate to gather requirements for data systems.

Skills

Python development

SQL

Data engineering

Collaboration with business stakeholders

Agile methodologies

Education

Bachelor’s degree in computer science or related field

Master’s degree (nice to have)

Tools

Python

PySpark

Databricks

Airflow

Kafka

Snowflake

Node.JS

Angular

Job description

Job Description

Drive the development of scalable, high-performance data pipelines within the Enterprise Data Platforms for enabling seamless access to and analysis of data across the organization. This role requires a strong technical background, strategic mindset, and excellent leadership capabilities.

What will you do?

This role will encompass an end-to-end Data Integration view from data sourcing, lineage, transformation, and storage to support complex advanced analytics and AI, and require extensive collaboration with Business architecture, System architecture, Business SME and Data Stewards.

• Work with the Business SMEs and Platform leads to understand and determine best mix of development and technical data solutions to meet business requirements and project objectives.
• Lead the build of batch and real-time data pipelines (inbound, outbound).
• Integrate data with Cloud based platforms and publish curated data products for consumption.
• Participate in Data management requirements and support Data and AI needs of business and technology stakeholders.
• Work in an agile team of Data Engineers, Developers and RBC business stakeholders.
• Collaborate with data scientists, process engineers and business stakeholders on requirement gathering and assist with prescriptive and predictive analytics through consolidated data pipelines.

Must Have

• Bachelor’s degree in computer science or related technical field involving coding (e.g., physics or mathematics), or equivalent technical experience.
• Broad experience with hands-on experience in data engineering and technologies.
• 10+ years of Python development and SQL experience (Spark and Databricks-specific SQL is a plus).
• Extensive experience with schema design, dimensional data modeling, and scalable data architecture.
• Strong knowledge of algorithms and data structures.
• Working knowledge of the Data Engineering Tech Stack: Python, PySpark, Databricks, Airflow, Kafka, Snowflake, API: Node.JS, Apigee, Portal/analytics solutions: Angular, Security frameworks: LDAP, Kerberos, OAuth 2.0, Vault integration.

Nice to have

• Master’s degree in computer science or equivalent experience.
• Automation/DevOps: GIT Actions, Selenium and similar technologies.
• Experience working in Agile/SAFe environment.

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,, and high-performing team.
• A world-class training program in financial services.
• Opportunities to do challenging work.

Equal Opportunity