---
# System prepended metadata

title: Data Analyst

---

# Data Analyst

Suggestions:
Give the applicant a small standalone application with a SQLlight database and ask him to:

- Install an IDE, and run the app (technical skill needed)
- Correct models so the app display expected results (mapping skills)
- Write optimized queries

The database could be about Rates and Shipments, and queries could be:
- Display the list of shipments for case C212
- Find the list of shipments before 2020 and update the status to be "terminated"
- Display the number of containers for each shipment
- Calculate rate of T&T data completeness for each Forwarder

Bonus:
- Find the list of routes to go from A to B with 1 or 2 legs



**Database structure**

```
SHIPMENT
* Id
* CaseNumber
* ForwarderId
* Rate
* status
```

```
FORWARDER
* Id
* Name
```

```
TRACKTRACE
* Id
* EstimateDepartureTime
* EstimateArrivalTime
* ActualDepartureTime
* ActualArrivalTime
```

```
RATE:
* Id
* Origin
* Destination
* 20FtContainerPrice
* 30FtContainerPrice
```

```
SHIPPEDITEMS:
* Id
* ItemId
* ShipmentId
* Quantities
```

```
ITEM:
* Id
* Name
* QuantityPer20FtContainer: 2
* QuantityPer30FtContainer: 3
```