At CodeGround, our recruitment philosophy is simple. Make the recruitment test as closely aligned with the actual job as possible.
The best way to filter candidates for a Data Analyst role is by asking candidates to break down a business problem into a SQL statement, gather data using SQL and analyze it for patterns
You should test for English and Aptitude skills as a basic filtering mechanism. But, questions like the one below, truly test the candidate’s ability to perform well as a Data Analyst.
The candidate is given access to a SQL database instance via a browser. This contains sample test data of orders for a major online fashion e-store.
One Strategy Consultant believes that when the delivery date is within 1 day of the purchase date for the first cart ever purchased by a customer, he will keep making further purchases. But if the delivery date of the first cart ever purchased is 5 days after the purchase date, he will stop making further purchases. You are asked to get the data to validate his theory. Focus only on customers who made their first cart purchase in January of 2015. From customers who made their first purchase in Jan 2015, identity:
- Set of customers who had a delivery date within 1 day of purchase date. And the average number of subsequent carts purchased by those customers
- Set of customers who had a delivery date after 5 days of purchase date. And the average number of subsequent carts purchased by those customers
The candidate is asked to convert the stated problem into SQL, execute SQL queries using the browser, find the output and produce a recommendation in form of a PowerPoint presentation.
A reasonably good Data Analyst should be able to produce a recommendation with necessary justifications (results from SQL queries) for the sample business case stated above within 3 hours.
CodeGround enables you to hire the best Data Analysts for your openings by optimizing the recruitment funnel.
See the Getting Started Guide for more details on creating your own online tests.