How to source and shortlist {role_name}

Where can you find qualified {role_name}?

  • Professional network
    • Leverage your professional network and reach out to former colleagues, industry peers, and tech community members to ask for referrals.
  • Educational Institutions
    • University Career Centers: Partner with universities that offer programs in data science, analytics, or information systems.
  • Company Career Pages
    • Posting on your company’s own career page allows you to attract candidates who are genuinely interested in working for your organization.
  • Role-Specific Job Boards
    • Glassdoor: Specializes in tech roles and BI job postings.
      Glassdoor
    • Indeed: Offers a wide reach for BI developers.
      Indeed
  • Geography-Specific Job Boards
    • US:
      • Dice: Technology and BI-specific jobs.
        Dice
      • SimplyHired: General platform with BI developer listings.
        SimplyHired
    • India:
      • Naukri: Popular for technology and analytics roles.
        Naukri
      • Shine: Another top platform for data roles.
        Shine
    • UAE & KSA:
      • Bayt: Focuses on Middle East job markets.
        Bayt
      • GulfTalent: Also popular in UAE and KSA for tech roles.
        GulfTalent
    • Remote Positions:

What are the best practices for headhunting {role_name}?

  • Leverage Professional Networks: Reach out to potential candidates on LinkedIn and GitHub, focusing on their BI and data visualization experience.
  • Targeted Messaging: Personalize your message to reflect the specific BI tools and technologies used in your organization.
  • Engage in Data Communities: Join and post in online forums and communities like Reddit's data engineering threads, or BI-specific groups on LinkedIn.
  • Attend Industry Events: Both virtual and in-person events like data analytics summits or Power BI workshops are excellent for sourcing top talent.

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

Recruitment Bullet

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

Recruitment Bullet

Use sample question given in scorecard.

Collect other information 

Recruitment Bullet

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

Manual candidate profile shortlisting:

Recruitment Bullet

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

Recruitment Bullet

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

Recruitment Bullet

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

Schedule recruiter calls with the candidate

Recruitment Bullet

Use a tool like calendly or whitecarrot to allow candidates to self-schedule calls based on your availability

Recruitment Bullet

Confirm the call details (date, time, dial-in info) with the candidate via email

What questions to ask in the recruiter phone screen?

Recruitment Bullet

 Use scorecard for rating candidates for recruiter

Recruitment Bullet

Sample scorecard : 

Criteria Sample Question Rating (1-5) Comments
Power BI Expertise How do you handle data visualizations in Power BI?
SQL Knowledge Can you explain a complex SQL query you’ve written?
Problem-Solving Ability Describe a time you solved a complex data problem.
Communication Skills How would you explain a data insight to a non-technical stakeholder?
Cultural Fit Why are you interested in working for our organization?
Recruitment Bullet

Check for consistency in responses from the candidates.

Recruitment Bullet

Record such scorecards in an ATS like whitecarrot or use google doc