D365 Data Engineer

We are searching for a Data Engineer who will play a vital role in delivering a new, data-heavy case management and political finance platform built on Dynamics 365. You will help move complex, inconsistent legacy data into a modern CRM-based solution, enabling better insight, reporting, and regulatory decision-making. This is a 12-month fixed-term role within a small, focused programme team (Programme Lead, Technical Lead and three new hires), replacing the existing Political Finance Online system. Responsibilities • Design and implement scalable ETL/ELT pipelines to migrate legacy data into Dynamics 365. • Work with highly ambiguous and unstructured data, profiling, cleansing, normalising and enriching it for use in the new platform. • Develop data integration workflows using Azure Data Factory, Power Automate and Logic Apps. • Collaborate with Business Analysts, Solution Architects, the Programme Lead and Technical Lead to understand data models, business rules and reporting needs. • Define and implement data quality rules and validation checks to ensure accuracy, completeness and consistency. • Ensure data handling and storage comply with GDPR, accessibility standards, and relevant electoral and regulatory requirements. • Design and optimise data storage and retrieval patterns across cloud and any required on-premise environments. • Support the design and delivery of datasets and models to feed Power BI dashboards and reports. • Contribute to the design and implementation of automation and AI-driven features for case management and reporting.