Manager Business Intelligence & Decision Support

Scotiabank; Toronto; On-site; CAD 90,000 - 130,000; Full time

Job summary

A leading bank in the Americas is seeking a Manager for Business Intelligence & Decision Support in Toronto. The role involves data visualization, modeling, and collaboration with stakeholders to optimize financial processes. Candidates should be skilled in SQL, Power BI, and analytical problem-solving. Competitive rewards including performance bonuses and benefits from day one.

Benefits

Performance bonus

Employee Share Ownership Program

Pension Plan Matching

Health Benefits from day one

Qualifications

• Proficiency in SQL and experience with relational databases.
• Experience in Power BI, DAX, and data warehousing.
• Strong analytical and problem-solving skills.

Responsibilities

• Design and develop dashboards using Power BI.
• Create and maintain data models for reporting.
• Develop and manage ETL processes.

Skills

SQL

Data Visualization

Data Analysis

Collaboration

Communication

Tools

Power BI

DAX

ETL Processes

VBA

Job description

Requisition ID: 225883

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

We are seeking a skilled Manager Business Intelligence & Decision Support to join our team. The ideal candidate will be responsible for maintenance and improvement of current profitability process, data extraction from different sources, data quality and collaborate with the team in data modeling activities. To develop the work properly is required strong knowledge of SQL Server programming, MS Cubes and Power BI. This role involves working closely with business stakeholders and Financial Managers to understand financial processes and accounting to apply properly into our MIS processes.

Is this role right for you? In this role, you will:

• Data Visualization: Design and develop dashboards and reports for data quality and control of processes using Power BI.
• Data Modeling: Create and maintain data models to support reporting and analytics needs.
• ETL Processes: Develop and manage ETL processes to ensure data is accurately and efficiently loaded into the BI system.
• Data Analysis: Perform data analysis to identify trends, patterns, and insights that support business decision-making.
• Collaboration: Work with business stakeholders and Senior Management to gather requirements and ensure BI solutions meet their needs
• Performance Optimization: Optimize internal processes and programs for performance and usability
• Documentation: Document BI solutions, including data models, ETL processes, and report specifications.
• Training and Support: Provide training and support to end-users on Power BI tools and reports.
• Data Governance: Collaborate with Senior Management to ensure data accuracy, integrity, and security within the BI environment.

Do you have the skills that will enable you to succeed in this role? - We'd love to work with you if you have:

• Proficiency in SQL and experience with relational databases.
• Experience in Power BI, DAX MIS Analysis Server, Phyton, VBA
• Experience with data modeling, ETL processes, and data warehousing.
• Excellent analytical and problem-solving skills.
• Strong communication and collaboration skills.
• Ability to work independently and manage multiple projects simultaneously.
• Knowledge of data governance and best practices for data security.
• High workload is expected and working extra time

What’s in it for you?

• An inclusive & collaborative working environment that encourages creativity, curiosity, and celebrates success!
• We offer a competitive rewards package: Performance bonus, Employee Share Ownership Program, and Pension Plan Matching, Health Benefits from day one!
• Your career matters! You will have access to career development and progression opportunities.

#scotiafinancejobs

Location(s): Canada : Ontario : Toronto

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.