Please note: The ideal candidate will be based out of our Toronto or Vancouver Office

What is the opportunity?

This technical role is part of Corporate Client Group (CCG) National Operation’s Business Intelligence team who delivers and maintains CCG’s management information systems, creates meaningful data visualizations and improves reporting processes. You require critical thinking, strong technical skills, effective project management and great attention to detail to ensure success in this role. RBC CCG National Operations supports CCG planning, directing, and overseeing their operational policies, rules, initiatives, and goals. The CCG team is responsible for meeting annually established targets for revenues and returns, providing advice to our partners along with broader RBC relationship goals, while the National Operations team helps & supports the group execute long-term and short-term plans.

What will you do?

  • Work cohesively with CCG’s Business Intelligence team to build and maintain robust databases in SQL Server and MS Access
  • Support all CCG teams nationally and senior management to provide data and analytics solutions that support data driven decisions
  • Utilize VBA, SQL and other programming languages to make database and reporting processes more efficient and reduce time spent
  • Analyze large amounts of data; create ad-hoc and periodic reporting that are accurate and timely; and document and diagram key system and data management processes
  • Build meaningful data visualizations in Tableau and Excel for performance reporting
  • Perform database administrative duties including database maintenance, manage ETL processes, data cleanups and proactively monitor data quality
  • What do you need to succeed?

    Must have:

  • Undergraduate or equivalent degree in Computer Science, Computer Engineering or Management Information Systems with knowledge and experience in database and data management principals
  • Minimum of 2 years of professional work experience in a business intelligence, data analytics, or data warehousing
  • Professional verbal and written communication skills
  • Intermediate knowledge and experience with Tableau or other data visualization tools, as well as, advanced level of MS Office (with a focus on Excel and Access), SQL and VBA
  • Ability to solve problems through creativity and critical thinking, strong analytical skills and attention to detail
  • Proven capabilities in effective management of tasks and delivering high quality work while performing well under pressure, meeting time sensitive deadlines, and prioritizing work
  • Nice to have:

  • Database development experience especially in SQL Server
  • Database Administration Experience
  • Python, C programming, Java
  • 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.

  • Learn and develop new technical skills in a team that supports creativity and thinking outside of the box
  • Improve organizational skills including business analysis, project coordination and effective communication
  • Exposure to fast paced high performing teams and senior management
  • Work in a dynamic and collaborative organization that supports personal and professional growth
  • Opportunities to learn and grow through challenging work
  • Being part of a great organization that values inclusion and diversity
  • 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.com/careers .

    City: Vancouver or Toronto
    Address: TBC
    Work Hours/Week: 37.5
    Work Environment: Office
    Employment Type: Permanent
    Career Level: Experienced Hire/Professional
    Pay Type: Salaried
    Required Travel (%): 0-25
    Exempt/Non-Exempt: N/A
    People Manager: No
    Application Deadline: 01/15/2021
    Platform: Personal & Commercial Banking
    Req ID: 307036
    Ad Code(s): None

    Job Overview