Job Description
What is the opportunity?
Lead advanced client data analytics initiatives across RBC Capital Markets. In this role, you will bridge business requirements and data engineering teams to build foundational data and advanced analytics platforms that transform how the firm measures, understands, optimizes and drives client profitability, resource efficiency, strategic value and opportunities. You will serve as a trusted strategic partner to senior business stakeholders, translating complex Capital Markets challenges into scalable data solutions while managing technical implementations across Corporate and Investment Banking, and Global Markets divisions. You will combine deep Capital Markets domain expertise with advanced data engineering capabilities to solve complex client value measurement and analytics challenges facing the organization.
What will you do?
- Lead business analysis for client value measurement initiatives, including Client Revenue Analytics, Client Resource Consumption, Client Plan, and Client Wallet platforms, leveraging complex financial and operational data to calculate and measure client profitability across all business lines
- Develop comprehensive data requirements and functional specifications for calculating client values for Corporate and Investment Banking transactions and Global Markets trades, ensuring accuracy and compliance with business and regulatory standards
- Own requirements definition for reference data governance and client metrics reporting, collaborating closely with data development and engineering teams to establish data quality standards and validation protocols
- Execute end-to-end project delivery, including scoping, stakeholder alignment, success criteria definition, and production monitoring. Document and communicate milestones, risks, and business impact across technical and business stakeholder groups
- Collaborate and lead discussions with technical teams in project scrum meetings to define clear technical deliverables and drive agile delivery methodologies while maintaining alignment with strategic business objectives
- Present technical solutions to senior business stakeholders, securing approvals and managing acceptance criteria to deliver against business requirements and timelines
- Serve as subject matter expert throughout the analytics product lifecycle, from design and development through implementation, in ensuring solutions meet business expectations and technical standards
Education and Competencies:
- Bachelor's degree or Master's degree in Business, Finance, Computer Science, or related field
- Advanced technical competency in Excel, SQL, and data analytics platforms
- Excellent written and verbal presentation skills with the ability to communicate technical concepts to non-technical stakeholders
- Demonstrated self-motivation, initiative-taking, and results-driven mindset with minimal oversight required
- Strong team collaboration skills with openness to innovative problem-solving approaches
Key Relationships:
- Front-office business stakeholders including banking, sales, client strategy, finance/product control, and business management teams
- Technology teams across development, production support, and enterprise architecture
- Product managers and business analysts in capital markets and adjacent business units
- Capital Markets architecture and data governance teams
- Cross-functional analytics and client revenue management leadership
What do you need to succeed?
Must Have
- Minimum 10 years of business analysis experience in financial institution, preferably Capital Markets
- Strong knowledge of Capital Markets data and products, particularly in Corporate and Investment Banking (credit exposures, new issuances, trades, risk metrics, pricing, reference data, return calculations)
- Strong understanding in Capital Market Risk Management and Compliance / regulatory requirements and be comfortable to interact with Credit Risk, Capital Optimization & Measurement teams in both Risk and Finance groups.
- Advanced hands-on SQL proficiency with demonstrated expertise in data modeling for complex queries, data validation, and comprehensive data analysis
- Proficient in common data analytics and business intelligence/reporting tools such as Excel, Tableau
- Demonstrated exposure to cloud infrastructure platforms (AWS/Azure) with understanding of enterprise data architecture patterns
- Advanced analytical and problem-solving capabilities, with experience managing large-scale, data-intensive initiatives in enterprise environments
- Demonstrated ability to translate complex, ambiguous business requirements into precise data models, system requirements, and technical specifications
- Working experience with Agile and Scrum methodologies, including active participation in sprint planning and delivery
- Excellent communication and presentation skills, with proven ability to engage and influence senior stakeholders