What a Data Analyst at 0–1 year can own
Scope: recurring reports, data pulls and dashboard refreshes from clean sources, checked by a senior analyst.
Supervision
Needs a named reviewer. Plan on daily check-ins for the first month and a review of every piece of work that reaches a customer or production.
Typical titles
Junior, Associate, Trainee or Graduate Engineer / Executive
Typical responsibilities at this level
- Write SQL to pull and join data for weekly reports
- Build and refresh Excel or Power BI dashboards
- Clean and validate data before it is shared
- Answer ad-hoc questions from business teams
Skills and tools to screen for
The skills are the same across bands — the depth is what changes. At 0–1 year, screen for SQL, data cleaning and writing a clear conclusion for a non-analyst.
Core skills
- SQL
- Excel / Google Sheets
- Power BI or Tableau
- Basic statistics
- Clear written summaries
Common tools
- SQL database
- Power BI / Tableau / Looker
- Python (pandas) — a plus
- Google Analytics
How to assess a 0–1 year candidate
At this band you are hiring for learning speed and fundamentals, not a track record. Projects, internships and a short practical task tell you far more than marks or certificates.
Practical exercise
Two hours with a messy CSV and three business questions. Ask for the SQL or spreadsheet steps plus a five-line summary written for a manager.
Red flag at this band: Certificates in five tools but no ability to write a join with a GROUP BY on the spot.
Indicative data analyst salary by experience (India)
| Experience | Indicative CTC | Level |
|---|---|---|
| 0–1 year | ₹3–6 LPA | Entry level |
| 1–3 years | ₹5–10 LPA | Early career |
| 3–5 years | ₹9–18 LPA | Mid-level |
Indicative market ranges for India, rounded, for guidance only — not MyInternships.in platform data. Metros and funded product companies tend to pay toward the top; tier-2 cities and services firms toward the bottom. Always benchmark against the candidate’s current CTC.
Interview questions for 0–1 year of experience
- INNER JOIN versus LEFT JOIN — give a business example.
- How would you find duplicate customers in a table?
- Weekly sales dropped 12% — where do you start?
- Tell me about a time the data said something you did not expect.
Notice period and ramp-up
Usually an immediate joiner or on a 15–30 day notice. Many are finishing a 2026 degree or a first internship, so confirm the exact date they can start.
Expect four to eight weeks before they are independently useful on routine work, faster if the internship was in the same stack or function.
Job description template
Job title: Data Analyst (0–1 year experience)
About the role: We are hiring a Data Analyst with 0–1 year of experience who can own recurring reports, data pulls and dashboard refreshes from clean sources, checked by a senior analyst. You will work with our team on write SQL to pull and join data for weekly reports and grow into broader ownership over time.
Responsibilities
- Write SQL to pull and join data for weekly reports
- Build and refresh Excel or Power BI dashboards
- Clean and validate data before it is shared
- Answer ad-hoc questions from business teams
Requirements
- 0–1 year (internship experience counts)
- Working knowledge of SQL, Excel / Google Sheets, Power BI or Tableau
- Comfort with Basic statistics and Clear written summaries
- Clear written and spoken communication in English
Nice to have
- An internship or project using SQL database or Power BI / Tableau / Looker
- Evidence of learning on their own — a course project, blog or open-source contribution
CTC: ₹3–6 LPA (indicative — set your own band; stating it in the post improves response)
Copy it, edit it, and paste it into the posting chat — or let the AI assistant write one for you.
Where to find 0–1 year data analyst candidates
Most candidates at this band come from engineering, statistics, mathematics, economics and MBA graduates, many with SQL and BI certifications.
- Make SQL the hard filter and treat specific BI tools as trainable.
- Ask applicants for one analysis they are proud of — a notebook, dashboard or write-up.
Post your Data Analyst role free
Tell us the role, experience band, city and CTC in a two-minute chat. Your listing reaches 63,000+ registered candidates, including 12,000+ from the 2026 batch.
Post a job freeFrequently asked questions
What can a data analyst with 0–1 year of experience handle?
Recurring reports, data pulls and dashboard refreshes from clean sources, checked by a senior analyst. Typical work at this band includes write SQL to pull and join data for weekly reports; build and refresh Excel or Power BI dashboards; clean and validate data before it is shared. Needs a named reviewer. Plan on daily check-ins for the first month and a review of every piece of work that reaches a customer or production.
What is the salary of a data analyst with 0–1 year of experience in India?
As an indicative market range, ₹3–6 LPA CTC — roughly ₹25,000 to ₹50,000 a month before deductions. Pay varies with city, company size, industry and the candidate’s current CTC; metros and funded product companies usually pay towards the top of the range. This is a guide, not MyInternships.in platform data.
How should I assess a data analyst at the 0–1 year level?
Focus on SQL, data cleaning and writing a clear conclusion for a non-analyst. A practical that works well: two hours with a messy CSV and three business questions. Ask for the SQL or spreadsheet steps plus a five-line summary written for a manager. At this band you are hiring for learning speed and fundamentals, not a track record. Projects, internships and a short practical task tell you far more than marks or certificates.
How long is the notice period for a data analyst with 0–1 year of experience?
Usually an immediate joiner or on a 15–30 day notice. Many are finishing a 2026 degree or a first internship, so confirm the exact date they can start. Expect four to eight weeks before they are independently useful on routine work, faster if the internship was in the same stack or function.
Where can I find data analyst candidates with 0–1 year of experience?
Most come from engineering, statistics, mathematics, economics and MBA graduates, many with SQL and BI certifications. Make SQL the hard filter and treat specific BI tools as trainable. On MyInternships.in you can post the role free and reach 63,000+ registered candidates and 45,000+ resumes on file; the platform is strongest at the entry and early-career end.
Should I hire a data analyst fresher, an intern or someone with 0–1 year of experience?
An intern suits a trial project or a seasonal peak; a fresher or 0–1 year hire suits a permanent seat you can train into. Candidates with a relevant internship behind them usually ramp up faster than pure freshers. If you are open to candidates with no experience at all, see our Hire Data Analyst Freshers page. For internships, see Hire Data Analyst Intern.
Same role, other experience levels
More data analyst hiring pages
Hire by city
Other data & analytics roles at 0–1 year
Browse every role and band in the hire-by-experience directory or go back to Hire Talent.