Senior Analyst, BI Reporting - RBC - Toronto, ON

As Senior Analyst, Business Intelligence Reporting, you will be responsible for the production, development, enhancement and maintenance of platform and Head Office financial and non-financial reporting for external, management and other reporting needs. You will provide production support in monthly/quarterly/yearly reporting activities and implement automated solutions according to business requirements and manager’s direction. Support Finance Shared Services – Reporting Services strategic direction and vision.

What will you do?

• Accountable for the production, maintenance and enhancements of required financial and non-financial reports specific to WebFocus, SQL, Cognos BI and other reporting tools
  


• Responsible for the development and timely delivery of scheduled, new and adhoc reports and change requests. This includes requests against EPM, CGID, EDW, Finance Datamart or other data sources
  


• Automate and streamline reporting process relating to report distribution, scheduling, bursting, etc.
  


• Maintain reporting environment and reporting governance around publishing of BI reports (Cognos Report Studio, Event Studio, Webfocus, …)
  


• Ensure Service Level Agreement is met and reports are produced/scheduled within agreed timelines and GV runs, providing reporting support during month end, quarter end reporting cycles and forecasting/planning periods.
  


• 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
  


• Participate in special projects as required
  

What do you need to succeed?

Must-have

• Bachelor’s degree in business, financial engineering, math or computer science disciplines or equivalent education/experience with strong knowledge of technology and financial reporting processes and financial Services Industry experience & general business acumen
  


• Strong combination of technical competencies and financial/business knowledge to develop reporting solutions
  


• Strong knowledge of RBC source systems in business units and reporting processes (e.g. EDW, OLMS, OLBB, DDA, TPS/eTL, … )
  


• Strong technical proficiency in BI reporting tools with a focus on WebFocus, SQL, Cognos Report Studio, etc.
  


• Quick learner to grasp new reporting tools within a very short time frame and apply the skills to develop, produce and maintain reports
  

Nice-to-have

• RBC Finance and organizational knowledge preferred
  


• Working knowledge of RBC financial systems (EPM/Cognos TM1, CGID, PeopleSoft, FiBRS, Finance Datamart, Requestor Tools)
  


• Experience with VBA
  


• Experience with using Cognos report studio against TM1 dimensional cubes
  

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
  

About RBC

Royal Bank of Canada is Canada’s largest bank, and one of the largest banks in the world, based on market capitalization. We are one of North America’s leading diversified financial services companies, and provide personal and commercial banking, wealth management, insurance, investor services and capital markets products and services on a global basis. We employ approximately 78,000 full- and part-time employees who serve more than 16 million personal, business, public sector and institutional clients through offices in Canada, the U.S. and 39 other countries. For more information, please visit rbc.com .

Join our Talent Community

Stay in-the-know about great career opportunities at RBC. It’s easy! Join our Talent Community and get the inside scoop on the jobs, career paths, and recruitment events that matter to you.

Inclusion and Equal Opportunity Employment

RBC is an equal opportunity employer committed to diversity and inclusion. We are pleased to consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veterans status, Aboriginal/Native American status or any other legally-protected factors. Disability-related accommodations during the application process are available upon request.

JOB SUMMARY

City: Toronto

Address: 155 Wellington St. West

Work Hours/Week: 37.5

Work Environment: Office

Employment Type: Permanent

Career Level: Experienced Hire/Professional

Pay Type: Salaried

Required Travel (%): 0

Exempt/Non-Exempt: N/A

People Manager: No

Application Deadline: 08/26/2016

Req ID: 114347

Posting Notes: None