Senior ETL Developer Snowflake Python

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

Job summary

A major financial institution in Halifax is seeking a Senior Software Developer to join their Corporate Treasury Technology team. The role involves developing applications to meet business needs and collaborating with various IT partners. The ideal candidate will have extensive experience with Snowflake and Python, along with a strong understanding of ETL platforms. This position offers competitive compensation, bonuses, and opportunities for professional growth in a supportive environment.

Benefits

Comprehensive Total Rewards Program

Flexible work/life balance options

Opportunities for career development

Qualifications

• Minimum of 3 years of professional experience as a Data Engineer.
• Proven technical expertise with Snowflake.
• Experience with workflow orchestration tools for managing data pipelines.

Responsibilities

• Coordinate design and implementation phases for projects.
• Participate in walkthrough reviews of technical specifications.
• Support deployment and provide resolutions to technical issues.

Skills

Snowflake

Python programming

ETL platforms

SQL database querying

Unix shell scripting

Data pipelines management

Education

Bachelor's degree in information technology or Computer Science

Tools

Apache Airflow

Stonebranch

Autosys

Job description

Overview

This is a Senior Software Developer role within the Corporate Treasury Technology team. You will be responsible for delivering applications designed to resolve business system needs while working closely with various partners across IT. You will be involved in all aspects of the development and/or maintenance process within a well-established team. The preferred candidate should have hands-on strong development experience in Snowflake, Python, and any ETL Platform.

Responsibilities

• Coordinate design / implementation phases for projects, identifying, tracking and resolving technical issues

• Participate in walkthrough reviews of technical specifications, programs and unit test plans

• Provide estimates on activities/tasks required to perform design, coding and unit testing, improving accuracy over time

• Facilitate business meetings for technical design, problem solving and task implementation

• Support Deployment / Releases and provide resolutions to technical issues found in Production environment

• Possible off-hours support for urgent technical issues

What do you need to succeed?

• Must-have

• Bachelor’s degree in information technology, Computer Science, or a related technical discipline with a minimum of 3 years of professional experience as a Data Engineer, demonstrating expertise in Snowflake and proficiency in Python programming

• Proven technical expertise with ETL platforms, SQL database querying, and Unix shell scripting; practical experience with SQL Server environments

• Excellent problem-solving abilities with a track record of translating business requirements into scalable technical solutions that seamlessly integrate ETL workflows with database systems

• Experience with workflow orchestration and scheduling tools such as Stonebranch, Apache Airflow, Autosys, or similar platforms for managing data pipelines

• Experience working on projects developing and implementing applications for business stakeholders

• Dig deep into performance, scalability, capacity and reliability problems to resolve them

• Experience with design patterns, data structures and algorithms, strong mathematical/ analytical background

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

• Flexible work/life balance options

• Opportunities to do challenging work

• Opportunities to take on progressively greater accountabilities

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

Inclusion and Equal Opportunity Employment

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

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.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.