2025 Winter Student - Data Analyst (4 months)

Please note: This posting is for a 4-month 2025 Winter STUDENT placement with a start date of January 2025 and end-date of April 2025. 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 April 2025; or
• If you are not returning back to school (i.e. are graduating in December 2024/April 2025), 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?

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.

• 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.
• Opportunities to do challenging work and make a difference.
• Opportunities to build close relationships.

Additional Job Details

Inclusion and Equal Opportunity Employment