Overview
Skills
Job Details
Role: ETL and Data Transport Developer
Location: Halifax or Montreal or Mexico
Experience: 10+
**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.
**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.