Manager Financial Reporting - Finance

Scotiabank; Toronto; On-site; CAD 80,000 - 120,000; Full time

Job summary

Scotiabank in Toronto is seeking a skilled Power BI/MSSQL Developer to design, develop, and maintain BI solutions. You will collaborate with business stakeholders to understand data needs, build data models, and implement ETL processes to deliver actionable insights through dashboards and reports.

The role requires strong SQL, data modeling, and Power BI expertise, with experience in Power Query and DAX. Located in Toronto, the position emphasizes data governance, performance optimization, and

Qualifications

• Proficiency in SQL and experience with relational databases.
• ],
• job_responsibilities_description [

Responsibilities

• Design and develop interactive dashboards and reports using Power BI.

Skills

Power BI

SQL

Data visualization

Data modeling

ETL

DAX

Power Query

Python/R assets

Azure/AWS BI services

Tools

Power BI

SQL Server

Power BI Report Builder

Job description

Select how often (in days) to receive an alert:

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

Purpose

We are seeking a skilled Power BI/MSSQL Developer to join our team. The ideal candidate will be responsible for designing, developing, and maintaining business intelligence solutions using Microsoft Power BI and MSSQL database. This role involves working closely with business stakeholders to understand their data needs and collaborate with the team in data modeling and programming activities to produce actionable insights through interactive dashboards and reports.

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

• Data Visualization: Design and develop interactive dashboards and reports using Power BI.
• Data Modeling: Create and maintain data models to support reporting and analytics needs.
• Data Integration/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 to gather requirements and ensure BI solutions meet their needs.
• Performance Optimization: Optimize Power BI reports, 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: 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 with data modeling, ETL processes, and data warehousing
• Proven experience as a Power BI Developer or similar role.
• Strong proficiency in Power BI, including DAX and Power Query.
• 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.
• Experience with other Reporting tools (e.g., Power BI Report builder) is an asset.
• Experience with programming languages (e.g., Python, R) is an asset.
• Familiarity with cloud platforms (e.g., Azure, AWS) and their BI services is an asset.
• Certification in Power BI or related technologies is an asset.
• Proficiency in Spanish is an asset.

What’s in it for you?

• The opportunity to join a forward-thinking company surrounded by a collaborative team of innovative thinkers.
• A rewarding career path with diverse opportunities for professional development.
• Internal development to support your growth and enhance your skills.
• An organization committed to making a difference in our communities - for you and our customers.
• We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!

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.

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.