Power Platform Developer

FP Inc.

Toronto, ON, Canada
Contract
Hybrid
C$80 - C$90
Microsoft Power PlatformMicrosoft SQL ServerAPI Integration

Role Overview

We are seeking a skilled Power Platform Developer for a contract position in Toronto. This role focuses on designing, developing, and maintaining a suite of business applications and automated workflows. The ideal candidate will bridge the gap between business requirements and technical solutions, utilizing the full Microsoft Power Suite, SQL Server, and custom API integrations to drive organizational efficiency.

Key Responsibilities

  • Application Development: Design and customize canvas and model-driven Power Apps, ensuring user-friendly interfaces and robust role-based access control (RBAC).
  • Workflow Automation: Build and optimize complex Power Automate workflows integrated with Dataverse, SharePoint, and external APIs.
  • Data Management & SQL: Manage Dataverse data models and perform advanced SQL development, including stored procedures and performance tuning in MS SQL Server.
  • Integration Services: Develop custom API connectors (REST/JSON) to ensure secure data exchange between the Power Platform and third-party systems.
  • Solution Architecture: Collaborate with stakeholders to document technical architectures and conduct end-to-end testing and debugging.

What program/ technology/software knowledge is essential for this role?

  • Microsoft Power Platform (Power Apps, Power Automate, Dataverse)
  • Microsoft SQL Server
  • API Integration (REST APIs, Custom Connectors)
  • Microsoft 365, SharePoint, and Azure Services
  • General Development Tools (Agile methodologies, Azure DevOps or other CI/CD tools)

Must-have Skills:

  • Proven experience as a Power Platform Developer, with expertise in Power Apps, Power Automate, and Dataverse
  • Strong understanding of Microsoft Power Platform architecture and its components
  • Experience in creating and managing custom API connectors for integration with external systems
  • Proficiency in Power Apps formulas, Power FX, and Canvas/Model-driven app development,
  • Hands-on experience with Dataverse, including data modeling, relationship and business rules
  • Knowledge of Power Automate flows, including multi-step workflows, approvals, and error handling
  • Proficiency in writing and optimizing SQL queries stored procedures, and functions in Microsoft SQL Server
  • Experience with query perfomance tuning and troubleshooting in SQL Server environments
  • Familiarity with Azure services, SharePoint, and Microsoft 365 integrations
  • Strong understanding of REST APIs, JSON, and OAuth authentication
  • Experience with Power BI integration for reporting and dashboards is a plus
  • Excellent problem-solving skills and the ability to work collaboratively in a team environment
  • Strong communication skills to interact with business stakeholders and technical terms

Nice-to-have Skills:

  • Microsoft Power Platform certifications (PL-100, PL-200, PL-400, PL-600)
  • Experience with Agile methodologies
  • Knowledge of low-code/no-code principles
  • Familiarity with CI/CD tools (e.g. GitHub Actions)

Soft Skills:

  • Strong communication and collaboration
  • Analytical and problem-solving mindset
  • Adaptability and willingness to learn
  • Attention to detail