Senior BI Developer – Executive Analytics & Fabric Platform

Range; Toronto; On-site; CAD 110,000 - 150,000; Full time

Job summary

Range Group in Toronto is seeking an experienced Senior BI Developer to modernize our analytics platform and deliver executive reporting. You will lead the migration from legacy SQL Server and Power BI Desktop to a Microsoft Fabric Lakehouse, building curated datasets and KPI models that power leadership decisions.

Working with the Analytics Senior Director, you will translate business metrics into scalable Fabric-based models, support AI-driven analytics, and ensure the platform supports

Qualifications

• Strong Power BI development experience with data modeling and performance optimization.
• Advanced SQL development and experience building executive KPI dashboards.
• Experience designing Power BI semantic models, not just visuals.
• Hands-on with forecasting or time intelligence models and fabric/azure platforms.

Responsibilities

• Design and build executive dashboards in Power BI for leadership insights.
• Implement dynamic forecasting and run-rate projections.
• Integrate financial assumptions to support profit and margin visibility.
• Develop KPI summaries, variance views, and trend analysis.
• Enable drill-down across company, business unit, and operational drivers.
• Lead migration of BI datasets to Fabric and develop curated semantic models.

Skills

Power BI

SQL

KPI dashboards

DAX

Semantic modeling

Forecasting

Fabric / Azure

Lakehouse

Data governance

Tools

Microsoft Fabric

Azure data services

Job description

At Range Group we believe in the power of the professional travel advisor. We represent over $4.5 billion in annual travel sales. All our investments stem from a common thesis, that travel advisors add real value to a trip. Travel advisors when equipped with technology and 24/7 support are irreplaceable. Equally important is our philanthropy. Range Foundation channels 10% of group profits to social impact. From exploration grants, improved access to education, new discoveries on sea and land, cultural infrastructure, and helping our global neighbors in times of need - we are investing to build a better future.

Role Brief

We are seeking an experiencedSenior BI Developer to help modernize our analytics platform while building executive reporting used by senior leadership.

We are currently transforming our analytics environment, migrating legacy SQL Server and Power BI Desktop reporting into a Microsoft Fabric Lakehouse architecture to create a scalable and governed data platform.

This role combines executive dashboard development, forecasting analytics, and data platform modernization. The successful candidate will lead the migration of existing BI reporting into Fabric while developing curated datasets and KPI models that power executive reporting.

Working closely with the Senior Director of Analytics, this role sits at the intersection of business analytics and modern data platforms, translating business metrics into scalable Fabric-based semantic models that support executive decision-making and future AI-driven analytics capabilities.

Key Responsibilities

Executive Reporting & Forecasting

• 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

Semantic Modeling & BI Development

• Design andoptimizePower BI semantic models
• Standardize KPI definitions and calculations
• Improve dataset performance and maintainability
• Consolidate and simplify existing BI models where appropriate

Fabric Migration & Curated Layer Development

• 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

Analytics Platform Development

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

Required Skills & Experience

• 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

We are committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. If you require accommodation due to a disability at any stage of our hiring process, please advise us when completing your application.

We thank all candidates for their interest however only those selected for an interview will be contacted.