Senior Manager, CRM Data Enablement and Reporting

What is the opportunity?

As Senior Manager, CRM Data Enablement and Reporting, you will bring a proven track record of leading the development of strategic reporting and data visualization which allow us to monitor client growth, marketing campaign performance and enable our partners to make decisions with relevant data and insights. In this role you will work directly with Marketing, Sales, Product, Next Best Action business partners to fulfill the following critical functions:

• Support RBC's client growth initiatives by providing data, reporting and insights on the measurement of new client acquisition and client defection

• Development and delivery of next generation marketing campaign performance reporting solutions required for Personal and Commercial Banking to meet business, marketing and financial imperatives

• Demonstrate and provide subject matter expertise in data and reporting infrastructure design and optimization, using data visualization and analytical tools such as Tableau, SAS and Jupyter Notebook

• Promote best practices in data and reporting development such as standardized look and feel, accurate measurement of key metrics, adoption of automation process and enablement of data through the implementation of semantic data layer

What will you do?

• Lead the development and maintenance of client growth reporting solution that tracks client acquisition and retention KPIs across LOB levers, acquisition channel, client segment and region

• Lead the end-to-end design and delivery of CRM and campaign reporting in support of Next Best Action journeys and offers

• Collaborate with business and marketing stakeholders on the delivery of easy to use, self-serve dashboards that captures user requirement such as response metrics, segment/channel performance, client coverage metrics and financial performance

• Drive the continuous improvement effort by proactively identifying enhancement and/or optimization opportunities within existing reports for both front end and back end that will improve overall user experience

• Lead strategic initiatives to explore, understand and leverage Enterprise Data Lake (EDL) /Cloud (Snowflake) as new data source for capturing client, product, marketing related metrics and insights that are not available in the Enterprise Data Warehouse (EDW)

• Lead the effort on adoption of online/digital data using Starburst Trino for the identification and measurement of digital leads. Ensure key digital metrics are reported across campaign reports and dashboards

• Conversion of existing suite of reporting from SAS to Python via Jupyter Notebook

What you need to succeed?

Must-have:

• Leadership skills with a proven track record of obtaining results through collaboration, impact and influence, and knowing when done is better than perfect

• Ability to perform complex data analysis and manipulation using SAS (Base SAS 9.4/Enterprise guide/SAS Studio) and Python (Jupyter Notebook)

• Advanced proficiency in developing user-friendly reports and dashboards using Tableau

• Superior and proven technical experience with large relational databases (ex. Teradata)

• Proven experience in report automation

• Ability to bring the right people to the table to solve a problem, empowering individuals drive creative and client-centric solutions

• Strong business acumen and communication and presentation skills

• Undergraduate degree in a quantitative discipline (e.g., Computer Science, Math, Statistics, Engineering)

Nice-to-have:

• Experience leading teams of highly skilled professionals

• Experience in financial services industry

• Experience working with Enterprise Data Lake (Hadoop) using tools/programming languages such as Dataiku, Python, Spark SQL, Starburst Trino

• Knowledge of Direct Marketing Campaigns

• Understanding of product management, sales, finance, pricing and risk management

• Master's degree in quantitative discipline

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.

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation

• Ability to make a difference and lasting impact

• Work in a dynamic, collaborative, progressive, and high-performing team

• Opportunities to take on progressively greater accountabilities

Job Skills

Additional Job Details