Power BI Product Specialist
Requisition ID: 269327
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
**Team**
Our team is responsible for the systems that support Global Finance.

We support over 1000 users across the Finance teams in the bank.
**Role**
This role would support the regulatory reporting automation and other initiatives that support the Finance teams.

The successful candidate will work closely with various stakeholders including business partners in Global Finance, business analyst, architecture, and infrastructure and support to understand business requirements and drive the analysis and design of quality technical solutions that best support the business need.
**What will we expect from you?**
Gather requirements, design and build new features
Collaborate with the product owner, project manager and other relevant teams
Ensure best possible performance, quality and responsiveness of the applications
Identify bottlenecks and bugs, and devise solutions to these problems
Excellent understanding of developer life cycle and enterprise developer tools
Power BI report creation, debug issues and performance improvements
**What You Will Bring to Succeed**
Power BI Desktop & Power BI Service
DAX (Data Analysis Expressions) for measures and KPIs
Power Query (M Language) for data transformation
Semantic Model / Data Model Design
SQL Development and Query Optimization
Star Schema and Dimensional Modeling
Data Integration from Oracle, SQL Server,
Power BI Gateway configuration and troubleshooting
Incremental Refresh and Large Dataset Optimization
Row-Level Security (RLS) and Data Security
Financial and regulatory reporting
Data visualization best practices
Ad hoc reporting and self-service analytics
Data quality validation and reconciliation
**Preferred and good to have**
Azure Data Factory
Microsoft Fabric
Synapse Analytics




Databricks
Power BI Deployment Pipelines
CI/CD and Dev

Ops practices
**The Workplace**
We are technology partners who help the business transform how our employees around the world work
We have an inclusive and cooperative working environment that encourages creativity, curiosity, and celebrates success!
You'll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world
We foster an environment of innovation and continuous learning
We care about our people, allowing them to design how they work to deliver amazing results
We offer a competitive total rewards package, including a performance bonus, company matching programs (on pension & profit sharing), and generous vacation.

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, pleaseclick here (https://www.scotiabank.com/careers/en/careers/technical-support-for-applicants.html) .

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.

📌 Power BI Product Specialist (Toronto)
🏢 Scotiabank
📍 Toronto