Role : Business Intelligence (BI) Developer (Power Platform & Power BI)

Location: Toronto/Mississauga, ON - Hybrid: 2 days in office

Duration: 12 months

Extension: Possible based on performance and business needs

Conversion: Possible based on performance and business needs

Position Overview

We are seeking an experienced Business Intelligence Developer with deep expertise in the Microsoft Power Platform to design, develop, and support enterprise reporting and analytics solutions. The successful candidate will build scalable Power BI dashboards, Power Apps, and Power Automate workflows, enabling data-driven decision-making while working with large, complex datasets and modern AI-assisted development tools.

About the Role

The Business Intelligence Developer will be responsible for designing and delivering enterprise reporting, dashboards, workflow automation, and data visualization solutions using the Microsoft Power Platform. This role partners with technical teams and business stakeholders to transform complex datasets into meaningful insights that support operational excellence and strategic decision-making.

The ideal candidate has extensive experience developing Power BI solutions, Power Apps, and Power Automate workflows while working with large-scale datasets and up-to-date AI development tools.

Key Responsibilities

Design, develop, deploy, and maintain enterprise Power BI dashboards and applications.

Build visually engaging dashboards that provide actionable business insights.





Develop Power Automate workflows to distribute reports and dashboards through email and Microsoft Teams.

Create Power Apps to streamline business processes and improve data collection.

Utilize AI-assisted development tools such as Microsoft Copilot and Visual Studio Code to improve development efficiency.

Design scalable data models using multiple structured and unstructured data sources.

Develop reusable datasets and reporting frameworks for enterprise-wide analytics.

Work with extremely large datasets (100M+ records) while optimizing performance.

Implement Row-Level Security (RLS) and secure reporting solutions using Active Directory groups.

Collaborate with business stakeholders to define KPIs, KRIs, and reporting requirements.

Translate business requirements into technical specifications.

Perform testing, validation, troubleshooting, and production support.

Create and maintain technical documentation and reporting logic.

Recommend improvements to existing reporting, automation, and data management processes.

Required Qualifications

10+ years of experience developing and supporting:

Power BI

Power Apps

Power Automate





2+ years of experience using AI-assisted development tools such as Microsoft Copilot and Visual Studio Code.

Advanced experience with:

Complex DAX

Power Query

SQL

Power BI Dashboard and App development

Experience working with datasets exceeding 100 million records.

Experience working with multiple data formats including:

SQL

JSON

XML

Excel

CSV

SharePoint

Strong understanding of:

Data warehousing

Data modeling

Data optimization

Performance tuning

Preferred Qualifications

Experience within Information Security or Identity & Access Management (IAM).

Banking or financial services experience.

Required Skills

Technical Skills

Microsoft Power BI

Power Apps

Power Automate

DAX

Power Query

SQL

Data Modeling

Data Warehousing

Large Dataset Optimization

JSON

XML

Excel

CSV

SharePoint

Soft Skills

Strong analytical and problem-solving abilities

Self-starter with a proactive mindset

Ability to collaborate with cross-functional teams

What You'll Bring

Expertise in building enterprise-grade analytics solutions.

Ability to translate business needs into impactful reporting solutions.

Passion for automation, innovation, and continuous improvement.

Experience working in fast-paced, collaborative enterprise environments.

At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. The pay rate for this position is C$65.00/hr.

#J-18808-Ljbffr

📌 Business Intelligence (BI) Developer (Power Platform & Power BI)
🏢 SPECTRAFORCE
📍 Ontario