Manager, Business Intelligence and Information

3 weeks ago


Toronto, Canada Royal Bank of Canada Full time

**Come Work with Us**

At RBC, our culture is deeply supportive and rich in opportunity and reward. You will help our clients thrive and our communities prosper, empowered by a spirit of shared purpose.

Whether you’re helping clients find new opportunities, developing new technology, or providing expert advice to internal partners, you will be doing work that matters in the world, in an environment built on teamwork, service, responsibility, diversity, and integrity.

**Job Title**

Manager, Business Intelligence and Information Management

**What is the opportunity?**

RBC Regional Banking Support’s **Retail Data Infrastructure Management **is hiring a Manager, Business Intelligence & Information Management role that will support strategic reporting and visual insights for Retail Banking by successfully managing the implementation of changes to the ETL system processes and enablement of data pipeline job executions, enforcing proper data management governance, and maintaining the data infrastructure components and tools.

The incumbent plays a critical role in driving and enabling strategic, timely, and accurate insights to business partners and senior leaders in Retail Banking, leveraging business knowledge, strong collaboration with key technology partners and enforcement of sound governance practices to maintain the integrity of and to protect our data assets.

**What will you do?**
- Leads the scheduling, implementation and deployment of ETL jobs, support of BI tools and management of infrastructure components of Retail Reporting Team that underpins our delivery of business metrics and field reports.
- Responsible for development & production of metrics and reports that provide insight into the health of the infrastructure component.
- Support strategic initiatives to modernize and improve use of BI tools to maximize business values and processing efficiency.
- Conduct thorough investigations, identify cause of any production issues and resolve them.
- Monitors, tests, analyzes, actions and communicates all system upgrades and migration to ensure full functionality and no business impacts.
- Identify gaps in existing governance model and lead its change management with manager support.
- Supports business partners and stakeholders by successfully transforming data into useful, relevant information, and by leveraging sound business knowledge, additional sources of information, and resources to deliver insight to our internal clients.

**What do you need to succeed?**

**Must-have**:

- Degree in Computer Science, Mathematics/Statistics, Engineering, related field or equivalent related experience.
- Demonstrated ETL and big data modeling capabilities, with programming experience in large databases/datasets and using SAS, SQL Server and Teradata SQL Assistant.
- Experience in statistical methods, strong data profiling, cleaning, and mining.
- Proficient in SQL extracts in order to investigate data from data warehouse and other sources (flat files) for investigation/analysis purposes.
- Ability to perform complex data analysis on large volumes of data and present findings to senior leaders in order to inform of strategic decisions.
- Proven quantitative analytical (including data knowledge, data discovery, data aggregation and summarization) and problem solving skills.
- UNIX knowledge (i.e. submit process, create logs, store data, file systems and access management).
- Advanced in developing reports using Tableau.
- Expert technical documentation skills and the ability to effectively communicate, verbally and in writing, technical concepts to a non-technical audience.

**Nice to have**:

- Financial Services Industry/Business Financial Services knowledge
- Experience in developing performance metrics/reports
- Programming/coding skills in Python, Snowflake and Hadoop (HIVE)
- Experience with Tableau Security and Tableau Server Administration.

**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
- Opportunities to do challenging work and take on progressively greater accountabilities

**Job Summary**

**Address**:
TORONTO, Ontario, Canada

**City**:
CAN-ON-TORONTO

**Country**:
Canada

**Work hours/week**:
37.5

**Employment Type**:
Full time

**Platform**:
Personal and Commercial Banking

**Job Type**:
Regular

**Pay Type**:
Salaried

**Posted Date**:
2023-03-17

**Applica



  • Toronto, Canada Family Service Toronto Full time

    **Program**: Information Technology*** **Contract**: One Year Contract, Full time 35 hours/week **Location**: 128A Sterling Road, 355 Church Street and a home-based office as required **Application Deadline**: August 4, 2023, by 5:00 PM **File Number**: IT #42-23 with cover letter and resume **E-Mail**: **Mail**: HR, 355 Church Street, Toronto ON M5B...


  • Toronto, Canada Transatlantic Business Consulting Inc. Full time

    **Business Intelligence Specialist (Power BI)** - 3+ years using Power BI software development, including using DAX queries and functions - Microsoft Azure services such as Power Apps, Power Automate, Azure Database, Azure Analysis Services, Azure Synapse, Customer Voice, etc. - SQL Server - Oracle - Ability to translate wireframes, lo-fidelity and...


  • Toronto, Canada Home and Community Care Support Services Full time

    Job Description CARE AND BE CARED FOR – THIS IS YOUR HOME Are you a collaborative Business Intelligence professional with expertise in multiple business intelligence tools and methodologies? Do you enjoy analyzing and refining operational processes to improve efficiency? Are you passionate about exceptional health care and driven by a desire...


  • Toronto, ON, Canada Edelman Data X Intelligence Full time

    Data and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...


  • Old Toronto, Canada Edelman Data X Intelligence Full time

    Data and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...


  • Old Toronto, Canada Edelman Data X Intelligence Full time

    Data and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...


  • Old Toronto, Canada Edelman Data X Intelligence Full time

    Data and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...


  • Toronto, Canada Douglas College Full time

    The Role Under the direction of the AVP, Institutional Effectiveness, the Manager, Business Intelligence & Data Analytics is responsible for leading the development of business intelligence tools that can support evidenced-based decision-making throughout the College. These tools assist Deans, Directors, Chairs, Coordinators, and Senior Management with...


  • Toronto, Canada iPartner Staffing Full time

    Hybrid work Arrangement - 3 days per week ETL Azure SQL POWER BI Developer Power BI reporting - 10+ years of technical data warehousing experience with a focus in the design and development of Business Intelligence - Experience with Azure Analysis Services / SSAS (tabular/multidimensional), SQL Server Reporting Services (SSRS) and Power BI - Development...

  • Business Intelligence

    1 month ago


    Toronto, Canada iPartner Staffing Full time

    Must Haves: - Demonstrated experience with database design (SQL Server, Oracle) Experience developing BI and analytics Roadmaps for clients (e.g. Microsoft BI) - Working knowledge of advanced data visualization tools and techniques (statistical graphics, plots, information graphics). Some tools that would be of interest are Rshiny, Google Analytics,...


  • Toronto, Canada FLEETCOR Full time

    Business Intelligence Analyst II (FP&A - Finance and Technology) What We Need FLEETCOR is currently looking to hire a Business Intelligence Analyst II, within our Corpay division. This position falls under our Corpay Cross Border line of business and is located in 212 King Street West, Toronto ON. We are seeking a skilled Business Intelligence Analyst II to...


  • Toronto, Canada Analyticsmart Full time

    **Manager, Business Intelligence and Category Management** **About ANALYTICSMART** Analyticsmart is a boutique analytics firms in the Consumer Package Goods Industry in Canada and the United States. Our mission is to translate data into meaningful, measurable, and actionable insights that drive growth and increase profitability for businesses. We provide...


  • Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Senior Business Intelligence and Data Integration Developer Monday, May 6, 2024 Term: 1 Permanent and 1 Contract, Full-Time Division/Branch: Information and Information Technology (I&IT) Division / Enterprise Data and Analytics Branch Application Deadline: May 17, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office,...


  • Toronto, ON, Canada Alcohol and Gaming Commission of Ontario Full time €92,902 - €116,123

    Senior Business Intelligence and Data Integration Developer Monday, May 6, 2024 Term: 1 Permanent and 1 Contract, Full-Time Division/Branch: Information and Information Technology (I&IT) Division / Enterprise Data and Analytics Branch Application Deadline: May 17, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto,...


  • Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Senior Business Intelligence and Data Integration Developer Monday, May 6, 2024 Term: 1 Permanent and 1 Contract, Full-Time Division/Branch: Information and Information Technology (I&IT) Division / Enterprise Data and Analytics Branch Application Deadline: May 17, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office,...


  • Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Senior Business Intelligence and Data Integration Developer Monday, May 6, 2024 Term: 1 Permanent and 1 Contract, Full-Time Division/Branch: Information and Information Technology (I&IT) Division / Enterprise Data and Analytics Branch Application Deadline: May 17, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office,...


  • toronto, Canada Exchange Solutions Full time

    The Senior Business Intelligence Analyst is a role within the Analytics and Optimization team reporting to the Manager, Business Intelligence Analytics. The individual will be responsible for managing and delivering responsibilities related to reporting and analytics needs. The analyst will work cl


  • Toronto, Canada NR Consulting Full time

    Title :: Intermediate Business Intelligence Specialist (Hybrid)  Location :: Toronto, ON, Canada Duration : Contract Security Level OPP Level Services/Deliverables: The Business Intelligence and Analytics resource deliverables are outcomes and outputs that they provide to the organization. Deliverables may include: Develop Performance...


  • Toronto, Canada Altis Technology Full time

    Senior Business Intelligence Developer – MicroStrategy Project: Insight Med EchoBackground: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project. Responsibilities:Design, develop, test, and deploy MicroStrategy-based visualizations, documents, dossiers, and...


  • Toronto, Canada Altis Technology Full time

    Senior Business Intelligence Developer – MicroStrategy Project: Insight Med EchoBackground: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project. Responsibilities:Design, develop, test, and deploy MicroStrategy-based visualizations, documents, dossiers, and...