Power Automate Specialist
19 hours ago
Houston
Job Title: Power Automate Specialist Duration: 6 Months contract (Possibility of Extension) Location: Houston, TX (Hybrid) Pay: $45-53 per hour on w2 without benefits Job Description: We're seeking a Power Automate Specialist with deep expertise in Microsoft Dynamics, Model Driven Apps, and SAP integrations to modernize and optimize our finance and accounting automation landscape. This individual will play akey role in assessing, redesigning, and governing workflow automations supporting core financial processes. The ideal candidate will combine technical expertise with strong business process understanding to ensure secure, scalable, and efficient automation across the enterprise. Key Responsibilities: 1. Inventory & Assessment: • Conduct a complete review of all existing Power Automate workflows and Power Apps used across Finance & Accounting., • Analyse integrations between Microsoft Dynamics, SAP, and other connected systems to identify efficiencies and gaps., • Document current state workflows, data flows, and dependencies; assess redundancy, reliability, and compliance with financial controls., • Create a prioritized improvement and modernization roadmap for financial automation. 2. Standards & Governance Implementation: • Develop and implement enterprise standards and best practices around Power Platform architecture, naming conventions, documentation, and security., • Define access and data control structures aligned with financial compliance standards (such as SOX GDPR, and internal audit requirements)., • Establish a governance model for workflow development, approval, maintenance, and version control—ensuring changes are auditable and traceable., • Collaborate with Finance leadership to integrate approval hierarchies consistent with accounting policies and segregation of duties principles. 3. Development & Modernization: • Refactor, streamline, and optimize existing Power Automate flows that support financial process., • Design and develop new Power Automate solutions integrated with SAP (via connectors, APIs, or middleware) and Microsoft Dynamics 365 Finance & Operations systems., • Implement real time or scheduled data synchronization flows to ensure consistency across systems., • Leverage Dataverse and Model Driven Apps to centralize key process data, improving visibility and audit readiness., • Ensure automations are built following financial compliance controls and audit requirement. 4. Training & Knowledge Transfer: • Develop a Finance & Accounting Automation Playbook detailing workflow architecture, security, and maintenance protocols., • Conduct handson training sessions for finance users, controllers, and analysts to empower them with self-service automation capabilities., • Lead knowledge transfer workshops to upskill internal IT and finance operations teams in Power Platform best practices., • Establish regular governance checkins to review workflow change requests, performance metrics, and compliance adherence. Qualifications: • 5+ years designing and developing solutions using Microsoft Power Automate, Power Apps (Model-Driven), and Power BI., • Proven experience integrating with SAP systems (through connectors, APIs, or RPA) and Microsoft Dynamics 365 Finance & Operations., • Indepth understanding of Dataverse (Common Data Service), entity relationships, and data modeling for financial workflows., • Strong understanding of financial systems and accounting processes, including GL, AP, AR, and expense management., • Experience establishing governance frameworks, version control, and CI/CD pipelines (e.g., Azure DevOps)., • Familiarity with security and compliance standards relevant to finance operations (SOX, internal audit, data governance). Business & Governance Skills: • Strong understanding of finance and accounting operations, KPIs, and period-close requirements., • Proven ability to document and communicate complex technical workflows in business-friendly terms., • Experience in implementing governance and change management processes for automation across finance functions., • Ability to collaborate across Finance, IT, and Audit teams to align process automation with financial controls. Soft Skills: • Exceptional communication and stakeholder management skills., • Analytical mindset with a strong attention to process optimization and detail., • Leadership in cross functional environments, capable of influencing business and IT stakeholders., • Proactive problem solver with a structured approach to troubleshooting and improvement. Preferred Qualifications: • Microsoft Certified: Power Platform Developer (PL-400) or Solution Architect (PL-600)., • Microsoft Certified: Dynamics 365 Finance Functional Consultant (MB-310)., • Experience with SAP Business Technology Platform (BTP), SAP API Management, or SAP Cloud Integration Suite., • Familiarity with Power BI financial dashboards and reporting. Key Skills: • Microsoft Power Automate (5+ years), • Microsoft Power Apps - Model-Driven Apps (5+ years), • Microsoft Power BI, • SAP Integration (connectors, APIs, middleware), • Microsoft Dynamics 365 Finance & Operations, • Dataverse / Common Data Service, • Financial Systems (GL, AP, AR, Expense Management), • Governance Frameworks & Version Control, • CI/CD Pipelines (Azure DevOps), • SOX Compliance & Financial Controls, • Process Optimization & Documentation, • Stakeholder Management, • Change Management Thank You!