Data Analyst

Job Description

What is the opportunity?

As Data Analyst, you are a key technical role that supports the National Operations’ Data & Analytics team with enhancing data management, systems and process improvement initiatives. To ensure success in this role, you require critical thinking, problem solving and great attention to detail. RBC Corporate Client Group (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?

• Commit to the delivery of robust database and reporting systems for the CCG team and senior management
• Develop new processes and tools to streamline existing data provisioning processes and reports using VBA, SQL and other programming languages
• Assist the CCG Senior Manager, Data & Analytics in data management, project management and ensuring data provisioning is timely, accurate and regulatory compliant
• Analyze data for useful insights and utilize Excel and Tableau to create data visualizations
• Perform data mining, cleanup and proactively monitor data quality while also supporting database administration activities and troubleshoot user inquiries and data escalations by acting as a liaison between CCG and enterprise IT teams
• Document and diagram key system and data management processes
• Coordinate project delivery by tracking project progress and facilitate requirement gathering sessions
• Fulfill Ad-Hoc data requests and support the creation of periodic reports

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
• 2- 3 years of professional work experience in a data analytics, business intelligence or data warehousing
• Strong verbal and written communication skills
• Advanced level of MS Office with a focus on Excel and Access, and intermediate knowledge and practical experience with VBA and SQL
• 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
• Database Administration Experience
• Tableau
• 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.
JOB SUMMARY
City: Vancouver
Address: 666 Burrard Street
Work Hours/Week: 37.5
Work Environment: Office
Employment Type: Permanent
Career Level: Experienced Hire/Professional
Pay Type: Salary + Variable Bonus
Required Travel (%): 0-25
Exempt/Non-Exempt: N/A
People Manager: No
Application Deadline: 08/19/2020
Platform: Personal & Commercial Banking
Req ID: 262463
Ad Code(s):