Manager, Data Analyst, CFO Group

Job Description

What is the Opportunity?

This is an exciting opportunity in CFO Group where you will play an instrumental role in leveraging RBC’s strategic data assets to build automation solutions and data analytics models. We are currently seeking for an individual with strong data/business analysis 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.

We are hiring multiple Manager roles with areas of focus including:

• Personal Banking and Commercial Banking business and products
• Capital Markets business and products
• International Banking (U.S. and Caribbean)
  Insurance and Corporate Support business and products
• Wealth Management business and products

What will you do?

Data Analysis

• Work closely with subject matter experts to document detailed business requirement, and ensures requirements are in line with business goals and objectives
• Analyze 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
• Work collaboratively with cross-functional teams and develop and manage relationship with relevant stakeholders
• Manage, communicate and author changes to the requirements

Solution Design

• Design, develop and test reporting solutions 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

• Demonstrated experience with data extraction, transformation, and loading from a wide variety of data sources using SQL and related technologies (Oracle, Vertica, Hive, etc).
• Working knowledge in implementing and performance tuning ETL pipelines using Dagster, Apache Airflow or Prefect.
• Proficiency in Python, specifically Pandas, Sqlalchemy, Numpy and Selenium packages.
• Excellent analytical skills & critical thinking skills to investigate system and business issues, determine root cause, and deliver sustainable solutions.
• Commitment to continuous improvement; specifically, ability to identify existing processes and gaps across the current system landscape.

Nice to have

• Experience in RBC IT systems and service platforms (e.g. Core, Confluence, Service Now, Access Manager).
• Open to learn and innovate using tech stack or framework like Flask, Django and any front-end framework.
• Experience in managing Windows Servers using IIS.
• Proficiency in Excel VBA.
• Experience with Business Intelligence Reporting & visualizations using Tableau.
• Basic knowledge of git, APIs, Docker and/or Dev Ops.

What’s in it for you?

It provides the opportunity to be a part of a high performing experienced team with progressive thinking to deliver trusted advice to help our clients thrive and communities prosper.

• Opportunities to do challenging work utilizing latest technologies
• Opportunities to see measurable results in relatively short term
• Opportunities to take on progressively greater accountabilities
• Opportunities to building close relationships with counterparts across the bank

Job Skills

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

Additional Job Details

Address:

ROYAL BANK PLAZA, 200 BAY ST:

TORONTO

City:

Toronto

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

OFFICE OF THE CFO

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

Final date to receive applications:

Note: Applications will be accepted until 11:59 PM on the day prior to the Final date to receive applications date above

I
nclusion 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…