Where can you find qualified {role_name}?

What are the best practices for headhunting {role_name}?

How to shortlist candidates?

Once you have started to get applications from applicants, a thorough screening process and shortlisting of prospects will help you make the most of your time spent with the most qualified ones. 

Automated shortlisting tools :

Automated screening quickly filters out unqualified candidates, saving time for manual review. This allows the manual process to focus on the most promising candidates, ensuring the best ones are considered for further evaluation.

Screening questions to auto-shortlist based on predefined criteria

like qualifications, location, experience, and skills. Either use job board or use an ATS such as whitecarrot. Here are some questions for {role_name}

• How many years of experience do you have with Power BI?
  • Less than 1 year: Auto-reject
  • 1-3 years: Keep for further review
  • 3+ years: Auto-shortlist
• How many years of experience do you have with SQL?
  • Less than 2 years: Auto-reject
  • 2-5 years: Keep for further review
  • 5+ years: Auto-shortlist
• Are you located within [specified location] or willing to work remotely?
  • No: Auto-reject
  • Yes: Keep for further review

Skill based question to auto shortlist candidate

Analyze the skill test data to automatically shortlist top-performing applicants. (recommended screening test time - 15 minutes). Here are some skill test questions for {role_name}

SQL

Knowledge of querying databases and handling complex data.

• Question 1: Write an SQL query to find duplicate records in a table called employees based on the email column.
  • Options:
    • a) SELECT email FROM employees GROUP BY email HAVING COUNT(email) > 1; (Correct)
    • b) SELECT * FROM employees WHERE email = 'duplicate';
    • c) SELECT * FROM employees HAVING COUNT(email) > 1;
• Question 2: What is the difference between an INNER JOIN and a LEFT JOIN?
  • Options:
    • a) INNER JOIN returns only matching rows, LEFT JOIN returns all rows from the left table with corresponding rows from the right. (Correct)
    • b) LEFT JOIN returns only matching rows, INNER JOIN returns all rows.
    • c) Both return all rows.
• Question 3: How do you remove duplicates from a result set in SQL?
  • Options:
    • a) Use DISTINCT (Correct)
    • b) Use GROUP BY
    • c) Use ORDER BY

Power BI

Proficiency with creating dashboards and visualizations in Power BI.

• Question 1: Which feature in Power BI allows you to define relationships between different tables of data?
  • Options:
    • a) Data Model (Correct)
    • b) Pivot Table
    • c) Chart Wizard
• Question 2: What does DAX (Data Analysis Expressions) in Power BI help you do?
  • Options:
    • a) Write custom calculations and aggregations (Correct)
    • b) Visualize data using pre-built templates
    • c) Connect to external data sources
• Question 3: Which type of visualization would you use to show trends over time?
  • Options:
    • a) Line Chart (Correct)
    • b) Bar Chart
    • c) Scatter Plot

Data Visualization

Skills in presenting data insights through visuals.

• Question 1: When creating a dashboard, which principle is most important for ensuring clarity?
  • Options:
    • a) Consistency in layout and format (Correct)
    • b) Use of bright colors for emphasis
    • c) As much information as possible on one screen
• Question 2: How would you handle outliers in a dataset when visualizing data?
  • Options:
    • a) Show them on the chart but distinguish them visually (Correct)
    • b) Remove them to simplify the chart
    • c) Ignore outliers altogether
• Question 3: Which type of chart is best suited for showing the composition of a whole?
  • Options:
    • a) Pie Chart (Correct)
    • b) Histogram
    • c) Line Chart

Note - Auto reject candidates if scores less than 70% in this section

One way video interview

Use tools like hirevue, whitecarrot.io to ask candidates pre-recorded questions about their experience and skills.

Use sample question given in scorecard.

Collect other information 

Collect data from shortlisted candidates, such as salary expectations and visa status.

Manual candidate profile shortlisting:

Thoroughly review the CVs of the top scoring candidates from the automated process

Look for evidence of the required skills, experience, and achievements

Review the candidate’s portfolio or GitHub repositories to see examples of their work.