Context

The services to be provided will primarily be for the SACHA project (Harmonized Accounting Analysis System in Agriculture). Depending on workload, it is possible that the contractor may be temporarily 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, particularly 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-annual data.
• A central stock management system (SCGS) recording all movements, allowing distributions on cumulative quantities, and supporting the specificities of fertilizers, seeds, plant 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 role 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 support linked to installation and investments.
• Comply with European obligations related to the RIDEA regulation (Regulation (EU) 1217/2009).
• Essential data source for DPEAI (SPW ARNE) as part of the preparation of CAP strategic plans
• Data source for estimating losses caused by various calamities
• Data source for multiple analyses of the Walloon agricultural sector, in particular to establish the annual report on the state of Walloon agriculture, in accordance with the Walloon Agricultural Code (D.88 to D.90).
• Data source for the academic community.

Constraints

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

Target architecture of SACHA

Back-office Angular, API Spring Boot, PostgreSQL DB, SPW Digital hosting.

Data migration

The project will recover the data currently stored in Excel files.

SOFT SKILLS

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

Evaluation method

Shortlisted candidates will be invited for an interview before a jury, the composition of which will be communicated later. The interview may be held remotely if circumstances require.