Senior Data Engineer

Royal Bank of Canada • Toronto, ON

2d • Onsite

About The Position

The HR/BMCC Innovation Data team serves as a horizontal function, delivering business systems analysis and product management expertise to HR/BMCC business and IT partners. The Senior Data Engineer plays a pivotal role in helping develop and build data-driven solutions to serve our clients better. We are creating a data platform product (data hub) for HR, and this role will contribute with other Data Engineers and leads for the planning, development, and deployment of the data hub.

Requirements

• Bachelor’s degree in computer science, Software Engineering, or equivalent; or diploma in related technical discipline
• 5-8 years with SDLC frameworks, database technologies, advanced SQL, data transformation, and data modeling principles
• Proficiency in Python and SQL with hands-on experience in ETL tools eg. DBT, Spark
• Experience with Snowflake for architecture design, warehouse development, schema optimization, security, and performance tuning
• 5+ years with cloud-based ETL platforms
• Expertise in dimensional, relational, and semantic modeling with data lineage documentation
• Cloud infrastructure knowledge (Azure, AWS, or GCP) including Kubernetes, Docker, and serverless computing
• Experience in DevOps (CI/CD) and version control (Git)
• RESTful API design and microservices architecture experience
• Strong analytical and problem-solving abilities with exceptional strategic thinking
• Advanced communication and collaboration skills, with the ability to translate complex technical ideas into practical, business-focused solutions
• Exceptional attention to detail, organization, ability to multitask, and strong time management skills

Nice To Haves

• Experience in HR domain
• Knowledge of agentic AI systems using LLM frameworks, open-source tools, and cloud technologies for workflow automation and decision engines
• Experience with Databricks or advanced cloud data platforms
• Experience with LLM API calling, RAG, and VectorDB
• Full-stack development experience (Java) with small to large-scale applications
• Experience with R or Scala for data processing

Responsibilities

• Engineer end-to-end data solutions on both on-prem and cloud infrastructure
• Define and build scalable ETL/ELT workflows for reporting and analytics
• Build solutions to scale, monitor, and operate data platforms for very high availability and performance
• Leverage best practices in continuous integration and delivery, with a strong commitment to leading with quality
• Consume and implement RESTful APIs and microservices to enable seamless data integration across enterprise systems
• Help identify and evaluate potential new tools/platforms that mature RBC's AIOps capabilities
• Mentor and guide junior engineers through code reviews, ensuring delivery of clean, well-tested, and performant software
• Collaborate effectively with Developers, functional leads, the product manager, and Business in a fast-paced agile environment to deliver high-quality solutions
• Translate complex technical requirements into practical, business-focused solutions with strategic thinking and attention to detail

Benefits

• 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
• Work in a dynamic, collaborative, progressive, and high-performing team
• A world-class training program in financial services
• Flexible work/life balance options
• Opportunities to take on progressively greater accountabilities
• Access to a variety of job opportunities across business and geographies

What This Job Offers

• Job Type: Full-time
• Career Level: Senior