Senior Data Enablement Analyst

What is the Opportunity?

This is an exciting opportunity in the COO, CFO Group where you will play an instrumental role in coordinating the development of various automation solutions and web-based applications by leveraging RBC’s big data assets. We are currently seeking for an individual with strong business analysis/automation background who is quick to adapt to new technologies and enthusiastic about developing innovative solutions to support the digital transformation in Finance. This role will work with various stakeholders in helping to identify business problems and prioritize them to unlock business value.

The Data Enablement team is focused on developing strategic solutions to support key Report to Shareholder and Regulatory Reporting initiatives across the bank. Our team consists of highly accomplished professionals with various backgrounds in computer science, data engineering, business analytics, accounting and finance to deliver innovative solutions that supports data-driven decisions.

What will you do?

Business Analysis

• Work closely with subject matter experts to document detailed business requirement, and ensures requirements are in line with business goals and objectives
• Translate business requirements and document technical specifications and data lineage
• Analyse large data sets and system extracts to build business rules behind automated data pipelines
• Using SQL to understand data sets about different systems and extract data
• Identify, analyze implications and communicate program issues, risks and dependencies, so that they can be appropriately mitigated

Automation

• Design, develop and test report automation and reconciliation processes using Python
• Develop and execute tests, log and track issues and drive them to resolution with verification of bug fixes, document test results and research findings
• Develop scripts as needed to assist in the systems validation process
• Integrate with existing data storage solutions
• Coordinate with front-end developers and data engineers

What do you need to succeed? Must have

• Strong proficiency in MS Excel for data analysis and financial reconciliation
• 2+ years working experience with Python and SQL
• Experience with data extraction, transformation, and loading from a wide variety of data sources using SQL and related technologies.
• Experience writing clean and concise code using Python and experience with libraries such as Pandas, BeautifulSoup and NumPy
• Excellent verbal and written communication skills
• Excellent analytical skills & critical thinking skills to investigate system and business issues, determine root cause, and deliver sustainable solutions.

Nice to have

• Experience with Capital Markets, Personal & Commercial Banking, Wealth Management products and businesses
• Experience in Finance/Risk’s big data projects.

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, 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

#LI-POST
#LI-Hybrid

Job Skills

Artificial Intelligence (AI), Big Data Management, Data Mining, Data Science, Decision Making, Machine Learning, Natural Language Processing (NLP), Predictive Analytics, Python (Programming Language), Statistical Analysis

Additional Job Details

ROYAL BANK PLAZA, 200 BAY ST:TORONTOTORONTOCanada37.5Full timeOFFICE OF THE CFORegularSalaried2025-04-022025-04-30

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.