Data Engineer

Job Title: Data Engineer - Refactoring SIPAR 2 Contract duration: As soon as possible- 31/12/2026 Location: Brussels, Belgium Work status: Hybrid Languages: English and French Description: Introduction to COMPANY COMPANY is the IT operator for the Wallonia-Brussels Federation. As a public interest organisation, COMPANY's mission is to design, develop, maintain, and upgrade information systems and technological infrastructures serving the administrations and institutions of the Wallonia-Brussels Federation. A key player in the digital transformation of the French-speaking Belgian public sector, COMPANY operates in various fields such as: IT infrastructure management (networks, security, data centres, cloud), The development of custom business applications, Support for digital projects (functional analysis, UX/UI, project management), Cybersecurity and data protection, User support and training. With a constant focus on innovation, performance, and public service, COMPANY regularly collaborates with external partners to strengthen its teams through IT consulting assignments. These collaborations are conducted within an ethical and professional framework, prioritising quality and the tangible impact of the solutions delivered. The SIPAR2 application, currently an outdated monolithic Java architecture, is undergoing a transformation project to: -Modernise the technical architecture (transition to a modular architecture) Redesign the data model (reduce over-normalisation) Improve performance and scalability Strengthen security and GDPR compliance Facilitate integration with external systems (HubSessions, BI tools, etc.) Victim Support is a project that will begin in 2026 to develop a companion application to SIPAR2. This application offers advanced features for managing victims in legal cases. It will be integrated with SIPAR2 and will process data that is common to or similar to that of SIPAR2. These two projects are implemented by COMPANY (Entreprise des Technologies Numériques de l'Information et de la Communication) for the AGMJ (Administration Générale des Maisons de Justice). These two applications support more than 800 daily users and manage essential processes related to judicial administration. 2. Mission As a Data Engineer, you will be at the heart of the data management strategy for the SIPAR2 and Victim Support projects. Your responsibilities will include: Data Analysis and Collection Collaborate closely with functional analysts and business experts to understand the current data structure and the relationships between entities Conduct data quality audits to identify anomalies, duplicates, and inconsistencies Map existing data flows and critical dependencies Migration Strategy and Planning Review and validate the migration approach proposed by the refactoring provider Assess the technical feasibility and risks associated with the migration Propose improvements and optimisations to the initial strategy Document the decisions and technical justifications Data Selection and Cleaning Identify and select the data to be migrated based on business needs and compliance criteria Design and implement data cleaning and transformation processes Validate the quality of the transformed data before migration Document the transformation rules and exception cases Technical Support for Refactoring Support the development team throughout the various phases of the refactoring Validate the implementation of the database schemas in the target environment Participate in technical reviews and architectural decisions related to data Verify that all migration activities comply with Deloitte and COMPANY security and confidentiality standards Data Validation and Testing Support the testing team in executing data quality tests (smoke tests, consistency tests, etc.) Define the acceptance criteria for the quality of migrated data Support the resolution of detected anomalies Collaboration with COMPANY's Data Competence Centre Participate in regular exchanges with COMPANY's Data Competence Centre Apply the standards and best practices in place within the organisation, and ensure alignment with COMPANY's data strategy Share the project methodology and lessons learned with the COMPANY team Desired Profile Required Technical Skills Expertise in SQL database systems such as: IBM DB2 (v11.5 and above) MySQL ou PostgreSQL Knowledge of migration patterns and rollback strategies Expertise in relational data modelling Ability to optimise schemas for performance (denormalisation, indexing, partitioning) Proficiency in ETL tools such as Apache NiFi, Talend, Informatica or equivalent Experience with transformation scripts (SQL, Python, Groovy) Knowledge of data cleaning and validation patterns Familiarity with Java and the associated ecosystem (Maven, Gradle) and tools such as Git and GitLab Knowledge of project management tools (Jira, Confluence) Experience in the public sector (administration, justice, health, etc.) and, if possible, in the functional area of justice or administration Previous experience in data migration (at least 2-3 projects) Understanding of compliance issues (GDPR, security, auditing) Cross-cutting skills Autonomy: ability to work independently and take initiative Communication: ability to explain complex technical concepts to non-technical audiences Collaboration: experience working in international and external (near-shore) teams Rigour: attention to detail, respect for standards and processes Adaptability: the ability to adapt to a complex and changing environment Risk management: ability to identify and mitigate data-related risks