Police Judiciaire Fédérale

Mission context:

You will work on an application that monitors and detects fraudulent companies.

Based on a proof of concept (POC), significant steps were taken toward scaling the project nationally. An appropriate architecture was established, several data sources were made accessible, and part of the original code was rewritten. Based on the already available data sources, it is now possible to screen companies, and a basic dashboard model was developed so that the initial results can also be showcased. The data that has been and will be made accessible is processed in such a way that it can also be used for other applications within the police.

Further development will happen within a team of an internal project manager and a data engineer, together with two external experts: a data architect and a Python developer. The current team is available for knowledge transfers.

Leveraging the POC includes:

Business analysis:

• Identify what the end product should be, what are the requirements of the end users.
• Determine how to deliver as much value to the end users while ensuring compliancy with the legal obligations, etc.
• Work on improved reports and dashboards, while dealing with more complex calculations and data structures on the data warehouse side.
• Automate data delivery and refresh in the end product (mainly Power BI, but we also have a JavaScript application, etc).
• Work in a structured way, so we can keep overview but at the same time make sure the whole solution stays maintainable, while still leaving some options open for local configuration by the end user (~templates, parameters, …).
• Make the solution easy to use and to understand for our (non-technical) end users.
• Make use of APIs to deliver data to our applications or other development teams.
• Explore new opportunities with the existing data sources.

Profile description:

The BI engineer, together with the data engineer, Python developer, and the BI Architect, is responsible to deliver the relevant data from the data warehouse to the end users interfaces (Power BI dashboard, custom built applications, …) in a format easy to understand and to use, and compliant with the legal framework.

Technologies used: Power BI, APIs, git, JavaScript (Vue.js, …), relational databases (Postgres) and dbt.