Senior Analyst, Reporting Shared Services

Job Description

What is the opportunity?

As Senior Analyst, you will be responsible for the production, development, enhancement and maintenance of platform financial reporting for external, management and other reporting needs. You will provide production support in quarterly, monthly and year-end reporting activities and implement automated solutions according to business requirements. You will also support Reporting Shared Services strategic direction and vision.

What will you do?

• Accountable for the production, maintenance and enhancements of required financial management reports
• Accountable for the timely development and delivery of scheduled, new and ad hoc reports and change requests
• Support the Finance teams responsible for the financial reporting of Total RBC
• Interact with Finance/business platforms to ensure accurate understanding of report requirements and provide timely response to user requests
• Interact with RBC's auditors: internal, external, SOX controls
• Ensure report and quality standards are adhered to and continuous improvement initiatives are embedded within production and development
• Ensure adequate and up to date documentation on workflow tickets, report inventory, reporting processes and related activities/components
• Responsible for ensuring KPI (Key Performance Indicators) that metrics and quality standards are adhered to

What do you need to succeed?

Must-Have:

• Bachelor's degree in Business/Accounting/Finance or Finance/Accounting designation or equivalent education and experience
• Quick learner to grasp new reporting tools within a very short time frame and apply the skills to develop, run and maintain financial reports
• Advanced knowledge of Microsoft Excel
• Intermediate knowledge of VBA (Visual Basic for Application) or equivalent programming language

Nice-to-have:

• Knowledge of Certent CDM, Cognos TM1, Cognos Analytics, TM1 Perspectives, IBM Planning Analytics for Excel (PAfE)
• Programming (SQL, WebFOCUS, etc.)
• Lean Six Sigma tools; Agile Methodology; Quality Assurance

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
• Opportunities to do challenging work

Job Skills

Accounting, Ad Hoc Reporting, Finance, Financial Planning and Analysis (FP&A), Financial Reporting and Analysis, IBM Cognos Analytics, IBM Cognos TM1, Ibm Planning Analytics, Learning New Technologies, Learning Quickly, Microsoft Excel, Microsoft Excel Functions, Microsoft Excel Macros, Microsoft Excel VBA Programming, Multidimensional Expressions (MDX), Structured Query Language (SQL)

Additional Job Details

Address:

180 WELLINGTON ST W:TORONTO

City:

Toronto

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

TECHNOLOGY AND OPERATIONS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

Application Deadline:

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