Power Automate Specialist

Xact Placements Limited; Potters Bar; On-site; GBP 50,000 - 80,000; Full time

Job summary

Xact Placements Limited seeks an experienced Power Automate Consultant to support a client’s transition from JET Reports to automated reporting using Microsoft Power Automate and Power Platform. You will map data flows and rebuild reporting processes integrated with Dynamics 365 Business Central.

Responsibilities include analysing existing JET Reports, designing automated workflows, and delivering documentation and training to ensure governance and data integrity.

Qualifications

• Experience designing and implementing Power Automate solutions for business reporting or data integration.
• Strong knowledge of Power Query and associated Power Platform tools.
• In-depth understanding of JET Reports and data structures.
• Hands-on experience with Microsoft Dynamics 365 Business Central; Evision is a plus.
• Microsoft certifications in Power Platform considered highly desirable.

Responsibilities

• Review and analyze existing JET Reports and data structures.
• Design and implement automated workflows using Power Automate and Power Query.
• Build efficient ETL processes and integrate data.
• Collaborate with teams to ensure reporting accuracy and usability.
• Provide documentation, training, and knowledge transfer.
• Ensure data integrity and recommend governance practices.

Skills

Data integration

ETL design

Reporting automation

Tools

Power Automate

Power Query

JET Reports

Power Platform

Dynamics 365 Business Central

Evision

Job description

Duration: 6-12 months

Location:Potters BarWe’re seeking an experienced Power Automate Consultantto support our client’s transition from JET Reportsto automated reporting using Microsoft Power Automateand Power Platform. The role focuses on analysing existing JET Reports, mapping data flows, and rebuilding reporting processes integrated with Microsoft Dynamics 365 Business Central.

Key Responsibilities

• Review and analyse existing JET Reports and data structures.
• Design and implement automated workflows using Power Automateand Power Query.
• Build efficient ETL processes and integrate data.
• Collaborate with internal teams to ensure reporting accuracy and usability.
• Provide documentation, training, and knowledge transfer.
• Ensure data integrity and recommend best practices for automation governance.

Skills & Experience

• Proven experience designing and implementing Power Automatesolutions for business reporting or data integration.
• Strong working knowledge of Power Queryand related Power Platform tools.
• In-depth understanding of JET Reports.
• Hands-on experience with Microsoft Dynamics 365 Business Central (experience with Evision is highly advantageous).
• Microsoft Certified:Power Platform Developer Associate or Power Automate RPA Developer Associate (highly desirable)