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 contemporary 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.
- Microsoft PL-300 (Power BI Data Analyst) certification.

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
- Microsoft Copilot
- Visual Studio Code

Soft Skills

- Excellent communication skills
- Strong analytical and problem-solving abilities
- Self-starter with a proactive mindset
- Strong documentation skills
- Excellent time management
- Attention to detail
- Ability to collaborate with cross-functional teams

What You'll Bring

- Expertise in building enterprise-grade analytics solutions.
- Strong experience delivering scalable Power Platform applications.
- Ability to translate business needs into impactful reporting solutions.
- Passion for automation, innovation, and continuous improvement.
- Experience working in fast-paced, collaborative enterprise environments.

Applicant Notices & Disclaimers

- For information on benefits, equal opportunity employment, and location-specific applicant notices, click here

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.

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