Power Apps Lead/ Architect

Immediate

We are looking for an experienced Microsoft Power Platform Architect/ Lead who can lead solution architecture and design while remaining actively involved in hands-on development.

The candidate will be responsible for designing scalable, secure, maintainable, and high-performing business solutions using Microsoft Power Platform. The role requires solid expertise in Canvas Apps, Model-Driven Apps, Power Automate, Dataverse, AI Builder, and SQL Server.

The architect is expected to spend approximately 60% of their time on hands-on technical activities , including solution design, application development, workflow automation, integrations, prototyping, code reviews, troubleshooting, and performance optimization. The remaining time will focus on architecture, technical leadership, stakeholder discussions, and governance.

Experience with Microsoft Copilot Studio is an added advantage, particularly for projects involving AI-powered agents and business process automation.

Solution Architecture and Technical Design

Design end-to-end Power Platform solutions based on business and technical requirements.

Define application architecture, data models, integration patterns, security, and deployment strategies.

Design scalable solutions using Dataverse, SQL Server, and other enterprise data sources.

Identify technical risks, dependencies, performance bottlenecks, and opportunities for optimization.

Ensure solutions align with enterprise architecture, security, and governance standards.

Hands-on Power Apps Development

Implement application logic, validations, navigation, and role-based experiences.

Optimize application performance, delegation, data retrieval, and user experience.

Build proof of concepts and technical prototypes to validate architecture decisions.

Design and develop cloud flows for business process automation and system integration.

Integrate Power Automate with Power Apps, Dataverse, SQL Server, SharePoint, Microsoft 365, and external systems.

Implement reusable automation patterns, child flows, and appropriate error-handling mechanisms.

Troubleshoot flow failures, connection issues, performance problems, and integration errors.

Dataverse Architecture and Data Modeling

Design Dataverse data models, tables, columns,



relationships, and business rules.

Define appropriate security roles, teams, business units, and record-level access.

Optimize data structures and relationships for performance and maintainability.

Implement auditing, data validation, and appropriate data management practices.

Design integration patterns between Dataverse, SQL Server, and other enterprise systems.

Evaluate data storage and licensing implications when selecting architectural approaches.

Design and implement solutions using Microsoft AI Builder capabilities.

Integrate AI Builder with Power Apps, Power Automate, and Dataverse.

Design automated document processing and data extraction workflows.

SQL Server and Enterprise Integration

Design integrations between Power Platform applications and SQL Server.

Work with tables, views, stored procedures, queries, and relational data models.

Optimize SQL queries and data access patterns for application performance.

Design secure and maintainable integration patterns between Power Platform and enterprise systems.

Troubleshoot data connectivity, performance, and integration issues.

Microsoft Copilot Studio – Added Advantage

Design and develop AI-powered agents using Microsoft Copilot Studio.

Integrate agents with Power Automate, Dataverse, SharePoint, and enterprise applications.

Apply appropriate security , data-access, testing, and responsible AI practices.

ALM, Governance, and DevOps

Design solution packaging and deployment strategies using managed and unmanaged solutions.

Define development standards, version control practices, and CI/CD approaches using Azure DevOps or GitHub where appropriate .

Establish governance practices covering environments, connectors, DLP policies, security, and monitoring.

Guide teams on release management, testing, documentation, and production readiness.

Lead architecture reviews, design discussions,



and technical decision-making.

Work with project managers, business analysts, QA teams, and enterprise architects.

Support effort estimation, technical feasibility assessments, and delivery planning.

Communicate architectural decisions, risks, and recommendations clearly to technical and non-technical stakeholders.

Candidates Must Demonstrate Strong Practical Experience In

Microsoft Power Apps – Canvas Apps.

Microsoft Power Apps – Model-Driven Apps.

Microsoft Power Automate cloud flows.

Microsoft Dataverse architecture and data modeling .

AI Builder and its integration with Power Platform.

SQL Server, relational data modeling , and query optimization.

Power Platform solutions, ALM, and environment management.

Security, access control, integrations, troubleshooting, and performance optimization.

End-to-end solution architecture and hands-on implementation.

Microsoft Copilot Studio and AI agent development.

REST APIs, custom connectors, and Microsoft Graph API.

Power Platform CLI and PowerShell.

Azure DevOps or GitHub-based CI/CD.

Power Pages and Power Apps Component Framework (PCF).

Enterprise Power Platform governance and Center of Excellence practices.

Experience and Qualifications

8–12 years of overall software development or solution delivery experience preferred.

Strong experience designing and implementing enterprise Power Platform solutions.

Proven experience across Canvas Apps, Model-Driven Apps, Power Automate, and Dataverse.

Practical experience integrating SQL Server and implementing AI Builder use cases.

Demonstrated ability to make architecture decisions and implement them hands-on.

Experience leading technical teams, conducting design reviews, and mentoring developers.

A BOUT SONATA SOFTWARE

Sonata Software is an AI-first modernization engineering company that helps enterprises transform legacy systems into intelligent, scalable business platforms. AI platform, Sonata delivers AI-led modernization across cloud, data, AI, Dynamics, test automation, and managed services. With deep partnerships across Microsoft, AWS, Salesforce, and Snowflake, Sonata helps Fortune 500 enterprises accelerate innovation, improve efficiency, and drive sustainable growth.

📌 Aws DevOps Architect (Bengaluru)
🏢 Sonata Software
📍 Bengaluru