Application Security Consultant - SCA (Global Security)

Job Description 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 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 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 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. 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 . 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.