ETL and Data Transport Developer
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 Designs