Job DescriptionWhat 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 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.
Job SkillsAnalytics, 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 DetailsAddress: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-06-09
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above