Manager, Commercial Data Transformation & Reporting

Job Summary

Job Description

What is the opportunity?​

Join Commercial Delivery Model and Advisor Strategy team to support monthly data processing initiatives, automation projects and reporting solutions focused on analytics and value proposition. This role is focused on hands-on delivery, improving reporting efficiency, supporting business units with actionable insights and helping implement automation for recurring data tasks. You will work within a dynamic team to streamline processes, enhance data flows and build tools that will support day to day decision making.

What will you do?

Data Transformation & Reporting focus

• Development and maintenance of automated processes using tools such as SQL, Teradata, Datameer and Tableau;
• Support teams in standardizing recurring reports and dashboards for commercial banking teams;
• Help reduce manual workload by building repeatable workflows and data pipelines;
• Maintain data quality checks to ensure that reports are accurate and up to date;
• Connect data from various sources (internal systems, databases, excel files) into cohesive views for analysis;
• Troubleshoot data, reporting issues and provide support for ad hoc data requests;
• Be able to follow a DRY (Don’t Repeat Yourself) development practice. Creating solutions once, to be used many times.

Hands-on data analytics and applications

• Manage Use Cases, specific to Commercial Banking on Data Analytic;
• Construct Data Models to demonstrate behavior monitoring and trends;
• Facilitate the turn-over of data to analytics and insights.

Innovation and transformational initiatives

• Maintain and enhance existing data transformation and reporting tools;
• Support the implementation of new tools that will enable the department’s ability to produce fast insights, proactively identifying and justifying new automation or reporting opportunities and building the business case around new projects and technology;
• Recommend improvements to processes and workflows based on recurring issues or inefficiencies.

Team Collaboration

• Participate in sprint planning or project meetings to support team goals and priorities;
• Coach business users and peers on how use our interpret reports, leverage dashboard and use data solutions to ensure clarity, efficiency and self-serve adoption;
• Share knowledge and documentation to support consistency and reusability across the team;
• Stay current with new tools and best practices in data automation and reporting based on team’s needs.

What do you need to succeed?

Must-have:

• Experience with big data technologies and familiarity with range of data tools (Big Data Tools, Datameer, Teradata, SQL, Python);
• Deep experience on Business Intelligence Tools (Alteryx, Datameer, PowerBI)
• Experience building automated solutions using different tools combined (SQL, Excel, Tableau, PowerBI);
• Experience in analytics and the usage of statistical methods and ability to translate technical data findings into clear business friendly insights;
• Strong ETL principles around data and logic, cleaning and mining;
• Ability to perform complex data analysis on large volumes of data;
• Strong knowledge of design, development, and implementation experience utilizing data science technologies;
• Excellent analytical and problem solving skills.
   

Nice to have:

• Datameer and/or other BI Tools experience;
• Commercial segment & business products knowledge;
• Tableau and other visualization tools experience;
• System implementation and business case creation experience;
• Python & PySpark automation experience.

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.

• Ability to make a difference and lasting impact
• Work in a dynamic, collaborative, progressive, and high-performing team
• Opportunities to do challenging work

Job Skills

Big Data Management, Budgeting, Business Performance Management, Critical Thinking, Knowledge Organization, Long Term Planning, Performance Management (PM)

Additional Job Details

Address:

RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTO

City:

TORONTO

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

PERSONAL & COMMERCIAL BANKING

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2025-06-10

Application Deadline:

2025-06-24

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.

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 jobs.rbc.com.