We are seeking a talented Data Engineer to join the Operational Data, Information, and AI team in Personal and Commercial Operations. The candidate will play a critical role in the design, implementation, and optimization of our cloud data Lakehouse. You'll work with cutting-edge technologies to design, develop, and optimize scalable data pipelines that handle large volumes of structured and unstructured data and serve as the data foundation for transformational Business Intelligence, Machine Learning, and AI initiatives.

This role offers:

• Technical depth: Hands-on work with cutting-edge data technologies (Snowflake, dbt, Iceberg, AWS)
• Visibility: Contribute to strategic, enterprise-wide data initiatives
• Innovation: Implement modern data engineering patterns including Lakehouse architecture and analytics engineering

WHAT WILL YOU DO?

Hands-On Technical Delivery

• Design, develop, optimize, and maintain robust ELT pipelines using Python, SQL, Snowflake, Airflow, and Spark to process large-scale datasets Develop and optimize data transformations using dbt for analytics workflows, ensuring modularity, testability, and documentation
• Build batch and real-time data ingestion frameworks integrating with Snowflake and AWS services
• Work with data product owners to develop analytical, AI/ML, and GenAI focused data products for enterprise usage.
• Write complex SQL for data modeling, aggregation, and performance optimization across Snowflake and relational databases.
• Develop streaming data solutions using Kafka, Kinesis, or similar technologies.
• Data quality and governance: Implement data validation, quality checks, and governance practices to ensure data integrity and compliance with enterprise policy and data contracts.

Platform & DevOps Excellence

• Build and maintain CI/CD pipelines for data engineering workflows using enterprise approved tools
• Containerize data applications using Docker and orchestrate with Kubernetes or AWS ECS
• Establish monitoring, logging, and alerting for production data pipelines
• Drive SRE practices including incident management, root cause analysis, and continuous improvement

Collaboration & Stakeholder Engagement

• Work closely with product owners, data scientists, analysts, and business stakeholders to understand requirements and deliver solutions
• Partner with enterprise architects and platform teams to ensure alignment with technology standards
• Provide technical estimates, capacity planning inputs, and risk assessments for project initiatives
• Document technical designs, data flows, and operational runbooks

WHAT DO YOU NEED TO SUCCEED?

Must-Have:

• 3+ years of hands-on data engineering experience
• Strong technical proficiency in:
  • Hadoop ecosystem: HDFS, YARN, Hive, Spark
  • SQL: Advanced query writing, optimization, indexing, stored procedures
  • Python: Production-quality code for data pipelines, automation, and scripting
  • AWS: S3, Glue, Lambda, Redshift,
  • Snowflake: Data warehousing, virtual warehouses, clustering, security
  • dbt: Model development, testing, documentation, incremental builds
• Proven track record of delivering production data solutions in enterprise environments
• Strong understanding of data modeling (dimensional, normalized, Data Vault)
• Experience with data pipeline orchestration tools (Airflow, Dagster, Luigi)
• Proficiency with Git version control and collaborative development workflows
• Experience with containerization (Docker) and orchestration (Kubernetes)
• Demonstrated ability to work independently, take ownership, and drive projects to completion
• Excellent problem-solving skills and attention to detail

Nice-to-Have:

• Experience with NoSQL databases (MongoDB, DynamoDB, Cassandra)
• Knowledge of data streaming platforms (Apache Kafka, AWS Kinesis)
• Exposure to data governance and metadata management tools
• Experience with data quality frameworks and observability platforms (Great Expectations, Monte Carlo, Datadog)
• Familiarity with machine learning pipelines and MLOps
• Background in financial services or highly regulated industries
• AWS, Snowflake, or dbt certifications
• Experience with Polars or Pandas for data manipulation

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, and stock where applicable
• Leaders who support your development through coaching and learning opportunities
• Ability to make a difference and lasting impact
• Work in a dynamic, collaborative, progressive, and high-performing team
• World-class training program in financial services and technology
• Flexible work/life balance options
• Opportunities to do challenging, meaningful work
• Opportunities to take on progressively greater accountabilities
• Access to cutting-edge technologies and modern data stack

Working hours: 1.00pm - 10.00pm MYT

Job Skills

Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Quality Management, Requirements Analysis

Additional Job Details

PERSIARAN IRC 2, IOI RESORT CITY IOI CITY TOWER ONE:PUTRAJAYAPutrajayaMalaysia40Full timePERSONAL & COMMERCIAL BANKINGRegularSalaried2026-05-142026-07-31

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Our Employment Opportunities

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One 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.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.