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 AccessSupport all CCG teams nationally and senior management to provide data and analytics solutions that support data driven decisionsUtilize VBA, SQL and other programming languages to make database and reporting processes more efficient and reduce time spentAnalyze large amounts of data; create ad-hoc and periodic reporting that are accurate and timely; and document and diagram key system and data management processesBuild meaningful data visualizations in Tableau and Excel for performance reportingPerform 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 principalsMinimum of 2 years of professional work experience in a business intelligence, data analytics, or data warehousingProfessional verbal and written communication skillsIntermediate 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 VBAAbility to solve problems through creativity and critical thinking, strong analytical skills and attention to detailProven 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 ServerDatabase Administration ExperiencePython, 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 boxImprove organizational skills including business analysis, project coordination and effective communicationExposure to fast paced high performing teams and senior managementWork in a dynamic and collaborative organization that supports personal and professional growthOpportunities to learn and grow through challenging workBeing 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
Work Hours/Week: 37.5
Work Environment: Office
Employment Type: Permanent
Career Level: Experienced Hire/Professional
Pay Type: Salaried
Required Travel (%): 0-25
People Manager: No
Application Deadline: 01/15/2021
Platform: Personal & Commercial Banking
Req ID: 307036
Ad Code(s): None