Senior Data Developer

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

Job summary

Join a leading financial institution as a Senior Data Developer, where you'll oversee the full Software Development Life Cycle. You'll work in a dynamic environment, collaborating with various stakeholders to deliver robust data solutions. This role offers the chance to drive application modernization and continuous improvement while being part of a culture that values growth and collaboration.

Benefits

Comprehensive rewards program

Leadership support

Professional development opportunities

Access to world-class training

Qualifications

• 5+ years experience in RDBMS systems, SQL, and performance tuning.
• 5+ years designing ETL processes, preferably with DataStage.

Responsibilities

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

Skills

Communication

Presentation

Tools

SQL

IBM InfoSphere DataStage

Git

Hadoop

Snowflake

Tableau

React

.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 across various departments including Corporate Banking, Global Credit, Business & Client Services, Technology, Risk, Finance, Audit, Compliance, Commercial Banking, City National, and Wealth Management.

Role Overview

As a Senior Data Developer, your responsibilities encompass the full Software Development Life Cycle (SDLC), including requirements gathering, design, development, testing, deployment, and knowledge transfer to support teams. You will operate in a dynamic environment, managing multiple priorities, and communicating directly with data leads, IT architects, and business stakeholders to ensure your data solutions meet their needs.

Key Responsibilities

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 suitable technology solutions and designs that consider reusability, data sharing, user experience, performance, and security.
3. Drive application modernization and change initiatives.
4. Prepare high-level and detailed technical specifications.
5. Leverage best practices in continuous integration and delivery to enhance quality and efficiency.
6. Identify opportunities for continuous improvement and drive project progress and benefits.

Qualifications

Must Have

• 5+ years of experience profiling data within RDBMS systems (e.g., Sybase, MS SQL, DB2, Oracle), including writing queries (SQL, Stored Procedures) and query performance tuning.
• 5+ years designing and developing ETL processes, preferably using IBM InfoSphere DataStage or similar technologies.
• Understanding of Linux 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.
• Strong communication and presentation skills.

Nice-to-Have

• Background in Capital Markets, especially in Corporate Lending (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 in building standardized data interfaces (e.g., FpML, CDM) for reuse across services.

Benefits and Culture

We promote a culture of growth, collaboration, and community impact, offering a comprehensive rewards program, leadership support, and opportunities to make a meaningful difference. Our work environment is flexible, dynamic, and focused on professional development, with access to world-class training and challenging projects.

Additional Details

• Location: 335 8 Ave SW, Calgary, Canada
• Work hours: 37.5/week
• Employment Type: Full-time
• Application Deadline: May 24, 2025

Inclusion & Equal Opportunity

We are committed to fostering an inclusive workplace that values diversity and supports our employees' growth and success.

Join Our Talent Community

Stay updated on career opportunities at RBC by signing up for our talent community. Learn more about how we are making a difference at jobs.rbc.com.