Context

The services to be provided will primarily be for the SACHA project (Harmonized Accounting Analysis System in Agriculture). Depending on the workload, however, the contractor may temporarily be assigned to other projects.

Description of the SACHA solution

Development of an IT tool – online and modular – for agricultural management accounting, enabling the collection and processing of data related to various domains, notably through automatic links with external databases. This includes the implementation of:

• A unique, comprehensive, and modular journal capable of managing expenses, revenues, allocations, assignments, IN/OUT movements, IS/IE stocks, crop advances, and multi‑year data.
• A central stock management system (CSMS) covering all movements, allowing allocations on cumulative quantities, and supporting the specificities of fertilizers, seeds, crop protection products, crops, and livestock.
• Thematic web pages
• An import module to integrate various data from different sources
• An export module for various systems
• Advanced roles and access management
• A unique workflow management engine
• User action traceability
• A document archiving system
• A secure environment compliant with SPW Digital and GDPR rules

Objectives of SACHA

• Inform farmers about the profitability of their various activities and meet a Walloon legal obligation to access CAP aid related to installation and investments.
• Meet European obligations related to the RIDEA regulation (Regulation (EU) 1217/2009).
• Essential data source for DPEAI (SPW ARNE) in the context of preparing CAP strategic plans
• Data source for estimating losses caused by various calamities
• Data source for multiple analyses of the Walloon agricultural sector and, in particular, for establishing the annual report on the state of Walloon agriculture, in accordance with the Walloon Agriculture Code (D.88 to D.90).
• Data source for the academic world.

Constraints

Experiment with and participate in the development of a framework for the automatic generation of tables, views, pages, data migration scripts, and unit tests based on the analysis.

Target architecture of SACHA

Angular back office, Spring Boot API, PostgreSQL DB, hosted by SPW Digital.

Data migration

The project will migrate data currently stored in Excel files.

SOFT SKILLS

• Effective collaboration with the agile team
• Autonomous
• Pragmatic and results-oriented
• Ready to use and participate in the development of an automatic generation framework

Evaluation method

The remaining candidates will be invited for an interview before a jury whose composition will be communicated later. The interview may take place remotely if circumstances require.