Sr. Manager, Data and Planning
Royal Bank of Canada View all jobs
- Toronto, ON
- Permanent
- Full-time
- Develop and deliver management reports and automated dashboards (using tools like Tableau) to enable real-time insights and executive oversight.
- Support monthly business reviews, test planning, and SLA reviews through data-driven storytelling for leadership (e.g., Board/Committee updates).
- Partner with Platform teams, ECCO, and 2LOD to address enterprise-wide reporting needs and management queries.
- Provide data analysis and insights to support strategy development, identify control trends, and enable performance management.
- Serve as a data subject matter expert (SME), providing guidance to ECT and ECCO teams on data insights and analytical approaches.
- Manage and enhance ECT data systems/infrastructure, including building data feeds, connections, and repositories (e.g. data warehouse/lakes).
- Execute staffing models to estimate capacity availability across teams and geographies; translate testing attributes into staffing model assumptions.
- Track productivity/capacity data, identify trends, and proactively inform testing leaders of potential challenges.
- Forecast near/medium-term testing volume and support operations leaders in developing and managing test plans.
- Develop creative solutions in partnership with testing leaders to match work demand with staffing supply and balance workload.
- Support the selection and implementation of workflow tools to enhance resource deployment and team efficiency.
- Contribute to continuous improvement of planning processes and capabilities.
- 5+ years of work experience in data analytics, reporting, business intelligence, capacity planning, or related roles within a large, complex organization.
- Strong hands-on expertise with:
- SQL (complex querying, data transformation, integration with other tools)
- Python (data cleaning, preprocessing, transformation, scripting)
- Tableau (dashboard development, executive reporting)
- Experience working with enterprise databases and large-scale data platforms.
- Proven ability to translate business questions into analytical solutions and actionable insights.
- Familiarity with operational risk management (first and/or second line of defense capacities) and/or experience in an operations environment supporting multiple business units.
- Demonstrated ability to deliver on competing priorities and manage timelines and expectations to ensure timely execution.
- Strong communication and presentation skills; ability to tailor messaging for various levels of seniority.
- Experience managing diverse stakeholders; strong negotiation and influencing skills in a matrixed environment.
- Bachelor's Degree in Data Science, Information Technology, Mathematics, Statistics, Computer Science, or related background.
- Experience with capacity management practices and workflow tools.
- Previous experience working in highly regulated business environments or financial services sector.
- Knowledge of and/or experience across different platforms and functional units of a diversified financial services firm, including exposure to multiple geographies.
- A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable
- 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
- A world-class training program in financial services
- Flexible work/life balance options
- Opportunities to do challenging work