Senior Data Developer

Royal Bank of Canada; Calgary; On-site; CAD 80,000 - 110,000; Full time

Job summary

Join a leading financial institution as a Senior Data Developer, where you will modernize operational processes and develop data solutions for various banking services. Collaborate with stakeholders to ensure data solutions meet business requirements while leveraging best practices in software development. Enjoy a dynamic work environment with opportunities for professional growth and a comprehensive rewards program.

Benefits

Comprehensive Total Rewards Program

Flexible benefits

Competitive compensation

Stock options

Flexible work/life balance options

World-class training in financial services

Qualifications

• 5+ years' experience with RDBMSs and SQL queries.
• 5+ years' experience designing ETL processes.

Responsibilities

• Develop and deploy reliable data solutions throughout the project lifecycle.
• Assess and analyze business needs to recommend technology solutions.

Skills

Active Learning

Detail-Oriented

Group Problem Solving

Programming Languages

Tools

IBM InfoSphere DataStage

SQL

Git

Hadoop

Snowflake

Tableau

.NET Core

Python

Job description

Join the Global Credit and Loans Technology team as we continuously deliver new solutions to modernize operational processes within our Loan Origination and Servicing business by delivering enterprise-grade data solutions. We are seeking a talented and adaptable data developer to help us build and maintain data solutions for our clients, including Corporate Banking, Global Credit, Business & Client Services, Technology, Risk, Finance, Audit, Compliance, Commercial Banking, City National, and Wealth Management.

As a Senior Data Developer, your day-to-day activities will encompass the full scope of our SDLC, including requirements gathering, design, development, testing, production deployments, and knowledge transfer to support teams. You will work in a fast-paced environment, managing competing priorities, and communicating directly with data leads, IT architects, and business stakeholders to understand use cases and ensure your data solutions are fit for purpose.

What will you do?

1. Develop and deploy reliable data solutions throughout the project lifecycle.
2. Assess, research, and analyze business and system needs, exploring alternative options to recommend technology solutions and designs that meet sponsor needs while considering reusability, data sharing, user experience, performance, and security.
3. Drive application change and modernization.
4. Prepare high-level and detailed technical specifications.
5. Leverage best practices in continuous integration and delivery to improve quality and velocity.
6. Identify opportunities for continuous improvement and drive project progress and benefits.

What do you need to succeed?

Must Have :

• 5+ years' experience profiling data within RDBMSs (Sybase, MS SQL, DB2, Oracle), including writing queries (SQL, Stored Procedures) and query performance tuning.
• 5+ years' experience designing and developing ETL processes using IBM InfoSphere DataStage.
• Understanding of Linux-based systems, shell scripting, DevOps processes, and source code management (Git).
• Experience in application data store concepts and building relational data structures that are robust and performant to meet business requirements.
• Strong written and oral communication skills, with excellent presentation abilities.

Nice-to-have :

• Background in Capital Markets, with a basic understanding of the Corporate Lending business (Loan Origination & Servicing).
• Experience with data lakes (Hadoop) and analytics platforms (Snowflake, Tableau).
• Knowledge of applications leveraging React, .NET Core (C#), IIS, Windows Servers, Liquibase, Docker, and Python.
• Experience building standardized data interfaces (FpML, CDM) for reuse across services.

What's in it for you?

We thrive on challenges, encourage progressive thinking, and work together to deliver trusted advice to help our clients thrive and communities prosper. We value each other, support professional growth, and aim to make a meaningful difference.

• Comprehensive Total Rewards Program including bonuses, flexible benefits, competitive compensation, commissions, and stock options where applicable.
• Supportive leadership for your development through coaching and management opportunities.
• Opportunity to make a lasting impact.
• Work in a dynamic, collaborative, and high-performing team.
• World-class training in financial services.
• Flexible work/life balance options.
• Challenging work opportunities.

Job Skills

Active Learning, Application Integrations, Detail-Oriented, Group Problem Solving, Programming Languages, Software Development Life Cycle (SDLC)

Additional Job Details

Address: 335 8 AVE SW, CALGARY

City: CALGARY

Country: Canada

Work hours/week: 37.5

Employment Type: Full-time

Job Type: Regular

Posted Date: 2025-04-29

Application Deadline: 2025-05-24

Note: Applications accepted until 11:59 PM the day prior to the deadline.

Inclusion and Equal Opportunity Employment

At RBC, we believe a diverse and inclusive workplace is key to our growth. We support our employees to perform at their best, collaborate effectively, innovate, and grow professionally, fostering a culture of respect, belonging, and opportunity for all.

Join our Talent Community

Stay informed about career opportunities at RBC. Sign up for updates on jobs, tips, and recruitment events that matter to you.

Discover how we use our passion and drive to enhance our clients' and communities' well-being at jobs.rbc.com.

Create a job alert for this search