Title:  Manager, Business Intelligence (Power BI)

Requisition ID: 199969

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

Reporting to the Senior Manager, Enterprise Crisis Management, you will be a key member of our Enterprise Crisis Management, Business Intelligence & Reporting team. Your role will be to provide effective, strategic, tactical, and operational insights that are key for informed decision making. You will leverage your expertise in data visualization, guided analytics, and strong data architecture background to organize and transform data into meaningful information. You will be responsible of the entire BI stack and development lifecycle - from data profiling and modeling to integration and dashboard creation - ensuring that information is both accessible and meaningful. You will also contribute to the overall success of the Enterprise Crisis Management function globally by ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team’s business strategies and objectives.  This includes ensuring all activities conducted are in compliance with governing regulations, internal policies and procedures.

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

• You are eager to champion a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems, and knowledge.
• You embrace working closely with stakeholders to understand business needs, data specifications and translate requirements into technical design and wireframe.
• You enjoy defining & developing actionable KPIs/metrics that align with strategic goals within Enterprise Crisis Management.
• You are confident to act as team Subject Matter Expert (SME) on Enterprise Crisis & Business Continuity Management (ECBCM)’s datasets, business processes, and source systems.
• You excel at defining, establishing, validating, and maintaining high quality data foundation for Business Intelligence (BI) in collaboration with technology partners.
• You are keen to support the Senior Manager on designing and establishing BI framework, including dashboard templates, design and data standards, code promotion process, security/access and version control.
• You can sustain BI assets after release, prioritize fixes for defects, measure, and track metrics, proactively identify enhancement opportunities, raise data quality concerns, and implement improvements.
• It’s a part of your DNA to work on multiple activities simultaneously in a highly dynamic environment and you’re capable of understanding requirements and meeting project deadlines.

• You strive to champion a high performance and continuous improvement environment by providing technical leadership to team members to support Senior Manager on developing team’s capability.

Do you have the skills that will enable you to succeed in this role?

• You can demonstrate strong communication (verbal/written/presentation) skills.
• You have at least 2+ years of hands-on working experience in developing BI solutions via Microsoft’s Power BI & would include demonstrated working experience with: Power BI Premium, Power BI Dataset, Power BI Datahub, and Power Query.
• You have at least 2+ years of advanced hand-on working experience with MS Excel by creating/maintaining queries, reports & macros.
• You can demonstrate expert working knowledge of dimensional data modelling and BI semantic layer implementation.
• You have working knowledge of database management/data virtualization/logical data warehouse.
• You are proactive, organized, and have excellent analytical and problem-solving skills.
• You also have strong prioritizing, planning, analytical, project management, and relationship building skills.
• Knowledge of best practice in data visualization and User Experience (UX) is an asset.
• Knowledge of SQL is also an asset.
• Completion of a post-secondary degree in Computer Science, Engineering, or similar fields of study.
• Completion of a Certification in Business Intelligence is preferred.

What’s in it for you?

• You’ll partner, work, and collaborate within a high-performing, fast paced team that has global reach and impact.
• The unique opportunity to explore the inner workings, functions and processes of business lines and how they impact the organization.
• Exposure to a vast network of peers and business professionals across the bank that will prove invaluable in career exploration.
• Development of highly critical, in-demand and easily transferable Business Continuity and Crisis Management skills.
• An inclusive culture where employee’s contributions are valued and recognized as contributing to the team and the organizations objectives.

• You'll get to work with and learn from diverse industry leaders, who have hailed from top companies around the world.
• We offer a competitive total rewards package, including a performance bonus, company matching programs (pension & Employee Share Ownership), generous vacation; health/medical/wellness benefits; employee banking privileges.

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.