> Markdown version of [/jobs/ext/1205366-microsoft-copilot-studio-and-power-automate-lead-solution-builder](https://www.wearedevelopers.com/jobs/ext/1205366-microsoft-copilot-studio-and-power-automate-lead-solution-builder). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Microsoft Copilot Studio and Power Automate Lead Solution Builder - **Company:** Wga Llc. - **Location:** Los Angeles, CA, United States (Remote available) - **Experience:** Expert - **Salary:** $166,400.0 - $176,800.0 - **Contract:** Temporary contract - **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, ARM Architecture, Unit Testing, Software as a Service, Information Systems, Databases, Data as a Services, Enterprise Content Management, Routing, Screenshots, Software Engineering, Enterprise Data Management, Smartsheet, Data Logging, Microsoft Power Automate, Large Language Models, Snowflake, Kubernetes, Information Technology, Integration Frameworks, Airtable - **Published:** July 8, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=8a62bea2df13be55 ## About the Role * Bachelor's degree required in a relevant discipline, including but not limited to Computer Science, Software Engineering, Information Systems, Data Science, Artificial Intelligence, Engineering, or a closely related technical field * Strong academic record from a recognized institution; relevant Microsoft or platform certifications a plus Experience * 10 years of overall professional experience, including delivery with a tier-one consulting firm such as BCG, Accenture, or Deloitte * Demonstrated hands-on delivery in Microsoft Copilot Studio and Microsoft Power Automate, including agents or flows deployed to production * Experience integrating across enterprise data platforms and SaaS systems, with practical exposure to data contracts, API and connector patterns, and least-privilege access * Track record of client-facing delivery under structured acceptance criteria, change control, and tier-one consulting quality standards Required expert skills * Expert-level skill building Microsoft Power Automate forms with elaborate functionality, including forms with 100+ selections * Building embedded Copilot AI agents within Power Automate forms that guide users through completing complex, multi-selection forms * Building MCP Copilot-to-Cortex Snowflake agents to search and fetch data * Reading and writing form data to Snowflake via Microsoft Dataverse * Troubleshooting complex shopping-cart functionality within Power Automate forms Technical fluency * Strong command of Copilot Studio topics, actions, and knowledge sources, and of Power Automate cloud flows, connectors, expressions, and error handling * Working knowledge of Snowflake or comparable cloud data services, and familiarity with Model Context Protocol (MCP) or similar agent-to-data integration patterns * Comfort designing idempotent, guarded write logic and reliable exception handling across integrated systems * Familiarity with the broader agentic AI landscape, orchestration frameworks, and enterprise LLM deployment considerations Communication and execution * Clear written and verbal communication, including the ability to explain agent behavior and integration design to business and technical audiences * Proven ability to deliver on a pipelined schedule with iterative feedback, tight timelines, and high quality standards * Demonstrated ownership, follow-through, and the ability to manage multiple build workstreams concurrently Engagement Details * Hourly Rate: $80-$85/hour * Duration: 5 Months. * Work Location: Los Angeles, CA; hybrid, with on-site presence at the client's Los Angeles area location as required by the build and testing cadence * Travel: Minimal; local client-site presence as needed * Authorization: Must be based in the United States and authorized to work in the United States ## Description WGA Advisors is engaging a Lead Solution Builder to hands-on build, test, train, and deploy production AI Agents on Microsoft Copilot Studio and Microsoft Power Automate for a large enterprise content operations client. This is a high-impact execution role responsible for turning accepted, build-ready requirements into configured, tested, and deployed agents that run real operational workflows with human oversight. The Lead Solution Builder works alongside a second build pod, engagement leadership, and the client's data and platform teams to deliver multiple demand-intake and content-servicing agents on a pipelined schedule. The role demands strong platform fluency in Copilot Studio and Power Automate, disciplined attention to data contracts and idempotent write logic, and the ability to deliver to the quality and governance standards of top-tier consulting engagements. This is a temporary project-based engagement running through mid-November 2026, structured around a build, test, deploy, and go-live support sequence. Strong potential for extension based on performance and continued client demand across WGA's pipeline. Core Responsibilities Agent build and configuration * Configure conversational and workflow AI Agents in Microsoft Copilot Studio against accepted build-ready requirements, including intake classification, field and format validation, controlled vocabularies, and routing logic * Build supporting process flows in Microsoft Power Automate that move a request from capture through validation, routing, and write-back, including retries, error handling, and idempotent writes so a re-run does not duplicate or overwrite records * Parameterize flows and agents across development, test, and production environments, with least-privilege service credentials and secure secret management * Build guarded, no-overwrite data transfers between SaaS systems (for example, Airtable, Smartsheet, and Data Shuttle), confirming the destination before write and blocking unwatched overwrite conditions for human review * Build elaborate Microsoft Power Automate forms with advanced logic, including embedded Copilot AI agents that guide users through completing forms with 100+ selections, and complex shopping-cart functionality across the form experience * Read and write form data to Snowflake through Microsoft Dataverse, and fetch and search source data through MCP Copilot-to-Cortex Snowflake agents Integration and data services * Integrate agent read and write access to enterprise databases through cloud data services, honoring defined read and write data contracts and least-privilege scopes * Implement integrations from Copilot Studio to Snowflake Cortex data services over a Model Context Protocol (MCP) integration, including invocation pattern, error handling, and retry and idempotency behavior * Collaborate with the client's Snowflake and platform teams to align on field-level definitions, formats, source-of-truth references, and credential handling * Build client-portal and system lookups, automated prior-delivery checks, and title-list build-out logic that surface results for confirmation before updates are committed Human-in-the-loop, logging, and controls * Implement review, approval, and escalation points so judgment stays with named human roles while the agent handles the repeatable work, defining who is notified, what they see, and the actions available at each queue * Configure per-agent logging and audit trails that record each decision, the data read and written, human actions taken, and any exception path, sufficient for acceptance testing, operational review, and downstream governance Test, deploy, and stabilize * Perform unit and integration testing of each configured behavior in isolation and end to end across intake, validation, routing, integration, and write-back paths against representative data * Facilitate User Acceptance Testing (UAT) with client Subject Matter Experts against agreed acceptance criteria, recording outcomes, defects, and sign-off decisions * Triage defects by severity, resolve them within the platform configuration, and re-test to closure, escalating dependencies that fall outside the configuration scope * Deploy agents to production within client change controls, run production smoke tests, and confirm go-live acceptance * Support the two-week go-live and hypercare window, monitoring logs, queues, and exception rates and stabilizing operations as real usage exposes edge cases Training and knowledge transfer * Author concise per-agent end-user usage guides and produce short narrated overview videos using screen capture of the deployed agent * Transition deployed agents, integration design, and test results to client ownership with clean documentation and repeatable build patterns ## Related Videos - [Creating a routing app with Google Maps API from scratch](https://www.wearedevelopers.com/videos/831-creating-a-routing-app-with-google-maps-api-from-scratch) - [The Vonage Trivia Voyage: Quiz Your Way to the Top!](https://www.wearedevelopers.com/videos/761-the-vonage-trivia-voyage-quiz-your-way-to-the-top) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [Agentic employees in world's most downloaded FinTech app](https://www.wearedevelopers.com/videos/100123-agentic-employees-in-world-s-most-downloaded-fintech-app) - [A Technical Introduction to Bitcoin's 2nd Layer- The Lightning Network](https://www.wearedevelopers.com/videos/15-a-technical-introduction-to-bitcoin-s-2nd-layer-the-lightning-network) - [Boost your coding productivity with Github Copilot Agent](https://www.wearedevelopers.com/videos/1542-boost-your-coding-productivity-with-github-copilot-agent) ## Related Articles - [GitHub Copilot: Beyond the Basics – 10 Ways to Elevate Your Coding](https://www.wearedevelopers.com/magazine/524-github-copilot-beyond-the-basics-10-ways-to-elevate-your-coding) - [Liuba Gonta and Yuliya Khadasevic - GitHub Copilot Beyond the Basics - 10 Ways to Elevate Your Coding](https://www.wearedevelopers.com/magazine/490-liuba-gonta-and-yuliya-khadasevic-github-copilot-beyond-the-basics-10-ways-to-elevate-your-coding) - [What is Agentic Programming and Why Should Developers Care?](https://www.wearedevelopers.com/magazine/625-what-is-agentic-programming-and-why-should-developers-care) - [13 AI Tools You Have to Try](https://www.wearedevelopers.com/magazine/219-13-ai-tools-you-have-to-try) - [From Prototype to Production: Build AI Agents with This Free 4-Course Learning Path](https://www.wearedevelopers.com/magazine/655-from-prototype-to-production-build-ai-agents-with-this-free-4-course-learning-path) - [13 AI Tools for Developers](https://www.wearedevelopers.com/magazine/302-13-ai-tools-for-developers)