What is the opportunity?

As Manager, Data and Analytics Engineer, you are responsible for transforming how data is used to drive business insights, reporting and decision-making.

You will have the opportunity to work across data engineering, analytics and business teams to build reliable data pipelines and analytical datasets that make information faster, more accessible and easier to use.

This role is ideal for someone who enjoys solving problems with data — from improving the way data is collected and transformed, to automating processes and creating the foundation for better analytics and reporting.

What will you do?

• Build and maintain ETL/ELT pipelines that bring together data from multiple sources.
• Use Python and SQL to extract, transform, validate and manipulate data.
• Investigate data issues, identify root causes and work with technology/source-system teams to resolve them.
• Develop and maintain scheduled data workflows, including monitoring, testing and troubleshooting.
• Create clean, reusable analytical datasets that support reporting, analytics and business decisions.
• Implement data-quality checks and improve the accuracy, consistency and reliability of data.
• Automate manual data and reporting processes to improve speed and efficiency.
• Partner with analytics and business stakeholders to understand requirements and translate them into data solutions.

What do you need to succeed?

Must Have

• 3+ years of experience working with data, analytics or data engineering.
• Strong Python skills, particularly for data manipulation and automation.
• Experience with Pandas/Polars/PySpark or similar data-processing frameworks to work with large or complex data sets
• Hands-on experience building or maintaining ETL/ELT pipelines, with experience in scheduling/orchestration tools and production data workflows.
• Understanding data quality, testing, validation and troubleshooting.
• Communicate effectively with both technical & business stakeholders and translate business requirements into practical data solutions.

Nice to Have

• Experience with Tableau or other BI/reporting tools.
• Experience with cloud data platforms or modern data architectures.
• Experience in financial services, finance or accounting.
• Exposure to machine learning, generative AI or agentic workflows.

Job Skills

Additional Job Details

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.