Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Target Resume Now
About the Role
This role involves designing, developing, and maintaining complex data pipelines, leading the transition to AI-powered analytics, and developing Python-based automation solutions. You will partner with stakeholders to deliver customized vulnerability intelligence and architect scalable data engineering infrastructure.
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.
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.
- 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.
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
- SQL
- Python
- Azure Databricks (ADB)
- Snowflake
- AI prompting
- Prompt engineering
- Agentic AI systems
- LLMs
- AI agents
- AI/ML frameworks
- RAG (Retrieval-Augmented Generation) systems
- API integration
Location
- Toronto, Canada
Work Type
- Full time
Experience Level
- 5+ years of progressive experience in data engineering, business intelligence, or analytics roles
Education Level
- Snowflake SnowPro certification
- Azure Data Engineer Associate certification
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.
About the Company
- 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.