Principal Technical Consultant, Power Platform

Power Platform Technical Consultant (Principal Technical Consultant)

ERM is seeking a Power Platform Technical Consultant (Principal Technical Consultant) to join our growing team. As part of a new and dynamic group within ERM—a leading global environmental organization—you will collaborate closely with our Power Platform Team to design and deliver Microsoft solutions. The role will focus on developing Canvas Power Apps and creating Power BI reports that align with organizational standards.

• Design, develop, and implement Canvas and Model-Driven Power Apps to meet business and client needs.
• Build and manage Dataverse databases and ensure effective integration within the Power Platform.
• Create data models and visualizations in Power BI that provide actionable insights.
• Partner with stakeholders to gather requirements, assess business challenges, and deliver effective low‑code/no‑code solutions.
• Collaborate with UX Designers, data analysts, data scientists, and the Power Platform Lead to deliver comprehensive digital solutions.
• Develop and maintain workflows and automations using Power Automate, including Robotic Process Automation (RPA).
• Build conversational experiences with Power Virtual Agents and create external‑facing solutions with Power Pages/Portals.
• Test solutions against requirements, ensuring functionality and alignment with acceptance criteria.
• Troubleshoot, resolve, and continuously improve existing Power Platform solutions.
• Incorporate stakeholder feedback into development cycles and maintain clear communication on delivery progress.
• Provide input on project estimates and pipeline planning to support team and organizational growth.

• Bachelor’s degree in computer science or relevant Microsoft certification/accreditation.
• Minimum of 6‑8 years of industry experience.
• Practical experience with Power BI Desktop.
• Understanding of Power BI Service (report publishing and sharing).
• Basic proficiency in DAX (Data Analysis Expressions).
• Ability to connect Power BI to data sources such as Excel, SQL Server, and SharePoint.
• Skill in creating and customizing visuals, charts, and slicers.
• Knowledge of data modeling, including relationships and calculated columns/measures.
• Experience building dashboards and interactive reports.
• Familiarity with filters, slicers, and drill‑through features.
• Experience with data transformation using Power Query.
• Exposure to scheduled refreshes and Power BI Gateway (preferred).
• Demonstrated participation in real‑world Power BI projects (industry domain is flexible).
• Basic awareness of security and sharing features;
  Row‑Level Security knowledge is advantageous.
• Excellent English communication skills, both written and verbal.

Apply today and join a team that combines technology, sustainability, and purpose to create a better future.

Applications accepted through (2/20/26). The posting may be extended if the position remains unfilled.

The anticipated annual base pay for the Principal Technical Consultant, Power Platform position is $113,850–$139,150 (USD). Actual pay will depend on factors such as education, experience, skills, location, performance, and business needs. In some cases, pay may fall outside this range. This role may be eligible for bonus pay (casual and fixed term/flex force employees are not bonus eligible).

We offer a comprehensive benefits package, including paid time off, parental leave, medical, dental, vision, life, disability, AD&D insurance, 401(k) or RRSP/DPSP, and other applicable benefits to eligible employees.

Note: Bonuses, commissions, and other forms of additional compensation are not guaranteed and subject to the sole discretion of ERM and its policies and procedures.

As the largest global pure play sustainability consultancy, we partner with the world’s leading organizations, creating innovative solutions to sustainability challenges and unlocking commercial opportunities that meet the needs of today while preserving opportunity for future generations.

At ERM we know that creating a diverse, equitable and inclusive work environment is an essential part of making our company a great place to build a career.…