GAIN - Central IT - Microsoft 365 Automation and Analytics Engineer

GAIN; Mumbai; On-site; INR 1,200,000 - 1,500,000; Full time

Job summary

A reputable technology firm in Mumbai is seeking a Microsoft 365 Automation Engineer to design and maintain solutions within the Microsoft 365 ecosystem. The ideal candidate will focus on automation and integration across various business functions, utilizing Microsoft 365 tools like PowerApps and Power Automate. This full-time position requires excellent problem-solving skills and a mid-senior level of experience.

Qualifications

• Experience with Microsoft 365 and Power Platform tools, including PowerApps and Power Automate.
• Ability to design and optimize automated workflows.
• Competence in integrating systems and creating dashboards.

Responsibilities

• Design and deploy Microsoft 365-based applications.
• Develop approval workflows and automations.
• Integrate back-office systems with Microsoft 365 tools.
• Automate document handling and data synchronization.
• Support enterprise data warehouse design and maintenance.

Skills

Proven experience developing within Microsoft 365 and Power Platform

Strong understanding of automation design

Experience integrating back‑office systems using APIs

Familiarity with Microsoft Azure

Knowledge of SharePoint Online development

Experience with SQL and data warehousing

Understanding of DevOps and CI/CD

Job description

Microsoft 365 Automation Engineer

Location: Mumbai

Reports to: IT Operations Manager

Direct Reports: N/A

Primary Purpose

To design, develop, and maintain internal solutions within the Microsoft 365 ecosystem, driving automation, efficiency, and integration across business functions. The Microsoft 365 Developer will build and manage business applications, approval workflows, intelligent agents, and data integrations connecting Finance, HR, Legal, and Operations systems, supporting a unified and automated digital workplace.

Responsibilities

Solution Development and Integration

• Design, develop, and deploy Microsoft 365-based applications, SharePoint sites and automations using Power Platform tools (Power Apps, Power Automate, Power BI, and Dataverse).
• Create, maintain, and optimise approval workflows and process automations across Finance, HR, Legal, and Operations.
• Integrate back‑office systems (ERP, HRIS, CRM, and document management) with Microsoft 365 tools to streamline data flow and enhance operational transparency.
• Develop Power BI dashboards and data models for reporting and analytics, supporting data‑driven decision‑making.
• Collaborate with stakeholders to capture business requirements and translate them into scalable digital solutions.
• Build and maintain connectors, APIs, and integrations for internal and external systems as required.

Automation and Agents

• Implement intelligent agents and chatbots using Microsoft Copilot, Power Virtual Agents, or equivalent technologies to enhance user experience and productivity.
• Automate repetitive processes, document handling, and data synchronisation across departments.
• Continuously review and improve automation performance to ensure reliability and compliance with business standards.

Data and Reporting

• Support the design and development of the enterprise data warehouse and reporting environment.
• Manage ETL pipelines and dataflows between internal systems and Power BI datasets.
• Maintain data accuracy, consistency, and accessibility across integrated platforms.

Continuous Improvement

• Stay updated on Microsoft 365 technologies, Power Platform updates, and emerging automation trends.
• Provide recommendations for continuous improvement and adoption of new capabilities across the business.
• Support end‑users and business teams through training and knowledge sharing.

Process, Quality and Information Security

• Manage workloads and ensure all committed work is completed within the iteration as per the definition of done.
• Ensure all work items have appropriate test coverage and are integrated into the release process; provide expertise for the team to achieve higher levels of test and code deployment automation.
• Attend CAB meetings as necessary and follow Gain's Change and Release process for deployments.
• Adopt and enhance CI/CD processes and tooling for automated deployments of both infrastructure and applications.
• Adhere to all information security policies and implement security by design in all developments.

Professional Skills & Experience

• Proven experience developing within Microsoft 365 and Power Platform (PowerApps, Power Automate, Power BI).
• Strong understanding of automation design, approval workflows, and process optimisation.
• Experience integrating back‑office systems (Finance, HR, Legal, Operations) using APIs, Graph API, or connectors.
• Familiarity with Microsoft Azure, Azure Functions, and Logic Apps.
• Knowledge of SharePoint Online development and document management solutions.
• Experience with SQL, data warehousing, and BI modelling.
• Understanding of DevOps and CI/CD for Power Platform or Microsoft 365 environments.

Personal Qualities

• Problem solver.
• Great with people, can build trust and rapport across the organisation.
• Good communicator with clients and internally.
• Team player, committed and flexible.
• Ability to prioritise and quickly resolve issues.
• Attention to detail.

Seniority Level

Mid‑Senior level

Employment Type

Full‑time