Senior Technical Systems Analyst

RBC • Bedford, NS

14d

About The Position

What is the opportunity? We are seeking a Senior Technical System Analyst to join RBC Capital Markets' Shared Services Analytics team. This role is central to designing, developing, and supporting business intelligence solutions that deliver critical reporting and analytics across the organization. You will lead technical initiatives including system upgrades, application migrations, and the development of data models and dashboards using industry-leading platforms. Working collaboratively with development teams, project managers, and business stakeholders, you will transform complex data requirements into scalable technical solutions that drive operational effectiveness and support strategic decision-making. What will you do? - Design and develop business intelligence solutions, including technical architecture, system specifications, and data models using tools such as Tableau and Power BI - Leverage AI tools to migrate legacy data models and reports to strategic solutions - Lead planning and implementation of application deployments, system upgrades, and migrations while ensuring alignment with technology standards and best practices - Perform hands-on technical development and provide ongoing support for multiple reporting platforms and applications serving the Capital Markets business - Collaborate with business system analysts, project managers, and IT infrastructure teams to deliver solutions that meet business requirements and project timelines - Facilitate technical design meetings and present architecture recommendations to technology partners and senior management - Implement and configure vendor software packages, ensuring adherence to security, compliance, and audit requirements What do you need to succeed? Must-have: - Bachelor's degree in Computer Science or related field - 10+ years of business intelligence experience with demonstrated expertise in data modeling - Advanced proficiency with SQL, T-SQL stored procedures, and Microsoft SQL Server databases - Demonstrated project experience in programming languages such as Python, Java, or .Net - Strong understanding of system development lifecycle, Agile methodologies, and IT standards Nice-to-have: - Experience with ETL tools such as DataStage or similar data integration platforms - Experience designing, building, and deploying Oracle Analytics Server (OBIEE) in enterprise environments - Familiarity with web programming technologies and frameworks including React, Angular, JSON, REST, JavaScript, HTML5, or CSS3 - Knowledge of deployment and version control tools such as GitHub, Jenkins, or Nexus - Experience with system administration scripting languages like PowerShell or Python What’s in it for you? We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual. - A comprehensive Total Rewards Program including competitive compensation, bonuses and flexible benefits - Leaders who support your development through coaching and managing opportunities - The opportunity to work on transformative technology initiatives with lasting impact across the organization - Work in a dynamic, collaborative, progressive, and high-performing team - Flexible work/life balance options - Access to continuous learning and skill-development opportunities in financial services technology #LI-POST

Requirements

• Bachelor's degree in Computer Science or related field
• 10+ years of business intelligence experience with demonstrated expertise in data modeling
• Advanced proficiency with SQL, T-SQL stored procedures, and Microsoft SQL Server databases
• Demonstrated project experience in programming languages such as Python, Java, or .Net
• Strong understanding of system development lifecycle, Agile methodologies, and IT standards

Nice To Haves

• Experience with ETL tools such as DataStage or similar data integration platforms
• Experience designing, building, and deploying Oracle Analytics Server (OBIEE) in enterprise environments
• Familiarity with web programming technologies and frameworks including React, Angular, JSON, REST, JavaScript, HTML5, or CSS3
• Knowledge of deployment and version control tools such as GitHub, Jenkins, or Nexus
• Experience with system administration scripting languages like PowerShell or Python

Responsibilities

• Design and develop business intelligence solutions, including technical architecture, system specifications, and data models using tools such as Tableau and Power BI
• Leverage AI tools to migrate legacy data models and reports to strategic solutions
• Lead planning and implementation of application deployments, system upgrades, and migrations while ensuring alignment with technology standards and best practices
• Perform hands-on technical development and provide ongoing support for multiple reporting platforms and applications serving the Capital Markets business
• Collaborate with business system analysts, project managers, and IT infrastructure teams to deliver solutions that meet business requirements and project timelines
• Facilitate technical design meetings and present architecture recommendations to technology partners and senior management
• Implement and configure vendor software packages, ensuring adherence to security, compliance, and audit requirements

Benefits

• A comprehensive Total Rewards Program including competitive compensation, bonuses and flexible benefits
• Leaders who support your development through coaching and managing opportunities
• The opportunity to work on transformative technology initiatives with lasting impact across the organization
• Work in a dynamic, collaborative, progressive, and high-performing team
• Flexible work/life balance options
• Access to continuous learning and skill-development opportunities in financial services technology

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees