Senior BI Developer – Executive Analytics & Fabric Platform

Range•Toronto, ON

11d

About The Position

At Range Group, we are seeking an experienced Senior BI Developer to modernize our analytics platform and build executive reporting for senior leadership. This role is crucial in transforming our analytics environment by migrating legacy SQL Server and Power BI Desktop reporting into a Microsoft Fabric Lakehouse architecture. The successful candidate will combine executive dashboard development, forecasting analytics, and data platform modernization. This position sits at the intersection of business analytics and modern data platforms, translating business metrics into scalable Fabric-based semantic models to support executive decision-making and future AI-driven analytics capabilities. We are committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. Range Group may use artificial intelligence throughout the recruitment process to screen, assess or select applicants, but final hiring decisions are made by humans.

Requirements

Strong Power BI development experience (data modeling, DAX, performance optimization)
Advanced SQL development skills
Experience building executive KPI dashboards
Strong experience designing Power BI semantic models, not just building report visuals
Experience implementing forecasting or time intelligence models
Hands-on experience with Microsoft Fabric or Azure data platforms
Experience working with Lakehouse architectures and semantic modeling
Ability to translate data & metrics into scalable BI datasets

Responsibilities

Design and build executive dashboards in Power BI that provide clear performance insights for leadership.
Implement dynamic forecasting and run-rate projections.
Integrate financial assumptions to support profit and margin visibility.
Develop clear KPI summaries, variance views, and trend analysis.
Enable drill-down across company, business unit, and operational drivers.
Design and optimize Power BI semantic models.
Standardize KPI definitions and calculations.
Improve dataset performance and maintainability.
Consolidate and simplify existing BI models where appropriate.
Lead migration of existing BI datasets from SQL Server / Power BI Desktop to Microsoft Fabric.
Develop curated semantic models and KPI logic on top of the Lakehouse architecture.
Design business-ready views and metrics within the curated layer to support reporting and analytics.
Implement Dataflows, governed datasets, and scalable Power BI semantic models.
Collaborate closely with the Data Engineering team, leveraging Bronze / Silver layers to build trusted business metrics in the curated layer.
Ensure the Fabric environment supports scalable reporting, self-service analytics, and future AI capabilities.
Help establish best practices for BI development and data governance.
Contribute to a scalable analytics environment supporting executive reporting, operational dashboards, and advanced analytics.
Ensure datasets are documented, reusable, and optimized for performance.