- Design, develop, and maintain complex data pipelines using advanced SQL queries, Azure Databricks (ADB), and Snowflake for real-time vulnerability data ingestion and processing
- Lead the strategic transition from traditional Tableau reporting to Agentic AI-powered analytics, including hands-on development of AI agents and designing optimized prompts for AI systems.
- Develop sophisticated Python-based automation solutions for vulnerability data collection, processing, report generation, workflow orchestration, and AI integration
- Design and optimize AI prompts for Agentic AI systems to automate vulnerability analysis, threat assessment, and intelligent reporting workflows
- Partner with Cybersecurity, Technology, and Business stakeholders across RBC to gather requirements and deliver customized vulnerability intelligence
- Architect scalable data engineering infrastructure supporting ETL processes, data quality controls, and real-time analytics across multiple platforms

What Will You Do?

- Design, develop, and maintain complex data pipelines using advanced SQL queries, Azure Databricks (ADB), and Snowflake for real-time vulnerability data ingestion and processing
- Lead the strategic transition from traditional Tableau reporting to Agentic AI-powered analytics, including hands-on development of AI agents and designing optimized prompts for AI systems.
- Develop sophisticated Python-based automation solutions for vulnerability data collection, processing, report generation, workflow orchestration, and AI integration
- Design and optimize AI prompts for Agentic AI systems to automate vulnerability analysis, threat assessment, and intelligent reporting workflows
- Partner with Cybersecurity, Technology, and Business stakeholders across RBC to gather requirements and deliver customized vulnerability intelligence




- Architect scalable data engineering infrastructure supporting ETL processes, data quality controls, and real-time analytics across multiple platforms

What Do You Need To Succeed?

Must have:

- 5+ years of progressive experience in data engineering, business intelligence, or analytics roles
- Strong Python programming capabilities for advanced automation, data manipulation, API integration, AI system integration, and scripting solutions
- Proven experience with AI prompting, prompt engineering, and working with Agentic AI systems, LLMs, or AI agents in production environments
- Expert-level proficiency in SQL and database queries with hands‑on experience designing and optimizing complex data pipelines and ETL processes
- Hands‑on experience with Azure Databricks (ADB) and Snowflake for data warehousing, processing, and analytics workloads
- Experience with AI/ML frameworks, RAG (Retrieval‑Augmented Generation) systems, or API integration with AI platforms

Nice‑to‑have:

- Background in banking, financial services, or highly regulated industries with understanding of compliance requirements
- Knowledge of vulnerability management processes, scanning tools (Qualys, Tenable, Rapid7), and cybersecurity risk frameworks
- Relevant certifications such as Snowflake SnowPro, Azure Data Engineer Associate, or similar credential

What's In It For You?

- A comprehensive Total Rewards Program, including competitive compensation, bonuses, and versatile benefits.




- Opportunities to lead high‑impact projects that shape the future of RBC’s reporting capabilities.
- Access to world‑class training and development programs in financial services and technology.
- A collaborative, innovative, and inclusive work environment that values progressive thinking and mutual success.
- Flexible work/life balance options to support your well‑being and productivity.

Job Skills

Analytics, Big Data Management, Cloud Computing, Database Development, Databricks Platform, Data Mining, Data Warehousing (DW), ETL Processing, Microsoft Azure Databricks, Quality Management, Requirements Analysis, Snowflake (Platform), Snowflake Data Warehouse, Snowflake Schema, Tableau (Software), Waterfall Model

Additional Job Details

Address: 16 YORK ST:TORONTO

City: Toronto

Country: Canada

Work hours/week: 37.5

Employment Type: Full time

Platform: TECHNOLOGY AND OPERATIONS

Job Type: Regular

Pay Type: Salaried

Posted Date: 2026-01-27

Application Deadline: 2026-08-07

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 chance for all.

📌 Product Manager Vulnerability & Threat Intelligence (Global Security) (Toronto)
🏢 RBC
📍 Toronto