Power Automate Specialist – Finance & Accounting

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 a key 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
• Analyze 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 processes
• 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 requirements

4. TRAINING & KNOWLEDGE TRANSFER
• Develop a Finance & Accounting Automation Playbook detailing workflow architecture, security, and maintenance protocols
• Conduct hands-on 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 check-ins 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
• In-depth 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

• 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


People are our business worldwide
 
Orion Group was founded in 1987 and is now one of the largest, independent, international recruitment companies. We have a network of 200 employees working from 24 offices, delivering a range of services – Talent Acquisition, Recruitment Outsourcing Services, Retained Search, Global Workforce Solutions, Completions & Commissioning and Materials Management – across 68 countries. As a global leader in workforce solutions, we recruit personnel across the Engineering & Technical, Office & Commercial, Scientific and Skilled Trades disciplines, for sectors including Oil & Gas, Life Science, Power & Utilities, Constructions & Infrastructure, Manufacturing and Renewables.