About this role
Salary: £? - ? per year
Requirements: Strong experience with Power Platform Dataflows and Power QueryProven background designing and building cloud-based ETL pipelinesKnowledge of Dataverse and Dynamics 365 CE data structuresExperience training or coaching internal teamsUnderstanding of data migration, UAT processes, and error handling best practicesFamiliarity with SSIS/KingswaySoft is beneficial Responsibilities: Deliver hands-on training to a team of four on Power Query and Power Platform DataflowsGuide the design of a scalable ETL framework for recurring flat file importsSupport the team in building initial ingestion pipelines into Dataverse/D365Review and refine transformation logic, mapping, and pipeline structureProvide expert oversight during UAT, including error handling configurationOptionally build specific pipelines or mapping logic if internal capacity requiresWork with recurring Excel/CSV imports from third-party providersSupport six core D365 data patternsBuild a two-tier pipeline model with a pre-processing tier and a loading tierStandardise diverse source files into a unified schemaUpsert into D365 with robust de-duplication and matching logic Technologies: CloudCRMETLExcelSupportMicrosoft Dynamics 365 CRMMicrosoft Power PlatformPower QuerySSISOffice 365 More:
We are seeking an experienced Microsoft Power Platform Consultant to train and support our internal Data Team in building cloud-based ETL pipelines using Power Platform Dataflows and Power Query. This work underpins our migration to Microsoft Dynamics 365 CRM, with a production go-live planned for early 2027. The engagement is a remote contract role, with UK preference, running from Aug–Dec 2026.
last updated 29 week of 2026