Job Description What is the opportunity? Home Equity Financing (HEF) is seeking a dynamic and versatile Lead Data Engineer to join our growing team of data and analytics experts. This role combines the technical expertise of a data engineer with the strategic thinking and business insight of a data professional. You will play a pivotal role in designing, building, and optimizing data architectures and pipelines while collaborating with business stakeholders to deliver actionable insights and drive data-driven decision-making. This role requires a unique blend of technical proficiency, business understanding, and the ability to bridge the gap between data engineering and business needs. You will work across cloud-based and on-premise platforms, supporting HEF, and contributing to the development of machine learning systems and advanced analytics. More broadly, you have a passionate and curious mindset, with a strong drive to stay ahead of the curve by exploring the latest trends, technologies, and opportunities in the data and analytics space, and leveraging them to deliver innovative solutions for HEF and RBC. What will you do? Data Engineering & Architecture: Develop and maintain our Reporting & Analytics stack infrastructure Design, build, and optimize scalable data pipelines and architectures for data extraction, transformation, and loading (ETL) from diverse data sources. Manage, monitor, and optimize big data processing pipelines using tools like Spark, Hadoop, or equivalent. Implement and maintain cloud-based data platforms (e.g., Snowflake, AWS, Azure, or Google Cloud) and on-premise data warehouses. Ensure data quality, governance, and lineage by building and maintaining data dictionaries, documentation, and metadata repositories. Business Collaboration & Insights: Collaborate with a diverse group of HEF, Digital, and Personal Banking business stakeholders to translate business needs into technical requirements and actionable insights. Develop, deliver, and manage dashboards, visualizations, and storytelling insights using tools like Tableau. Support major HEF initiatives managing data pipelines, data automation, machine learning models, and decision-making processes across all HEF strategies. Machine Learning & Advanced Analytics: Contribute to the evolution of machine learning systems, integrating them into HEF business processes and decision-making frameworks. Process Improvement & Innovation: Identify, design, and implement process improvements, including automation of manual processes and optimization of data delivery. Leverage scheduling tools like Rundeck, or Airflow to orchestrate workflows and ensure efficient data operations. Stay ahead of industry trends and emerging technologies to drive innovation and continuous improvement, collaborating with diverse data groups across RBC in technology and business data strategy. What do you need to succeed? Must-have: 5+ years of experience in data engineering, including expertise with relational databases (e.g., Teradata, SQL Server, MySQL, Postgres) and big data processing tools (e.g., Spark, Hadoop). Strong programming skills in Python, Scala, or equivalent, with experience in SQL-like languages. Expertise in cloud platforms (e.g., AWS, Azure, Google Cloud) and cloud-based data platforms (e.g. Snowflake). Experience with data visualization tools (e.g., Tableau) and designing user-centric solutions. Strong critical thinking, analytical, and problem-solving skills, with the ability to work in a fast-paced environment. Excellent communication and collaboration skills, with the ability to engage stakeholders by clearly articulating complex technical concepts in a way that resonates with technical audiences, while effectively translating them into simplified, business-relevant language for non-technical Line of Business (LOB) partners Nice-to-have: Experience with developing and deploying machine learning models and AI agents, including the exploration and implementation of advanced technologies such as LLMs, AI agents, and real-time streaming for innovative solutions. Familiarity with real-time streaming technologies and noSQL/graph/vector databases. Knowledge of continuous integration and development tools. Background in financial services, or an understanding of business functions like including product management, sales, and risk management. Graduate degree in Computer Science, Statistics, Information Systems, or a related quantitative field. What’s in it for you? Opportunity to work on cutting-edge data engineering and analytics projects that drive business impact. Exposure to a wide range of technologies, from big data and cloud platforms to machine learning and AI. Collaboration with diverse teams across HEF, marketing, and other business functions. A chance to innovate and contribute to RBC’s AI data strategy and data-driven culture. This hybrid role is perfect for a data professional who thrives at the intersection of technology and business, combining technical expertise with strategic insight to deliver impactful solutions. Join us and be part of a team that’s shaping the future of data and analytics at RBC! Job Skills Analytics, Big Data Management, Cloud Computing, Collaborating, Data Analysis, Database Development, Data Delivery, Data Engineering, Data Mining, Data Operations, Data Pipelines, Data Quality, Data Visualization, Data Warehousing (DW), Emerging Technologies, ETL Processing, Group Problem Solving, Machine Learning, Quality Management, Requirements Analysis, Structured Query Language (SQL) Additional Job Details Address: RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTO City: Toronto Country: Canada Work hours/week: 37.5 Employment Type: Full time Platform: PERSONAL & COMMERCIAL BANKING Job Type: Regular Pay Type: Salaried Posted Date: 2025-08-18 Application Deadline: 2025-09-03 Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above Inclusion and Equal Opportunity Employment At 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. Join our Talent Community Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you. Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com. Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 84,000+ employees who bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada’s biggest bank, and one of the largest in the world based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to more than 16 million clients in Canada, the U.S. and 34 other countries. Learn more at rbc.com.? We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at rbc.com/community-social-impact.
