ETL and Data Transport Developer
RBC Capital
Job Summary
Job Description
What is the Opportunity?
RBC’s Quantitative & Technology Services (QTS) is seeking an experienced ETL and Data Transport Developer with strong qualifications in Python. In this role, you will play a critical part in designing, developing, and managing data pipelines and ETL processes to support various internal applications. You will collaborate with cross-functional teams to ensure data is efficiently acquired, transformed, and delivered to meet project objectives. Your primary focus will be on managing data-related activities within the Business & Client Services Technology platform. With a hands-on, detail-oriented approach, you will address complex data challenges and foster a functional, solution-oriented mindset within the team.
What will you do?
Execute on the development and optimization of ETL pipelines and data transport solutions to enhance the Business & Client Services Technology platform.
Create technical plans and various technical documentation related to any code developed.
Collaborate with BAs/PMs to prioritize tasks and deliver on multiple concurrent data transformation projects.
Identify opportunities for efficiency and scalability across data processes by analyzing and understanding project details.
Maintain good code coverage to ensure good hygiene.
Actively engage in technical discussions to address challenges and propose innovative solutions.
In this role, you will communicate and interact frequently with RBC partners and/or employees located across Canada and/or worldwide.
What do you need to succeed?
Must-have:
Undergraduate degree in a relevant field and experience managing complex programs with high-frequency requests and competing priorities.
Strong written and verbal communication skills, paired with excellent analytical abilities.
6+ years of experience in data analysis, ETL development, and data transport processes.
Expertise in Python for data manipulation, profiling, and automation.
Solid understanding of computer systems, interfaces, and data workflows.
Experience managing a portfolio of data-related projects.
Nice-to-have:
Experience working in startup environments.
Familiarity with Capital Markets, including a 360-degree understanding of its operations.
Knowledge of Accounting, Sub-Ledgers & Payments, FinTech, DeFi, Crypto, and Blockchain technologies.
Hands-on experience with Agile/Scrum development methodologies.
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
Work in a dynamic, collaborative, progressive, and high-performing team
Ability to make a difference and lasting impact
#Li-post
Job Skills
Agile Methodology, Analytics, Business Analysis, Cloud Computing, Data Analysis, Data Governance, Data Mining, Data Transformation, Data Validation, Extract Transform Load (ETL), Requirements Analysis, Teamwork, Technical Design Documentation, Technical DesignsAdditional Job Details
Address:
City:
Country:
Work hours/week:
Employment Type:
Platform:
Job Type:
Pay Type:
Posted Date:
Application Deadline:
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.