Job Summary
Job Description
Please note: This posting is for a 4-month Student Summer 2024 placement with a start date of May 2024 and end-date of August 2024. In order to be eligible for this 4-month Student position, you must either:
Be returning back to school after the work term end-date of August 2024; or
If you are not returning back to school (i.e. are graduating in April/August 2024), but you require the work term as a mandatory component to in order to graduate successfully.
Please ensure that you meet these eligibility requirements before applying - candidates who apply but are found to be ineligible are not able to be considered.
What is the opportunity?
The Data Analyst Co-op will work closely with the Corporate Client Group (CCG) National Operation's Data Analytics team to support the business with the management of data, reporting and process improvement initiatives. The incumbent should possess data and management information related knowledge and should have a strong hold on MS Excel and VBA and should be familiar with MS Access. Strong problem solving, time management and attention to details will help ensure success in this role. RBC CCG National Operations supports CCG's 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?
Support the implementation of robust database and reporting systems for the CCG team and senior management
Fulfill ad-hoc and periodic data requests based on business requirements
Analyze data for useful insights and build meaningful dashboards & data visualizations
Automate reporting processes to help the team save resources
Perform data mining, cleanup and investigate discrepancies to enhance data quality
Support database administration activities and troubleshoot user inquiries
Document and diagram key system and data management processes
What do you need to succeed?
Must-have
3rd or 4th year student with a minimum of one Co-Op placement of relatable experience
Undergraduate degree in Management Information Systems, Business Administration, Computer Science or Engineering
Intermediate level of MS Office with a strong focus on Excel & VBA and familiarity with Access
Related knowledge and experience in database and data management principals
Ability to perform well under pressure, meet time sensitive deadlines, and prioritize work
Strong analytical skills and attention to detail
Team player and also able to work independently
Strong oral and written communication skills
Proven capabilities in effective management of tasks and delivering high quality work
Nice-to-have
Tableau
Python
What's in it for you?
This is a great opportunity for students who are interested in expanding their knowledge and developing skills in data analytics, system improvement and the banking industry. Leaders who support your development through coaching and managing opportunities.
Develop technical skills including MS Excel, Access, MS Office and SQL
Develop organizational skills including analysis, project coordination and effective communication
Exposure to high performing team and senior management
Work in a dynamic, collaborative, and progressive environment
Opportunities to learn and grow through challenging work
Being part of a great organization that values inclusion and diversity
Job Skills
Additional Job Details
Address:
City:
Country:
Work hours/week:
Employment Type:
Platform:
Job Type:
Pay Type:
Posted Date:
Application Deadline:
Inclusion and Equal Opportunity Employment
At RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work. We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.
We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.
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 jobs.rbc.com.