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.
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.
| Role | Typical week | Core tools | JD to use |
|---|---|---|---|
| Data analyst intern | Ad hoc questions, cleaning, recurring reports | SQL, Excel or Sheets, a BI tool | This template |
| BI or dashboard intern | Data models, dashboard builds, refresh schedules | Power BI or Tableau, SQL | This template, with dashboards first |
| Business analyst intern | Requirements, process maps, stakeholder notes | Excel, flowcharts, basic SQL | Business analyst intern JD |
| Data science intern | Models, experiments, feature work | Python, statistics, ML libraries | Data 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
| Skill | Quick check | Strong signal |
|---|---|---|
| SQL | Monthly revenue by city from an orders table and a customers table | Spots that a one-to-many join inflates the totals |
| Spreadsheets | A pivot and a lookup on a sample sheet | Reconciles the pivot against the raw data |
| Data hygiene | How would you treat blank or inconsistent values? | Documents each fix and what it changes |
| Dashboard judgement | Here is a cluttered dashboard: what would you remove? | Starts from the decision the viewer must make |
| Statistics basics | When is the median more useful than the average? | Mentions skew and outliers, with an example |
| Communication | Explain one finding to a sales manager in three sentences | Gives 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
- 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
- 5 internship or job postings
- Goes live instantly after company verification
- Full applicant contact details and resumes
- Email support
- 15 internship or job postings
- Goes live instantly after company verification
- Priority support and AI candidate matching
- Full applicant contact details and resumes
- 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.
