Product Manager Vulnerability & Threat Intelligence (Global Security)

Royal Bank of Canada • Toronto, ON

22h • Onsite

About The Position

This role is responsible for designing, developing, and maintaining complex data pipelines for real-time vulnerability data ingestion and processing. The Product Manager will lead the strategic transition from traditional reporting to AI-powered analytics, including hands-on development of AI agents and designing optimized prompts. They will develop Python-based automation solutions, design AI prompts for Agentic AI systems, partner with stakeholders to gather requirements, and architect scalable data engineering infrastructure.

Requirements

• 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 Haves

• 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

Responsibilities

• 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

Benefits

• A comprehensive Total Rewards Program, including competitive compensation, bonuses, and flexible 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed