Architect

Job Title- Sr. Power Apps Lead/ Architect
Location- Bangalore / Hyderabad / Chennai
Exp:8-12Yrs
Notice Period: 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 strong 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.
Key Responsibilities
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.
Evaluate Canvas Apps versus Model-Driven Apps and recommend the appropriate approach .
Design scalable solutions using Dataverse, SQL Server, and other enterprise data sources.
Establish reusable components, development standards, and architectural best practices.
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
Design and develop Canvas Apps using Power Fx , responsive layouts, reusable components, and advanced controls.
Build Model-Driven Apps using Dataverse tables, forms, views, dashboards, business rules, and business process flows.
Implement application logic, validations, navigation, and role-based experiences.
Optimize application performance, delegation, data retrieval, and user experience.
Troubleshoot complex application issues and provide technical guidance to developers.
Build proof of concepts and technical prototypes to validate architecture decisions.
Power Automate and Workflow Automation
Design and develop cloud flows for business process automation and system integration.
Implement automated, instant, and scheduled flows, approvals, notifications, and multi-step workflows.
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.
Define best practices for flow design, reliability, maintainability, and operational support.
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.
AI Builder and AI-powered Solutions
Design and implement solutions using Microsoft AI Builder capabilities.
Evaluate suitable AI Builder models for document processing, information extraction, classification, and prediction use cases.
Integrate AI Builder with Power Apps, Power Automate, and Dataverse.
Design automated document processing and data extraction workflows.
Evaluate model accuracy, validation requirements, exception handling, and human review processes.
Assess AI feasibility, consumption considerations, and expected business value.
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.
Understand connector requirements, authentication, permissions, and gateway considerations where applicable.
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.
Configure knowledge sources, topics, actions, and generative answers.
Integrate agents with Power Automate, Dataverse, SharePoint, and enterprise applications.
Evaluate agent use cases and identify opportunities for AI-led business process automation.
Apply appropriate security , data-access, testing, and responsible AI practices.
ALM, Governance, and DevOps
Establish application lifecycle management practices across development, test, and production environments.
Design solution packaging and deployment strategies using managed and unmanaged solutions.
Configure environment variables and connection references.
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.
Technical Leadership and Stakeholder Management
Engage with business stakeholders to understand requirements and translate them into technical solutions.
Lead architecture reviews, design discussions, and technical decision-making.
Mentor developers and conduct design and code reviews.
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.
Mandatory Technical Skills
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 .
Power Fx and application logic.
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.
Good-to-Have Skills
Microsoft Copilot Studio and AI agent development.
Azure services, Azure Functions, and Azure Logic Apps.
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).
Generative AI, Azure AI Foundry, and enterprise AI integration patterns.
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.
Strong communication , problem-solving, and stakeholder-management skills.
A BOUT SONATA SOFTWARE
Sonata Software is an AI-first modernization engineering company that helps enterprises transform legacy systems into intelligent, scalable business platforms. Powered by its Platformation ™ framework and Harmoni.AI platform, Sonata delivers AI-led modernization across cloud, data, AI, Dynamics, test automation, and managed services. Headquartered in Bengaluru, India, Sonata has more than $1.2 billion in revenue and 6,400+ AI engineers supporting global delivery across regions including the US, UK, India, Malaysia, Mexico, Australia, DACH, and the Nordics. With deep partnerships across Microsoft, AWS, Salesforce, and Snowflake, Sonata helps Fortune 500 enterprises accelerate innovation, improve efficiency, and drive sustainable growth.
For more information, please visit www.sonata-software.com

Skills
REST API, Git, AWS, Azure, CI/CD, SQL, Snowflake, Automation Testing, Data Modeling, Generative AI

Work arrangement
No