Senior/Mid Analytics Consultant (Power Platform)

Position: Senior/Mid Analytics Consultant

Location: Hyderabad/Bangalore/Chennai (Hybrid)

Employment Type: Full-time

Role Overview

We are seeking an experienced Analytics Consultant with a strong background in designing, developing, and delivering enterprise Dynamics and Power Platform-based BI and automation solutions. The ideal candidate will have hands-on expertise in Microsoft Dynamics, CoPilot Studio, Power Pages, Power Apps, Power Automate, Dataverse, SQL, and SharePoint , with exposure to Azure cloud services .

The consultant will be responsible for transforming business requirements into actionable insights, building automation frameworks, and enabling self-service analytics across business units.

Key Responsibilities

• Design, develop, and deploy end-to-end business solutions leveraging Microsoft Dynamics and CoPilot Studio for enhanced automation and intelligence.
• Develop, customize, and manage Power Pages , Power Apps , and Power Automate solutions integrated with SharePoint , Dataverse , and SQL .
• Build and maintain data models , ETL pipelines , and optimized SQL queries for data extraction and transformation.
• Implement automation workflows for approvals, notifications, and reporting using Power Automate and CoPilot Studio .
• Collaborate with business stakeholders and cross-functional teams to understand requirements and translate them into effective data-driven solutions.
• Ensure performance optimization, data accuracy, and visualization best practices in dashboards and reports.
• Manage deployment, data refreshes, and alert mechanisms for cloud-based BI and automation solutions.
• Conduct training and enablement sessions to promote self-service analytics and user adoption.

Required Skills & Experience

• 4+ years of experience in Analytics, BI development, or Consulting .
• Strong hands-on expertise in:
• Microsoft Dynamics 365 (CRM/ERP modules)
• CoPilot Studio
• Power Pages , Dataverse , SQL , and SharePoint
• Proven experience integrating Dynamics and Power Platform with Azure or other cloud ecosystems.
• Deep understanding of data modeling , ETL processes , and performance tuning .
• Strong analytical, problem-solving, and client communication skills.

Good-to-Have Skills

• Proficiency in Power BI and Power Platform (Power Apps, Power Automate) for business intelligence and process automation.
• Exposure to Microsoft CoPilot for workflow enhancements and AI-driven automation.
• Experience in Azure Data Services or Google BigQuery integrations.

Preferred Qualifications

• Microsoft Certifications such as PL-100 , PL-200 , PL-300 , or MB-910/MB-920 .
• Experience in retail , pharmaceutical , or insurance domains.
• Experience working in Agile or Scrum-based delivery environments.