How to hire a data analyst in Mumbai

Start here

What kind of data analyst do you need?

A data analyst turns numbers into answers. Decide which questions you want answered, because that sets the skills you need.

Reports for the owner
Regular sales, stock or cost reports pulled from your data.
Dashboards
Live views that managers can open without asking for a report.
Finding the why
Looking into why sales dropped or customers left.
Cleaning data
Fixing messy sheets and joining data from different places.

Skills

Skills and tools to ask for

Ask for the tools your data lives in. These are the usual four.

SQL
Pulling, joining and summarising data from a database.
Excel or Sheets
Filters, lookups, pivot tables and clean layouts.
A dashboard tool
One BI tool to build charts and dashboards, ideally the one you use.
Basic statistics
Averages, trends and knowing when a number is too small to trust.

Also useful, depending on your work:

Explaining findings to people who are not technical, in short and plain words.
Checking their own numbers and spotting data that looks wrong.
Asking the right question before starting the analysis.
Python for larger or repeated work, if your data needs it.
Care with private data about customers or staff.

The job description

What to put in the job description

Say where your data is and what questions you want answered. Keep it short and include these points. More on this in how to write a job description.

The title and the office area, with any remote or hybrid days.
Where your data lives: spreadsheets, a database or an accounts system.
The tools you use, for example SQL, Excel and a dashboard tool.
The first reports or questions the person will work on.
Who they will report to and who will read their work.
Your pay range, to be given honestly on the first call.

Title: Data Analyst
Location: [Your area], Mumbai. [Number] days in office, rest remote.
Experience: 1 to 3 years in a data or reporting role. Freshers with strong projects may apply.
Skills: SQL, Excel or Google Sheets, one dashboard tool, basic statistics, clear written and spoken explanation.
The work: Build weekly and monthly reports, keep a dashboard up to date, clean data from different sources, and explain what the numbers mean to the owner and the team.
Hours: [Days and hours].
Salary: [Your range], to be discussed on the call.
To apply: Share a dashboard or report you made, with private data removed. We will call you if your profile matches.

Check

How to check how they work with data

A resume lists tools. A short practical task shows care, accuracy and how well they explain.

Ask for a sample dashboard or report, with private data removed.
Ask them to walk through one analysis: the question, the data, what they found and what the business did next.
Give a small data file and one real question. Ask for a short answer in plain words, in an hour or two.
Ask how they check their numbers before sharing them.
Ask what they do when the data looks wrong or is missing.
Ask them to explain a result to you as if you do not know the field.

Use our first-call questions to keep the first call short, and check the experience before you invite them in.

Where

Area and hybrid work in Mumbai

Analysts work closely with the owner and the managers who use their reports. Some office days help, especially at the start, when they are learning your business.

Search the locality of your office first, then the next stations along the same line, since a short commute decides who accepts and who stays. See hiring by Mumbai locality.

Search in plain words, for example “data analyst with SQL and Excel in Andheri”. See how to use the resume database. To decide how experienced the person should be, read fresher or experienced.

Avoid these

Common mistakes when hiring a data analyst

Mistake

Better

Mistake
Asking for a data scientist
You pay for advanced skills your data may not need yet.
Better
Hire an analyst first; add more when the questions grow.
Mistake
Listing every tool
Nobody has all of them.
Better
Ask for SQL, Excel and one dashboard tool.
Mistake
No clear questions
Better
Write down the first three questions you want answered.
Mistake
Skipping the explaining test
Better
Ask them to explain a result in plain words; that is half the job.
Mistake
Sharing sensitive data too early
Better
Use sample or hidden data for the task. Check with a professional about the rules for your customer data.

FAQ

Common questions

Is a data analyst the same as a data scientist?

No. A data analyst answers business questions from existing data: what sold, who left, where money is lost. A data scientist builds predictive models and does more advanced maths. Most small and mid-size businesses need an analyst first.

Which tools should I ask for?

Ask for SQL and Excel or Google Sheets as the base. Then ask for one dashboard tool, ideally the one you already use. If you have none, say so and ask how quickly they have learned a new tool before.

How do I test a data analyst?

Give a small spreadsheet or data file and a real question, then ask for a short answer in plain words. Keep it to an hour or two. Watch how they clean the data, how they check their numbers and how clearly they explain the result.

Does the analyst need to be a statistics expert?

No. Basic statistics is enough for most roles: averages, spread, trends and knowing when a number is too small to trust. Ask them to explain these in simple words.

Search Resumes

How to hire a data analyst in Mumbai

Start here

What kind of data analyst do you need?

A data analyst turns numbers into answers. Decide which questions you want answered, because that sets the skills you need.

Reports for the owner
Regular sales, stock or cost reports pulled from your data.
Dashboards
Live views that managers can open without asking for a report.
Finding the why
Looking into why sales dropped or customers left.
Cleaning data
Fixing messy sheets and joining data from different places.

Skills

Skills and tools to ask for

Ask for the tools your data lives in. These are the usual four.

SQL
Pulling, joining and summarising data from a database.
Excel or Sheets
Filters, lookups, pivot tables and clean layouts.
A dashboard tool
One BI tool to build charts and dashboards, ideally the one you use.
Basic statistics
Averages, trends and knowing when a number is too small to trust.

Also useful, depending on your work:

Explaining findings to people who are not technical, in short and plain words.
Checking their own numbers and spotting data that looks wrong.
Asking the right question before starting the analysis.
Python for larger or repeated work, if your data needs it.
Care with private data about customers or staff.

The job description

What to put in the job description

Say where your data is and what questions you want answered. Keep it short and include these points. More on this in how to write a job description.

The title and the office area, with any remote or hybrid days.
Where your data lives: spreadsheets, a database or an accounts system.
The tools you use, for example SQL, Excel and a dashboard tool.
The first reports or questions the person will work on.
Who they will report to and who will read their work.
Your pay range, to be given honestly on the first call.

Title: Data Analyst
Location: [Your area], Mumbai. [Number] days in office, rest remote.
Experience: 1 to 3 years in a data or reporting role. Freshers with strong projects may apply.
Skills: SQL, Excel or Google Sheets, one dashboard tool, basic statistics, clear written and spoken explanation.
The work: Build weekly and monthly reports, keep a dashboard up to date, clean data from different sources, and explain what the numbers mean to the owner and the team.
Hours: [Days and hours].
Salary: [Your range], to be discussed on the call.
To apply: Share a dashboard or report you made, with private data removed. We will call you if your profile matches.

Check

How to check how they work with data

A resume lists tools. A short practical task shows care, accuracy and how well they explain.

Ask for a sample dashboard or report, with private data removed.
Ask them to walk through one analysis: the question, the data, what they found and what the business did next.
Give a small data file and one real question. Ask for a short answer in plain words, in an hour or two.
Ask how they check their numbers before sharing them.
Ask what they do when the data looks wrong or is missing.
Ask them to explain a result to you as if you do not know the field.

Use our first-call questions to keep the first call short, and check the experience before you invite them in.

Where

Area and hybrid work in Mumbai

Analysts work closely with the owner and the managers who use their reports. Some office days help, especially at the start, when they are learning your business.

Search the locality of your office first, then the next stations along the same line, since a short commute decides who accepts and who stays. See hiring by Mumbai locality.

Search in plain words, for example “data analyst with SQL and Excel in Andheri”. See how to use the resume database. To decide how experienced the person should be, read fresher or experienced.

Avoid these

Common mistakes when hiring a data analyst

Mistake

Better

Mistake
Asking for a data scientist
You pay for advanced skills your data may not need yet.
Better
Hire an analyst first; add more when the questions grow.
Mistake
Listing every tool
Nobody has all of them.
Better
Ask for SQL, Excel and one dashboard tool.
Mistake
No clear questions
Better
Write down the first three questions you want answered.
Mistake
Skipping the explaining test
Better
Ask them to explain a result in plain words; that is half the job.
Mistake
Sharing sensitive data too early
Better
Use sample or hidden data for the task. Check with a professional about the rules for your customer data.

FAQ

Common questions

Is a data analyst the same as a data scientist?

Which tools should I ask for?

Ask for SQL and Excel or Google Sheets as the base. Then ask for one dashboard tool, ideally the one you already use. If you have none, say so and ask how quickly they have learned a new tool before.

How do I test a data analyst?

Does the analyst need to be a statistics expert?

No. Basic statistics is enough for most roles: averages, spread, trends and knowing when a number is too small to trust. Ask them to explain these in simple words.

Search Resumes

How to hire a data analyst in Mumbai

What kind of data analyst do you need?

Reports for the owner

Dashboards

Finding the why

Cleaning data

Skills and tools to ask for

SQL

Excel or Sheets

A dashboard tool

Basic statistics

What to put in the job description

How to check how they work with data

Area and hybrid work in Mumbai

Common mistakes when hiring a data analyst

Common questions

Related reading

How to hire a data analyst in Mumbai

What kind of data analyst do you need?

Reports for the owner

Dashboards

Finding the why

Cleaning data

Skills and tools to ask for

SQL

Excel or Sheets

A dashboard tool

Basic statistics

What to put in the job description

How to check how they work with data

Area and hybrid work in Mumbai

Common mistakes when hiring a data analyst

Common questions

Related reading