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.