This position will be part of the Commercial Loan Portfolio Management team and will work closely with the Portfolio Risk Oversight (PRO) Data Infrastructure & Innovation team under Group Risk Management (GRM). As a Senior Data Engineer in LPM team you will drive the development and deployment of modern data stack to organize, store, and transform Commercial Portfolio data assets. You will have a keen eye towards rapidly emerging open-source technologies and bring them in house to build data products & solutions. You will engage in open-source forums and bring that knowledge to build integrated solutions.

To succeed you should have a strong background in data engineering and analytics, including working with large datasets, developing complex pipelines, and building data-driven models. You will be shaping the future of our infrastructure, working within complex organization, data & infrastructure liaising within organization to find enterprise solutions and simplifying processes

What is the Opportunity?

We are looking for someone who can drive custom risk Analytics and Insights to business partners by building and operating a modern data stack for reporting & analytics working closely with the Portfolio Risk Oversight (PRO) Data Infrastructure & Innovation team under Group Risk Management (GRM). As a Senior Data Engineer, you will contribute to the overall success of the Commercial LPM oversight strategies and objectives. You are accountable for architecting, implementing and managing data models and data pipelines, developing, maintaining and upscaling the cloud data platform/services vital to the continued growth of broader LPM team

To succeed you will have to develop and maintain strong ties with business leaders to support decision making through a combination of custom analytics and the evolution with the support of PRO data infrastructure. The PRO team leverages modern data stack, which requires constant refinements and enhancements to provide business users with relevant and timely self-serve analytics. You will ensure that our LPM team is successful by leveraging the data in the best possible way. You will be a hands-on analytics practitioner and consultant to ensure that we track, maintain and analyze data in a way that leads us to optimize operational processes and make better business decisions.

What will you do?

• Support the LPM Analytics Team in the design, coordination, execution and monitoring of key transformational initiatives

• Provide architecture guidance, performance tuning and big data engineering expertise for use cases that require capabilities in Federated Queries, Data Ingestion and Distributed Computing

• Building and supporting data engineering pipelines in Python using PySpark and Apache Airflow

• Manage and optimizes an inventory of data sources. Responsible for compiling, aggregating, testing and validating different data repositories/sources for the dashboards ensuring completeness, accuracy, timeliness and integrity of information

• Develop data products by writing code that is modular, reliable, maintainable & replicable by leveraging open source data science libraries (Pandas, SQL Alchemy ,scikit-learn, airflow, pyarrow, nltk, spaCy)

• Identify, design, and implement internal process improvements: automating manual processes, orchestrating and optimizing data delivery across on-premises data platforms, re-designing data models for greater scalability, etc.

• Build on and optimize the existing foundation of data pipeline architectures required for optimal extraction, transformation, and loading of data from a wide variety of data sources using various methods, programming languages, and software technologies, adjusting as needed to optimize effectiveness

• Coordinate Linux VMs maintenances and maintain Docker Containers and basic shell scripting

What do you need to succeed?

Must-have

• Bachelor’s degree in computer science, Information Technology, or a related field

• Experience working with containers and orchestration tools like (Docker, Kubernetes, Apache Airflow, CI/CD, etc.)

• Must be proficient in working on Linux RHEL v8-9

• Experience using Environments technologies such as Hadoop/Spark, Virtual Servers, SQL, Oracle, DB2, NoSQL/SQL databases, Storage SAN/NAS

• Expertise SQL, coding and experience with a broad array of development tools and platforms, experience with Linux/UNIX shell coding, analytics data management tools/languages such as Python (required), Spark

• Experience developing and maintaining reporting environments across multiple platforms (e.g. ETL, reporting data layer, etc.) with exposure to programming and data environments (e.g. SQL, Hadoop, Python, etc.)

• Strong core competency in SQL. Experience in writing complex SQL queries to extract and integrate data from multiple database source

Nice-to-have

• Knowledge of Credit Risk Modelling techniques

• Experience working with Cloud Technologies

• Experience working with Structured vs. Unstructured data

• Extensive hands-on experience in designing, developing and maintaining software frameworks using Python, Spark, and Shell Scripts

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.

• Ability to make a difference and lasting impact

• Work in a dynamic, collaborative, progressive, and high-performing team

• Opportunities to do challenging work

Job Skills

Additional Job Details

RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTOTORONTOCanada37.5Full timePERSONAL & COMMERCIAL BANKINGRegularSalaried2025-04-282025-06-21

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.