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.
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.