Skip to main content

Description

RBC's AML team is expanding its data ingestion platform team. The role involves building automation solutions for ingesting terabytes of data from various sources into S3 and Snowflake. Key responsibilities include designing, developing, and maintaining data ingestion flows, implementing data pipelines and ETL processes, ensuring data quality and security, optimizing SQL queries, and collaborating with cross-functional teams to integrate data capabilities into existing and new applications. The role also involves documenting data pipelines and gathering functional requirements.

What We're Looking For

Work within an Agile product team to design, develop and maintain data ingestion flows and evolve the platform to orchestrate them.,Design and implement data pipelines and ETL processes.,Ensure data quality, security, and performance.,Develop and optimize SQL queries, stored procedures, and views.,Integrate Snowflake with other data sources and BI tools.,Collaborate with data engineers, analysts, and business stakeholders.,Monitor and troubleshoot data jobs and platform issues.,Collaborate with developers and cross-functional teams to integrate data capabilities into existing and new applications.,Develop and maintain comprehensive documentation for data pipelines, transformations and data models.,Foster knowledge and collaborative functions.,Gather functional requirements and translate them into technical specifications.,Collaborate with other team members on resolving technical issues, improving current products and developing new features.

Ideal Candidate

Bachelor's or master's degree in computer science, Data Engineering and, or a related field.

Minimum Education

Bachelor's or Master's Degree

Hard Skills

Spark
Yarn
Hive
Hadoop
SQL
Data Modeling
Scala
Snowflake
ETL tools (Informatica, Talend, Apache Airflow)
Cloud platforms (AWS, Azure, GCP)
Python
Scripting languages
SCM
Infrastructure-as-code
CI/CD pipelines
Apache Airflow
Jenkins
GitHub
Automated Testing tools
Git
Docker
Kubernetes
Containers
Agile Methodology
Application Integrations
Enterprise Application Delivery
Programming Languages
Software Development Life Cycle (SDLC)

Soft Skills

Problem-solving
Communication skills
Detail-Oriented
Group Problem Solving
Active Learning

Work Hours

37.5 hours/week

Benefits

Bonuses
Flexible benefits
Competitive compensation
Commissions
Stock options
Leadership development and coaching
Training programs in financial services
Flexible work/life balance options
Challenging work opportunities
Career advancement opportunities
Opportunities to build client relationships
Access to diverse job opportunities across business and geographies

Also Available At

About the Company

R

Royal Bank of Canada

Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. As Canada's largest bank, it provides personal and commercial banking, wealth management, and capital markets services to over 17 million clients worldwide.

Purpose-driven
Inclusive
Innovative
Collaborative
Professional
View all jobs at Royal Bank of Canada

    We respect your privacy

    BerryMap uses cookies to provide essential features, analyze usage, and improve your experience. You can customize your preferences below.