Description
The RBC Capital Markets Client Intelligence team plays an integral role in supporting the firm's key strategic client initiatives.
The Client Intelligence team is part of the Business Resource Management division which supports all global businesses within Capital Markets, including Global Markets Sales & Trading, Corporate Banking & Investment Banking.
The CI team is responsible for ensuring accurate client revenue reporting and leverages internal data (revenue, resource utilization, CRM interactions) and external data (competitor benchmarking, client provided scorecards and feedback) to deliver analytical business insights.
The data and analytics provided by the CI team empowers the business to make more informed decisions on its clients and supports its formulation of sales and client strategies.
Responsibilities
- Provide accurate and timely client data and analytics to the Capital Markets businesses
- Support the annual sales & client planning process; develop KPIs to track business performance
- Be responsible for client benchmarking data submissions to external competitor benchmarking vendors
- Provide senior leadership client briefs ahead of client meetings
- Support the evolution of RBC's client analytics by working on data initiatives that improve client revenue data and enhance client profitability metrics
Requirements
- Passion for data and analytics; at least 2 years of work experience in reporting, analytics and/or data visualization
- Strong attention to detail and demonstrated ability to query, organize and structure large amounts of data
- Proficiency in BI tools, specifically Tableau
- Strong proficiency in Excel (pivot tables, formulas, charts & graphs)
- Strong proficiency with SQL (optimizing large complicated SQL statements) and its variation among popular databases
- Experienced with Python frameworks and libraries (e.g. Pandas)
- Knowledge of best practices when dealing with relational databases
- Proficient understanding of code versioning tools (e.g. Git)
- Positive attitude and collaborative work approach
- Ability to work in fast-paced environment; be agile and flexible to support business needs
- Strong written & verbal communication skills
- Self-starter, ability to progress and deliver initiatives with little direction / oversight
- Ambition & drive; doesn't settle for status quo and looks for ways to improve and thinks outside the box
- Bachelor's degree or higher
Nice to Have
- Experience with AI tools
- Experience working with Alteryx (data cleansing, data aggregation, etc.)
Benefits
- Competitive salary
- Opportunity to work in a collaborative, creative and innovative organization
- Part of a global bank with a strong reputation
Working Hours: 8:00 PM - 5:00 AM (North America Time Zone)