Back to career opportunities

Power BI Developer

Employment Status
Permanent Full-Time
Toronto, ON
IT Development
Reporting To
Manager, Data Services
Job Id
ITD - 025
Job Level
Seniority Level
Position Overview

As a Power BI Developer, you will bring extensive experience using Microsoft Power BI and broader Power Platform to translate business needs into easily understandable reports and visualizations. Working with members of our business community as well other Data Services team members, you will be accountable for gathering requirements from the client for development, testing and implementation. You are often leading solutions with an iterative and consultative approach, as well as providing support and mentoring to other team members.

The successful candidate will also have the opportunity to influence a multi-year data architecture modernization program currently underway, helping to ensure the data architecture serves our business needs as the organization evolves.

Duties & Responsibilities
  • Serve as a Subject Matter Expert (SME) within all aspects of Microsoft Power Platform and collaborate with different teams to understand the business requirements and conduct gap analysis
  • Conceptualize, design and implement Microsoft Power BI solutions from the existing corporate database and burgeoning data lakehouse/warehouse, as well as other enterprise data sources
  • Build automated reports & dashboards with the help of Power BI & other reporting tools
  • Leverage and extend processes aligned to data visualization best practices (as defined or adopted by business sponsors) and standards, ensure quality (Alignment to form, fit and function)
  • Perform detailed analysis on tested and deployed Power BI scripts
  • Make essential technical and strategic changes to optimize Power BI environments
  • Assist in the design of logical and physical dimensional data mart models
  • Conduct unit & integration tests, assisting in test preparations to ensure data integrity, data quality, and program functional completeness & correctness
  • Produce and maintain technical documentation for colleagues, as well as procedures for end users
  • Participate in the development of project plans to establish appropriate workload expectations and schedules
Skills & Qualifications
  • 4+ years of experience in a Power BI Developer, or similar data-related role
  • 4+ years of experience with SSAS, SSRS, SSIS, in MS SQL Server 2016 or higher
  • Excellent analytical skills and ability to present ideas and recommendations to various stakeholders and ability to grasp complex business
  • Demonstrated expertise in Power Platform (PowerApps, MS Flow and Power BI)
  • Experience with DAX, M and SQL languages
  • Experience in programming, scripting, automation, and customization initiatives
  • Practical knowledge of Microsoft Power BI service architecture design and administration, defining roles and security
  • Strong knowledge of data warehousing, including data source analysis and profiling, as well as Relational DBMS
  • Critical thinking capabilities and a consultative mindset
  • Excellent soft skills and readily able to communicate ideas and concepts to business sponsors and non-technology colleagues
  • Ability to thrive in a busy, high pressure, wealth management IT environment
  • Financial Services industry experience, preferably interacting with data flowing from Broadridge Dataphile or ISM back-office applications, and trading applications
  • Experience with other BI tools Azure data platform (e.g., ADLS, Synapse, ADF, Databricks etc.) and agile delivery methodology preferred
  • Bachelor’s degree in Computer Science, Software Engineering, Business Intelligence, Data Science, or related education or experience
  • A Canadian Securities Course or commensurate experience is a definite advantage