Power Platform & Automation Solutions Consultant

Guidehouse Inc.; St. Louis (MO); On-site; USD 92,000 - 153,000; Full time

Benefits offered by this job

Medical, Rx, Dental & Vision Insurance

Personal and Family Sick Time &Company

Discretionary variable incentive bonus

Parental Leave and Adoption Assistance

401(k) Retirement Plan

Basic Life & Supplemental Life

Health Savings Account, Dental/Vision&

Dependent Care Flexible Spending

Short-Term & Long-Term Disability

Student Loan PayDown

Tui

Job summary

Guidehouse Inc. seeks a Power Platform Developer and Innovation Specialist to support a federal DOW client’s front-office modernization.

Design and build Power Automate workflows, Canvas and Model-driven apps, and AI-enabled capabilities within the Microsoft 365 ecosystem to deliver value in an agile cadence. Collaborate with the Business Systems Analyst to translate requirements into sprint-ready tasks while ensuring compliance with the DON’s approved tech environment, security, accreditation,

Qualifications

• Minimum of SIX (6) years of professional experience.
• Minimum of TWO (2) years delivering Power Platform solutions.
• Education: Bachelor's degree required or equivalent experience.
• Experience building Canvas Apps and Power Automate end-to-end, including intake, routing, and approvals.
• Experience configuring SharePoint as a structured document repository with metadata, libraries and permissions.

Responsibilities

• Build and maintain Power Automate workflows for inbox-driven task identification, action item routing, multi-step approvals, and exception handling.
• Automate document detection, ingestion, and periodic summarization into SharePoint for centralized knowledge management.
• Design and configure SharePoint as a centralized repository for documents and records.
• Build intake tools using Microsoft Forms or Canvas Apps for standardized capture and routing of meeting requests and action items.
• Design and build Canvas Apps with guided workflows and embedded automation for non-technical executives and front-office users.
• Connect Canvas Apps to Dataverse, SharePoint, and third-party data sources via connectors and custom APIs.
• Implement RBAC, row-level security, and table permissions.
• Configure AI Builder, Copilot Studio, or Azure AI for predictive task modeling and document summarization.
• Support integration of Power BI dashboards for executive visibility into metrics and sprint progress.
• Modernize front-office processes through targeted automation.
• Participate in sprint planning, backlog grooming, daily standups, and retrospectives.

Skills

Power Platform

Agile delivery

Requirements gathering

Stakeholder collaboration

UI/UX for executives

Education

Bachelor's degree

Tools

Power Automate

Canvas Apps

Model Driven Apps

SharePoint

Dataverse

Power BI

Microsoft Forms

Job description

Job Family :

SAAS/PAAS/Cloud Consulting

Travel Required :

Up to 10%

Clearance Required :

Active Secret

What You Will Do:

We are seeking a Power Platform Developer and an Innovation Specialist to support a front-office modernization effort for a federal DOW client. This role is responsible for designing and building the document management architecture, automated workflows, AI agent configurations, and data capabilities that span a multi-milestone delivery program. The position operates within a lean, agile sprint-based team and requires the ability to translate executive workflows into actionable, testable increments of capability across the Microsoft 365 and Power Platform ecosystem.

Responsibilities:

• Build and maintain Power Automate workflows for inbox-driven task identification, action item routing, multi-step approvals, and exception handling
• Automate document detection, ingestion, and periodic summarization into SharePoint to support centralized knowledge management
• Design and configure SharePoint as a centralized repository for document retention, meeting records, briefs, and institutional knowledge
• Build Microsoft Forms-based or Canvas App-based intake tools for standardized capture and routing of meeting requests and action items
• Design and build Canvas Apps providing tailored, intuitive user experiences with guided workflows and embedded automation in lieu of standard form-based tools
• Connect Canvas Apps to Dataverse, SharePoint, and third-party data sources via connectors and custom APIs
• Implement RBAC, row-level security, and table permissions
• Configure AI Builder, Copilot Studio, or Azure AI capabilities to support predictive task modeling, document summarization, and AI-assisted meeting documentation
• Support integration of Power BI dashboards for executive visibility into operational metrics and sprint progress
• Modernize manual, email-based, and document-driven front office processes through targeted automation
• Participate in sprint planning, backlog grooming, daily standups, milestone reviews, and retrospectives within an agile delivery cadence
• Collaborate with the Business Systems Analyst to translate business requirements and current-state process documentation into sprint-ready development tasks
• Ensure all solutions operate within the DON's approved technology environment, minimizing security, accreditation, and sustainment risk

What You Will Need:

• Minimum of SIX (6) years of professional experience
• Minimum of TWO (2) years delivering Power Platform solutions
• Clearance: Active and Maintained SECRET Clearance
• Selected Candidate must be able to commute to the client site up to 4x/week
• Citizenship: US Citizenship is contractually required
• Education: Bachelor's degree required or equivalent experience
• Hands-on experience building Canvas Apps, Model Driven Apps, and Power Automate workflows end-to-end, including intake, routing, approval, and notification patterns
• Experience configuring SharePoint as a structured document repository, including metadata, libraries, and permissions
• Familiarity with Microsoft Forms and its integration with Power Automate for intake and routing scenarios
• Ability to build polished, production-ready UI/UX for non-technical executives and front office users
• Ability to work effectively within an agile sprint model, including participation in planning, reviews, and iterative delivery
• Ability to collaborate directly with stakeholders, including requirements gathering, demos, and milestone reviews

What Would Be Nice To Have:

• Prior federal or DOW environment experience
• Experience with AI Builder, Copilot Studio, or Azure AI for document summarization, classification, or task prediction
• Power BI dashboard development and integration with Power Platform data sources
• Familiarity with Microsoft 365 G5 licensing and available capabilities
• Azure infrastructure or architecture knowledge
• Application Lifecycle Management (ALM) and environment management
• Azure DevOps and Git source control
• API and third-party integration experience

The annual salary range for this position is $92,000.00-$153,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.

What We Offer :

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

Benefits include:

• Medical, Rx, Dental & Vision Insurance
• Personal and Family Sick Time & Company Paid Holidays
• Position may be eligible for a discretionary variable incentive bonus
• Parental Leave and Adoption Assistance
• 401(k) Retirement Plan
• Basic Life & Supplemental Life
• Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
• Short-Term & Long-Term Disability
• Student Loan PayDown
• Tui