Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

This role supports regulatory reporting automation and other initiatives for the Finance teams. The successful candidate will collaborate with stakeholders to understand business requirements and drive the analysis and design of technical solutions.

Responsibilities

• 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
• Power BI report creation, debug issues and performance improvements

Requirements

• Excellent understanding of developer life cycle and enterprise developer tools
• 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
• Azure Data Factory
• Microsoft Fabric
• Synapse Analytics
• Databricks
• Power BI Deployment Pipelines
• CI/CD and DevOps practices

Skills

• Power BI
• DAX
• M Language
• SQL
• Data Modeling
• Data Integration
• Azure Data Factory
• Microsoft Fabric
• Synapse Analytics
• Databricks
• DevOps

Location

• Toronto, Ontario, Canada

Work Type

• Full-time

Benefits

• Performance bonus
• Company matching programs (on pension & profit sharing)
• Generous vacation

About the Company

• Scotiabank is a leading bank in the Americas.
• 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.
• We are technology partners who help the business transform how our employees around the world work.
• We have an inclusive and collaborative 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.

Equal Opportunity

• 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.