Data Analyst

Job Description Looking for a Data Analyst to support reporting, automation and dashboarding across our current on‑premise Citrix Virtualization environments and soon on Windows 365 CloudPC across the Azure environment. This role focuses on data extraction, transformation, and visualization with exposure to automation and familiarity with DevOps tools. Responsibilities Build and maintain reports using PowerShell scripting and advanced Excel (pivot tables, formulas, data handling) Strong SQL data extraction and reporting (joins, aggregations, grouping, filtering and data transformation) Extract data using REST API from ServiceNow, Microsoft Graph API from Microsoft Intune and Entra Build dashboards using Tableau and Kibana Use GitHub and Visual Studio Code for version control and development Familiarity with developing and running Python scripts (modifying existing code, using RBC’s AI tooling where helpful) Experience with automation workflows on CI/CD pipelines using Jenkins, Helios, Terraform is a plus Create and document procedures, ServiceNow Knowledge Articles and internal RBC Connect Web Pages related to the solutions we support Must Haves Advance experience with Visual Studio or PowerShell scripting Advanced Excel experience (pivot tables, formulas, data handling) Strong SQL Basic Python (can read/edit scripts; not expected to build complex systems) Nice to Have Exposure to GitHub and Visual Studio Code Willingness to use AI tools like GitHub Copilot Knowledgeable with REST APIs and familiarity with Microsoft Graph API is a plus Benefits A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable Leaders who support your development through coaching and managing opportunities Ability to make a difference and lasting impact Work in a dynamic, collaborative, progressive, and high‑performing team A world‑class training program in financial services Flexible work/life balance options Opportunities to do challenging work Opportunities to take on progressively greater accountabilities Opportunities to build close relationships with clients Job Details Address: 330 FRONT ST W, 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-05-21 Application Deadline: 2026-06-12 (Applications accepted until 11:59 PM on the day prior) RBC is an equal opportunity employer.

Qualified applicants may be contacted to review their resume in more detail. #J-18808-Ljbffr