Analytics roles · SQL, Excel, BI

Data Analyst Intern Job Description: SQL, Excel and Dashboards

A ready-to-post data analyst intern job description for Indian teams that need clean data, reliable reports and dashboards rather than machine-learning models. It covers SQL, Excel or Google Sheets, Python basics, BI tools and data hygiene, followed by a take-home task, a skills table and advice on safe data access.

Free JD templateReady to postScreening questionsSkills to test

Free listing for paid roles from ₹8,000/month (live within 2 working days after review) · Paid plans go live instantly after company verification · GST invoice

Tablet showing an analytics dashboard with charts and metrics
Quick answer

What should a data analyst intern job description include?

Name the business questions the intern will help answer and for which team, the data sources (sales, operations, marketing or product), the tools (SQL, Excel or Google Sheets, a BI tool such as Power BI or Tableau, Python basics), the reports or dashboards they will own, the stipend in rupees per month, duration and work mode. State what data they may access and under what controls, and leave out modelling unless the role is really data science.

Copy-ready job description

Replace every [placeholder] before sending. Copy the text or download it as a .txt file and paste it into your letterhead or email.

Data analyst intern job description (SQL, Excel and BI dashboards)
Title: Data Analyst Intern
Employer: [Company Name] ([industry])
Team: [Sales / Operations / Marketing / Product] analytics, reporting to [Manager Name, Title]
Work location: [City] – [In-office / Hybrid / Remote]
Tenure: [3 / 6] months, beginning [Start Date]
Stipend: ₹[Amount] per month
Weekly hours: [Full-time / Part-time: X hours]
Number of interns: [Number]

Who we are
[Company Name] [what you do and for whom]. Our [team] uses data every week to decide [examples: pricing, stock levels, campaign spend, delivery routes].

Why this role exists
We hold data in [CRM / ERP / app database / spreadsheets] that is not yet clean or easy to read. You will turn it into reliable tables, reports and dashboards, and help colleagues understand what the numbers mean. [Manager Name] will review your queries and reports every week.

What you will work on
- Write SQL queries to pull, join and aggregate data from [MySQL / PostgreSQL / BigQuery / SQL Server]
- Clean and validate datasets: remove duplicates, standardise formats, handle missing values and record every change
- Build Excel or Google Sheets reports with pivot tables, lookups and charts
- Create and maintain dashboards in [Power BI / Tableau / Looker Studio / Metabase], including refresh checks
- Answer ad hoc questions from [teams], such as [why did repeat orders fall in one region last month?]
- Use Python (pandas) for files too large or repetitive for spreadsheets [optional]
- Write short notes explaining findings, assumptions and caveats in plain language
- Keep a data dictionary of metric definitions and sources up to date

What you bring
- Pursuing or recently completed [B.Tech / B.Sc / B.Com / BBA / BA Economics / Statistics / any discipline]
- Working SQL: SELECT, WHERE, JOIN, GROUP BY and simple subqueries
- Confident Excel or Google Sheets: pivot tables, XLOOKUP or VLOOKUP, conditional formulas
- Basic statistics: averages, medians and spread, and when each one misleads
- Care with detail and the habit of checking that totals tie out
- Clear written English for non-technical colleagues

Good to have
- Python with pandas, or R
- A [Power BI / Tableau] dashboard from a project or course
- Familiarity with [industry, e.g. retail, logistics or fintech] metrics

What we offer
- Real business problems, using [anonymised / access-controlled] company data
- Weekly query and dashboard reviews with [Manager Name]
- Internship certificate [plus a recommendation letter on strong performance]
- [Pre-placement offer opportunity, if applicable]

Application process
Apply on MyInternships.in with your resume and, if available, a link to a dashboard, notebook or project report you built. Shortlisted candidates get a [2–3]-hour take-home task on a sample dataset, then a [30]-minute call to walk us through their approach.

This template is general guidance for employers in India, not legal advice. Adapt it to your company policies, the offer you actually made and the rules that apply to your organisation, and have contracts reviewed by a qualified adviser.

Data analyst, BI analyst or data scientist: title it correctly

Many internships advertised as ‘data science’ are really reporting and analysis. If your intern will spend the week in SQL, spreadsheets and dashboards, call it a data analyst internship: you will attract people who enjoy that work and avoid those expecting to build models. If the project genuinely involves prediction or experiments, use the separate data science JD.

RoleTypical weekCore toolsJD to use
Data analyst internAd hoc questions, cleaning, recurring reportsSQL, Excel or Sheets, a BI toolThis template
BI or dashboard internData models, dashboard builds, refresh schedulesPower BI or Tableau, SQLThis template, with dashboards first
Business analyst internRequirements, process maps, stakeholder notesExcel, flowcharts, basic SQLBusiness analyst intern JD
Data science internModels, experiments, feature workPython, statistics, ML librariesData science intern JD

See also: Data science intern job description Business analyst intern job description

Fitting the template to your data and tools

  • Name the three or four tools you really use; a list of ten reads like a course syllabus and puts off careful candidates.
  • If your data lives only in spreadsheets, say so, and make SQL ‘good to have’ rather than a requirement.
  • Describe the domain (orders, inventory, campaigns, loans or support tickets) so applicants can picture the questions.
  • Say whether the intern will work on live data, an anonymised copy or a sample, and who grants access.
  • Name the person who reviews queries; without review, errors reach decision-makers unchecked.
  • For remote roles, state the laptop, VPN or virtual desktop arrangements.

A take-home task built on messy data

The most useful screening task mirrors the job: a small synthetic dataset with the same problems as your real data. Send it after a short call, allow a few days, and cap the expected effort at two or three hours. Ask for a brief written summary and one chart, then hold a call where the candidate explains how they cleaned the data.

  • Plant duplicate orders, mixed date formats, blank or misspelt city names and refunds stored as negative values.
  • Ask three questions, one of which the data cannot answer reliably.
  • Note whether the candidate reports the problems and states assumptions instead of silently deleting rows.
  • Never put real customer names, phone numbers or account details in a hiring task.

Screening questions and skills to test

SkillQuick checkStrong signal
SQLMonthly revenue by city from an orders table and a customers tableSpots that a one-to-many join inflates the totals
SpreadsheetsA pivot and a lookup on a sample sheetReconciles the pivot against the raw data
Data hygieneHow would you treat blank or inconsistent values?Documents each fix and what it changes
Dashboard judgementHere is a cluttered dashboard: what would you remove?Starts from the decision the viewer must make
Statistics basicsWhen is the median more useful than the average?Mentions skew and outliers, with an example
CommunicationExplain one finding to a sales manager in three sentencesGives the answer first, then the caveat

Data access, privacy and confidentiality

An analyst intern often sees more company data than any other intern. Personal data you process digitally falls under the Digital Personal Data Protection Act, 2023, so give interns only what the task needs and check current requirements with whoever handles compliance. In practice that means named accounts, read-only access, masked phone numbers and email addresses, no downloads to personal devices, and access removed on the last day. Have confidentiality and data-handling terms signed before access is granted.

See also: Internship NDA template

Posting the analyst internship and searching for candidates

Start the AI hiring assistant at /hire-talent#post-internship and give it the team, data domain, tools, stipend, city and work mode. Within roughly two minutes the guided chat produces a title, description and skills list in a live preview; check that it says analyst rather than data scientist and names only your real tools. Your company is verified before anything is published.

Prefer to approach candidates first? In the candidate database you can type something like ‘SQL and Power BI intern in Hyderabad, available for six months’ and AI search ranks matching profiles; resumes and contact details unlock with credit packs. Plan details sit in the pricing table on the hiring page.

See also: Candidate database and AI search Posting plans and pricing Hire AI, data science and analytics interns

Frequently asked questions

What is the difference between a data analyst intern and a data science intern?

A data analyst intern answers business questions with existing data: cleaning it, querying it in SQL, building reports and dashboards and explaining the results. A data science intern builds predictive models or runs experiments, which needs stronger statistics and Python. Many companies need the first and advertise the second, so title the role after the work.

Does a data analyst intern need to know Python?

Not always. SQL and spreadsheets cover most analyst work, and a BI tool covers dashboards. Python with pandas helps when files are too large for Excel or reports must be automated, so list it as good to have unless your workflow depends on it. Requiring it unnecessarily shrinks your applicant pool without improving quality.

Which degrees suit a data analyst internship?

Any discipline in which the candidate can show work with numbers: engineering, statistics, mathematics, economics, commerce or management. Commerce and economics students with solid SQL often grasp business metrics quickly. Judge on a project and the take-home task, and describe your domain so applicants with relevant subject knowledge recognise themselves.

Can a data analyst intern work with our real customer data?

Yes, with controls. Give access only to the tables the project needs, mask personal details such as phone numbers and email addresses, use read-only named accounts and block downloads to personal devices. Have a confidentiality agreement signed before access starts, end access on the last day, and consider anonymised copies for the first weeks.

How long should a data analyst internship be?

Three months suits a defined project such as cleaning one dataset and building one dashboard. Six months lets the intern live through recurring cycles such as month-end reporting or a seasonal sales peak, and take over a report completely. State the length, start date and weekly hours so students can match them to their college calendar.

Should the JD ask for both Power BI and Tableau?

Ask for the tool your team uses. Dashboard skills transfer between BI tools, and someone strong in one can learn another quickly, so requiring both mainly filters out good candidates. If you have not chosen a tool yet, write ‘a BI tool such as Power BI or Tableau’ and test dashboard thinking instead of software names.

How do we check that a candidate's dashboard project is their own?

Ask them to walk through it live: where the data came from, how they cleaned it, how one measure is calculated and what they would change next. Then ask for a small change or an explanation of a formula. Borrowed projects fall apart under these questions quickly, while genuine ones produce detailed, slightly messy stories.

Are online certificates enough to shortlist a data analyst intern?

Treat certificates as evidence of interest, not skill. Two candidates with the same certificate can differ widely in SQL ability. Use the certificate to open a conversation about what they built, and base the decision on your take-home task and the walk-through call rather than on the number of courses listed.

Can a data analyst internship be done remotely?

Yes, if access is secure and reviews are regular. Provide a company laptop or virtual desktop where possible, keep data in approved systems rather than personal drives, and schedule a short weekly review of queries and dashboards. Write the work mode and any office days into the JD so that candidates in other cities can decide quickly.

What should a data analyst intern deliver by the end?

Agree on two or three concrete outputs at the start: for example, a cleaned dataset with documentation, a dashboard the team uses weekly and a short analysis of one business question. Written handover notes matter as much as the dashboard itself, because someone has to maintain it after the internship ends.

Plans and pricing for employers

Free
₹0
1 listing
  • 1 internship or job listing
  • Live for 30 days once approved
  • Reviewed by our team, live within 2 working days
  • Only for paid roles offering ₹8,000/month or more
  • Applicant contact details and resumes need an upgrade
Most popularStarter
₹999
incl. GST · 30 days
  • 5 internship or job postings
  • Goes live instantly after company verification
  • Full applicant contact details and resumes
  • Email support
Growth
₹1,999
+ GST · 30 days
  • 15 internship or job postings
  • Goes live instantly after company verification
  • Priority support and AI candidate matching
  • Full applicant contact details and resumes
Enterprise
Custom
volume hiring
  • Custom volume hiring and campus drives
  • Unlimited resumes
  • Dedicated sourcing team
  • SLA and GST invoice

Prefer to search candidates yourself? The candidate database lets you search, then unlock resumes and contact details with credit packs of ₹999 (incl. GST) or ₹1,999 (incl. GST), each valid for 30 days. Describe the role in plain English and the AI ranks matching candidates.

Prices in INR as of 21 November 2026. Pay securely by Razorpay; a GST invoice is issued for every paid plan (add your GSTIN at checkout). Enterprise pricing on request.

Hire a data analyst intern

Give the AI hiring assistant your team, data sources, tools and stipend. It drafts the analyst listing for you to review, and the role can go live as soon as your company is verified.

Post a jobPricing