At a Glance
- Tasks: Train a team on Power Query and Dataflows while building cloud-based ETL pipelines.
- Company: Join a forward-thinking organisation migrating to Microsoft Dynamics 365 CRM.
- Benefits: Remote work, flexible contract, and the chance to shape future data processes.
- Other info: Exciting opportunity to work on a major migration project until December 2026.
- Why this job: Make a real impact by empowering teams with essential data skills.
- Qualifications: Experience with Power Platform, ETL pipelines, and training internal teams required.
The predicted salary is between 50000 - 65000 £ per year.
Location: Remote (UK preferred)
Engagement: Contract
Timeline: Aug–Dec 2026
Overview
We are seeking an experienced Microsoft Power Platform Consultant to train and support the internal Data Team in building cloud-based ETL pipelines using Power Platform Dataflows and Power Query. This work underpins the organisation’s migration to Microsoft Dynamics 365 CRM, with a production go live planned for early 2027.
Key Responsibilities
- Deliver hands-on training to a team of four on Power Query and Power Platform Dataflows
- Guide the design of a scalable ETL framework for recurring flat file imports
- Support the team in building initial ingestion pipelines into Dataverse/D365
- Review and refine transformation logic, mapping, and pipeline structure
- Provide expert oversight during UAT, including error handling configuration
- Optionally build specific pipelines or mapping logic if internal capacity requires
Technical Scope
- Recurring Excel/CSV imports from third-party providers
- Six core D365 data patterns
- Build a two-tier pipeline model:
- Pre-processing tier: standardise diverse source files into a unified schema
- Loading tier: upsert into D365 with robust de-duplication and matching logic
Requirements
- Strong experience with Power Platform Dataflows and Power Query
- Proven background designing and building cloud-based ETL pipelines
- Knowledge of Dataverse and Dynamics 365 CE data structures
- Experience training or coaching internal teams
- Understanding of data migration, UAT processes, and error handling best practice
- Familiarity with SSIS/KingswaySoft beneficial
Please send in your CV with a brief summary of your skills. Looking forward to speaking to you.
D365 CE Power Platform Trainer in Birmingham employer: Innovative Tech People
Innovative Tech People is an excellent employer, offering a dynamic and supportive work culture that prioritises employee growth and development. With a focus on innovation and collaboration, team members are encouraged to enhance their skills through hands-on training and mentorship, particularly in the exciting field of Power Platform and data management. The remote nature of this role allows for flexibility while being part of a forward-thinking company that values its employees' contributions.
