Royal Bank of Canada

Senior Data & Reporting/Business Analyst - GFT

Royal Bank of Canada$95K — $115K *
Finance & Insurance
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years of analytical experience in data-driven functions
  • Solid understanding of Finance business processes
  • Exceptional storytelling skills to translate complex data
  • Proficient in querying and automation with big data technologies
  • Adept in leveraging AI tools for analytics and reporting

Responsibilities

  • Utilize Hive, SQL, and Python for daily data analysis
  • Collaborate with stakeholders to finalize business requirements
  • Make recommendations to enhance data completeness
  • Automate repeatable analyses and self-service tools
  • Research industry metrics for informed analytics
  • Oversee data integrity in reporting and advanced analytics
  • Drive high standards of quality across the data lifecycle

Benefits

  • Comprehensive Total Rewards Program including flexible benefits
  • Leadership support for personal development
  • Opportunities to make a lasting impact
  • Dynamic and collaborative work environment
  • World-class training program in financial services
  • Engagement in challenging work tasks
Full Job Description
Job Description

What will you do?
  • Utilize Hive/SQL/ Python to perform daily data analysis and advanced data mining and analytics on large transactional datasets
  • Work closely with Program sponsors, SMEs in various business areas, technology teams to finalize functional business requirements and support implementation activities
  • Make recommendations and build use cases on new sources of value by addressing the biggest gaps in our data sources in relation to completeness
  • Find opportunities to create and automate repeatable analyses or build self-service tools for business users
  • Research industry metrics and business context and bring this context to bear in analyses
  • Oversee processes such as data gathering, transformation, reporting, and advanced analytics to ensure the integrity and reliability of large datasets.
  • Drive the highest standards of quality, rigor, and thought leadership across the entire data lifecycle.


What do you need to Succeed?

Must have:
  • Solid understanding of Finance business processes such as Balance Sheet Reporting, Profit and Loss Reporting, Capital Reserve Reporting, Capital Markets products and processes, and Regulatory Reporting
  • Minimum of 5+ years of analytical experience in applying solutions to business problems in relevant fields such as analytics, business requirements, consulting, or other data-driven functions
  • Demonstrated Experienced in quantitative, qualitative, analytical, problem solving, and critical thinking skills.
  • Exceptional storytelling skills, with a track record of translating complex data into compelling business insights. Ability to communicate findings derived from complex analytics to Senior Leadership, both verbally and visually.
  • Experienced in databases, data engineering, ETL, ELT concepts with utilizing querying, automation, and big data technologies (e.g. Python, SQL, Spark, Teradata, Hadoop, Snowflake, Databricks) to produce repeatable insights
  • Proficiency with creating compelling presentations
  • Adept in leveraging AI tools for faster writing of queries and scripts and impact assessment by scanning through the code
  • Adept in leveraging AI tools to auto-generate functional specs and user stories from requirements
  • Adept in leveraging AI tools to trace the problems back to their source and summarize lengthy documents to extract key insights


Nice-to-have:
  • Data Engineering / Data Science certification and/or completion of Business Analysis training courses.
  • Copilot , Git hub , Python knowledge


What's in it for you?

  • 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
  • Opportunities to do challenging work.


#LI-POST

#TECHPJ

Job Skills
Analytics, Business Analytics, Business Case Design, Critical Thinking, Data Administration, Data Mining, Data Modeling, Data Movement, Detailed Design, Detail-Oriented, Detail Oriented Tasks, Group Problem Solving, Problem Solving, Quantitative Research, Research Documents

Additional Job Details

Address:

745 THURLOW ST:VANCOUVER

City:

Vancouver

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

TECHNOLOGY AND OPERATIONS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2026-08-04

Application Deadline:

2026-09-26
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

About Royal Bank of Canada

Royal Bank of Canada Careers

Join the dynamic team at Royal Bank of Canada (RBC), a global leader in financial services and a company committed to excellence and innovation. At RBC, we offer a wide range of job opportunities that empower professionals to shape their career paths with leadership, diversity training, and continuous growth.

Work You’ll Do

At Royal Bank of Canada, we are not just hiring; we are building a culture of innovation and leadership. Our team members are at the forefront of the financial industry, driving transformation and delivering targeted solutions that meet the evolving needs of our clients and communities.

Explore Job Opportunities and Employment at RBC

Whether you are starting your career or looking to take it to the next level, RBC offers positions that challenge your skills and fuel your ambition. From entry-level positions to leadership roles, our job opportunities span across various functions and regions. Join us and be part of a team that values professional growth and diversity.

Internship and Professional Development

Kickstart your career with an internship at Royal Bank of Canada. Our internships provide invaluable hands-on experience, networking opportunities, and insights into the financial services industry. Interns at RBC gain the skills necessary to excel and are often considered for full-time positions within the company.

Benefits and Culture

At RBC, we prioritize the well-being and satisfaction of our employees. Our benefits package is designed to support our team members at every stage of their life and career. RBC’s culture is built on a foundation of respect, integrity, and responsibility, fostering an environment where everyone can thrive.

Career Growth and Innovation

We believe in nurturing the potential of our employees through continuous learning and career development programs. At RBC, you will find endless opportunities to grow professionally through on-the-job experiences, formal training programs, and leadership development initiatives. Our commitment to innovation means we are constantly seeking out new ideas and perspectives, making RBC a perfect place for those who aim to lead and innovate.

Diversity and Inclusion

Diversity is our strength. At Royal Bank of Canada, we are committed to building an inclusive workplace where every employee feels valued and respected. Our diversity training programs are designed to educate and inspire, creating a more inclusive and equitable workplace.

Join Our Team

Search open positions that match your skills and interests. We look for passionate, curious, creative, and solution-driven team players. Start your journey with RBC today and be part of a world-class team known for its commitment to client service, community involvement, and innovation.

Stay Connected

Keep up to date with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the people who work here at Royal Bank of Canada.

Job Alert Emails

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover the exciting and rewarding career opportunities awaiting you at RBC. Explore the possibilities with Royal Bank of Canada, where your future is filled with potential and the path to success is paved with countless opportunities for professional and personal growth. Join us and shape not just your career but the future of the financial industry.
Learn more about Royal Bank of Canada
Size
86,007 employees
Market Cap
$130.3 billion
Industry
5 Year Trend
+8.7%
NASDAQ

Similar Jobs

More Jobs at Royal Bank of Canada

More Finance & Insurance Jobs

Find similar Senior Data & Reporting/Business Analyst - GFT jobs: