Business Systems Analysts wanted.

Aug 26th, 2009 | by ViaDataWebAdmin |

Here at ViaData we need people who have what it takes to become extraordinary Business Analysts.
In fact, we’re looking for ViaData Alchemysts*.

(* – An Alchemyst? We have an amazing Business Systems Engine we call Catalyst, but for it to make SysDev magic it needs extraordinary Business Analysts – we like to think of them as Alchemysts.)

Do you have what it takes to become a ViaData Business Systems Alchemyst? If you’re interested in joining the ViaData team, tackle these four tasks and let us have your answers.

Task 1:

Write a 1,000 word discussion on the pro’s and con’s of a Data-based approach vs a Process-based approach to Systems Development.

Task 2:

Develop a data model to represent a car hire business. If you make assumptions, state them in a footnote.

Task 3:

Using the Northwind database supplied with SQL 2000 (Request a DB backup from us if you don’t have this) write SQL to do the following:

Input Parameters:

  • Date From (allowed to be null in which case return all)
  • Date To (allowed to be null in which case return all)

Output required:

  • Each employee who took sales order during the period.
  • For each employee return
    • Total orders taken
    • Average order value
    • Product name of product generating the most orders (value)
    • Value of order from highest valued product
    • Customer name of customer generating the most orders (value)
    • Value of order from highest valued product

NB: You may use any combination of views, functions and stored procedures (with or without cursors and temporary tables). Please supply the script to create all the necessary objects and to execute the query from query analyser or SQL Management Studio. Also note, we will review your answer for function and form (i.e. use of comments, indentation and which space).

Task 4:

Identify what you believe to be the most important success factors in a Systems Development project.

We’re looking for original thought here; you are welcome to use whatever means you like to research the answers to the problems, but remember to quote your sources and make sure you are able to defend the positions you take.

Send your answer (with your name, email address and phone number, but no CV please) to and we’ll let you know what the next step is once we’ve had a chance to give your work serious consideration.

We know it is not easy, but if you’re Alchemyst material, you’ll be up for the challenge. 😉

Post a Comment