About the Role 

We’re looking for an experienced Power Platform professional with strong technical expertise in Power Apps, Power Automate, Power BI, SQL, and related Microsoft technologies to support the implementation of enterprise level solutions. This role is ideal for someone who understands how to translate business requirements into practical, scalable solutions and can work collaboratively within a cross-functional team. 

As a Power Apps & Power BI Technical Lead, you will play a key role in designing and implementing components of the solution architecture, providing technical guidance to the team, and ensuring that solutions align with best practices and client needs. This is an intermediate role working with the project manager and solution architect—from discovery and early design discussions through to deployment and support. 

You’ll collaborate closely with architects, analysts, developers, and delivery managers to help bring complex, data-driven solutions to life across diverse industries. 

The Opportunity            

You will report to the VP of Project Delivery and spend 80–90% of your time implementing solutions, building apps, portals and reports, and leading technical delivery across client-facing projects while also guiding developers, collaborating with business analysts, and participating in pre-sales or client workshops as needed. 

What You'll Do

• Design & Build: Help design and implement solutions using Power Apps (Canvas + Model-Driven), Power Automate, Power BI, Microsoft Fabric, Power Pages, Dataverse, and SQL. 
• Elevate Reporting: Develop effective end-to-end BI solutions that adhere to best practices, create rich Power BI dashboards with DAX, Power Query, and custom visuals. 
• Contribute to Projects: Participate in providing inputs to the project plans, estimates and scope for sales proposals and statements of work. 
• Engage with Clients: Assist with requirements gathering and documentation, hold workshops with customers, and translate business needs into scalable solutions. 
• Automate Smarter: Leverage AI Builder, Copilot, and Azure tools to deliver forward-thinking automation 
• Contribute to Growth: Participate in pre-sales, solution design, and tailoring demo creation. 

Tech Stack & Environment

• Core Tools: Power Apps, Power Automate, Power Pages, Power BI, Microsoft Fabric, Dataverse, SQL 
• Integration: Azure Data Factory, Azure Analysis Services, Logic Apps, SSIS, Azure Synapse 

Nice to have:  

• AI/Automation: AI Builder, Copilot, OpenAI APIs, and emerging tools within the Microsoft ecosystem

What You Bring 

• 5+ years of hands-on development experience with Microsoft Power Platform and Power BI. 
• Deep experience with Power Apps: 
• Canvas apps – designing and developing responsive, role-based apps with intuitive user interfaces using formulas, custom connectors, and collections. Experience with offline capabilities, security roles, and embedding in Teams/SharePoint environments. 
• Model-Driven apps – building scalable, data-centric applications using Dataverse, complex business process flows, custom views/forms, calculated fields, and security roles. 
• Proficiency in Power Pages for designing secure, user-friendly external portals including authentication, design customization, and integration with Dataverse or APIs. 
• Strong practical experience in Power Automate – building complex flows, handling connectors (standard and premium), error handling, and automation of approvals and business logic. 
• Expertise in Power BI and Microsoft Fabric including DAX, Power Query, custom visuals, and performance optimization. 
• Proficiency in SQL. 
• Familiarity with secure data integration and automation using Azure Logic Apps, Azure Data Factory, and REST APIs. 
• Demonstrates ability to be an effective part of a team/project while delivering high-quality, scalable solutions.
• Excellent communication skills with the ability to interact confidently with business stakeholders and executives. 

Why Whitecap? 

We have been developing leading platform software solutions for over 27 years and have helped an impressive array of clients digitize and modernize their operations. That kind of success does not happen by accident. One of the reasons clients choose us is because of our people. We have built a team of skilled, passionate, and diverse people. We are incredibly proud of our team and the culture we have built together. 

At Whitecap Canada Inc., we value innovation, teamwork, and a commitment to excellence. As a Microsoft Solution Technical Lead, you will have the opportunity to work on exciting projects, collaborate with a talented team, and contribute to the development of cutting-edge systems. 

Here is what you can expect as a member of the Whitecap family: 

• A diverse client portfolio with exciting projects. 
• An easy-going, fun, hybrid working environment. 
• Supportive, family-oriented, no-burnout culture. 
• Open, honest, and two-way communication with management. 
• A comprehensive benefits package, including mental health support services. 
• A competitive salary, bonuses, profit sharing and extra vacation 
• Social activities like company cruises, holiday parties, lunches, games, contests, etc. 
• All the coffee you need to power you through the day while in the office. 

As part of our hybrid working structure, we expect our team members to work from the office two days a week on Tuesdays and Thursdays. Our Toronto office is located at 200 Yorkland Blvd., with easy access from the 401, DVP, and 404. The building also offers a free shuttle service to Fairview Mall and Don Mills Subway Station throughout the day, making your commute even easier. The area has a variety of nearby amenities, including cafés, lunch options, and green spaces for breaks. 

Join us and be part of a dynamic organization at the forefront of technological advancements. 

Eligibility 

Applicants must be Canadian Citizens or Permanent Residents legally entitled to work in Canada.