Senior Power Platform, BI & Azure Integration Consultant

We are seeking a hands-on Senior Power Platform, BI & Azure Integration Consultant to lead business workflow digitization, enterprise reporting, and cloud integration initiatives across the organization. Operating primarily across Microsoft Power Automate, Power BI, Microsoft Fabric, and Azure Integration Services, this role is responsible for architecting and deploying practical digital solutions that eliminate manual effort and enhance operational visibility. In addition to core technical delivery, the role provides secondary project coordination managing project trackers, vendor dependencies, and stakeholder updates to ensure technology initiatives move smoothly from requirement gathering through production stabilization. Key Responsibilities 1. Workflow Digitization & Process Automation (Power Platform) • Partner with business departments to identify manual, repetitive, or paper-based processes and translate them into automated end-to-end workflows using Microsoft Power Automate (Cloud & RPA), Power Apps, and Dataverse. • Automate multi-stage approvals, notifications, task assignments, reminders, data collection, and cross-system workflows across Microsoft 365, SharePoint Online, Teams, and Outlook. • Proactively monitor automation execution logs, troubleshoot failures, and optimize workflow reliability, exception handling, and API connector performance. • Ensure all automated workflows strictly adhere to enterprise security, access control, compliance, and data governance policies. 2. Dashboarding, Reporting & Enterprise Analytics (Power BI & Fabric) • Design, develop, and publish interactive operational dashboards, management reports, and executive scorecards using Microsoft Power BI. • Build robust star-schema data models, complex DAX measures, and KPI frameworks supported by Microsoft Fabric (Lakehouse/Warehouse, data preparation pipelines) and SQL sources. • Connect and unify data across core business systems (ERP, CRM, HCM, DMS), SharePoint lists, Excel sources, databases, REST APIs, and cloud platforms. • Establish automated refresh schedules, implement Row-Level Security (RLS), reconcile report outputs, and coordinate with business owners for 100% data accuracy sign-off. 3. Cloud & Enterprise System Integration (Azure Integration Services) • Design, build, and support secure, scalable cloud integrations using Microsoft Azure Integration Services, including Azure Logic Apps, Azure Functions, API Management (APIM), Service Bus, and Event Grid. • Coordinate and maintain bidirectional integrations between ERP, CRM, HCM, DMS, Microsoft 365, SharePoint Online, databases, and external third-party platforms. • Define integration requirements, data mappings, JSON/XML message flows, REST API specifications, webhooks, and error-handling/retry frameworks. • Support System Integration Testing (SIT), User Acceptance Testing (UAT), deployment coordination, continuous monitoring, and incident resolution. 4. Secondary Project Coordination, Governance & Documentation (20% Allocation) • Maintain project plans, RAID logs (Risks, Assumptions, Issues, Dependencies), action trackers, timelines, and status updates for assigned digital initiatives. • Coordinate across business stakeholders, internal IT teams, external vendors, and implementation partners to drive delivery milestones and unblock dependencies. • Prepare concise weekly progress summaries, dashboard snapshots, and timely risk escalations for the Senior IT Manager. • Maintain comprehensive technical documentation, including workflow logic, data dictionaries, integration specifications, change control records, and operational support runbooks. Key Responsibilities 1. Workflow Digitization & Process Automation (Power Platform) Partner with business departments to identify manual, repetitive, or paper-based processes and translate them into automated end-to-end workflows using Microsoft Power Automate (Cloud & RPA), Power Apps, and Dataverse. Automate multi-stage approvals, notifications, task assignments, reminders, data collection, and cross-system workflows across Microsoft 365, SharePoint Online, Teams, and Outlook. Proactively monitor automation execution logs, troubleshoot failures, and optimize workflow reliability, exception handling, and API connector performance. Ensure all automated workflows strictly adhere to enterprise security, access control, compliance, and data governance policies. 2. Dashboarding, Reporting & Enterprise Analytics (Power BI & Fabric) Design, develop, and publish interactive operational dashboards, management reports, and executive scorecards using Microsoft Power BI. Build robust star-schema data models, complex DAX measures, and KPI frameworks supported by Microsoft Fabric (Lakehouse/Warehouse, data preparation pipelines) and SQL sources. Connect and unify data across core business systems (ERP, CRM, HCM, DMS), SharePoint lists, Excel sources, databases, REST APIs, and cloud platforms. Establish automated refresh schedules, implement Row-Level Security (RLS), reconcile report outputs, and coordinate with business owners for 100% data accuracy sign-off. 3. Cloud & Enterprise System Integration (Azure Integration Services) Design, build, and support secure, scalable cloud integrations using Microsoft Azure Integration Services, including Azure Logic Apps, Azure Functions, API Management (APIM), Service Bus, and Event Grid. Coordinate and maintain bidirectional integrations between ERP, CRM, HCM, DMS, Microsoft 365, SharePoint Online, databases, and external third-party platforms. Define integration requirements, data mappings, JSON/XML message flows, REST API specifications, webhooks, and error-handling/retry frameworks. Support System Integration Testing (SIT), User Acceptance Testing (UAT), deployment coordination, continuous monitoring, and incident resolution. 4. Secondary Project Coordination, Governance & Documentation (20% Allocation) Maintain project plans, RAID logs (Risks, Assumptions, Issues, Dependencies), action trackers, timelines, and status updates for assigned digital initiatives. Coordinate across business stakeholders, internal IT teams, external vendors, and implementation partners to drive delivery milestones and unblock dependencies. Prepare concise weekly progress summaries, dashboard snapshots, and timely risk escalations for the Senior IT Manager. Maintain comprehensive technical documentation, including workflow logic, data dictionaries, integration specifications, change control records, and operational support runbooks.