Senior Analyst, Reporting Shared Services
RBC Capital
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
#LI-POST
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:
City:
Country:
Work hours/week:
Employment Type:
Platform:
Job Type:
Pay Type:
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 at jobs.rbc.com.