Code challenge

Home Careers Code challenge

So you're curious to know whether you've got what it takes to join JBA Software. Below is our code challenge to you.

At JBA we regularly receive varied datasets from our clients. To work with them efficiently, we often have to transform them into something which we can use more readily. We want to see your development skills in data manipulation.

Download the example data

The example data contains precipitation (rainfall) data that we would like in a database table with the following structure.

Xref Yref Date Value
1 148 1/1/1991 3020
1 148 2/1/1991 2820

To help you understand the data, an excerpt is shown below with notes on its structure.

The code that you write should have an option to specify the file name, read in the header data, transform the data, create the database table structure and insert the information into the database.

You are free to use any programming language and database technology that you choose. For junior developers we're looking to see what you can do; for senior developers we want to see evidence of your coding standards.

Once you're done - send your code (or link to a source control repository), CV and covering letter to If we need to compile your code, please let us know of any compiler flags required.