Job posts for data analysts often read like a long wish list. Once you know what each line usually means in day-to-day work, they become much less intimidating, and you can tailor your resume to match.
"Extract, clean and analyse data from multiple sources"
This is the core of the job. In practice it means writing SQL against the company database, combining it with exports from tools (CRM, Excel sheets from other teams) and fixing messy values before analysis. Expect most of your time to go here.
What to show: SQL joins, aggregation, data cleaning in Excel or pandas.
"Build and maintain dashboards and reports"
Weekly sales reports, a Power BI dashboard for operations, a daily MIS sheet. "Maintain" matters: you will refresh, fix broken numbers and answer "why did this change?" questions.
What to show: one dashboard project with clear KPIs and a short explanation of the decisions it supports.
"Work with stakeholders to understand business requirements"
Managers rarely ask precise questions. "Sales are down, look into it" has to become "compare revenue by region and product for the last 8 weeks against the same period last year". This translation skill is what separates good analysts.
What to show: projects that start with a business question and end with a recommendation.
"Identify trends, patterns and insights"
Not just charts: explaining what changed, why, and what to do about it. Interviewers test this with case questions.
"Strong in SQL and Excel; Python or R is a plus"
Read this literally. SQL and Excel are must-haves and will be tested. Python is a nice-to-have that can make you stand out. Do not apply with only Python and weak SQL.
"Experience with Power BI or Tableau"
Usually one is enough. Skills transfer between tools; companies often accept either if you can show a real dashboard.
"Knowledge of statistics"
For most analyst roles this means averages, percentiles, distributions, correlation and basic A/B testing, not advanced theory.
"0โ2 years of experience"
Freshers can apply. Projects, internships and strong fundamentals often substitute for experience. Even "1โ3 years" posts sometimes hire strong freshers, especially at smaller companies.
"Attention to detail"
Your numbers will be used in decisions. Reconciling totals, checking duplicates and sanity-checking results are part of the job.
"Good communication skills"
You will present findings to people who do not read SQL. Clear summaries, simple charts and a confident explanation matter as much as the analysis.
Must-have vs nice-to-have
A practical rule: if a skill appears in the title or the first few bullet points, it is essential. Items after "plus", "preferred" or "good to have" are optional. Apply if you match most of the essentials.
Tailoring your application
- Copy the key skills from the post into a list.
- Make sure your resume shows each one with evidence: a project, a result, a tool.
- Use the same words as the post where they are true for you (ATS filters look for them).
- Put the most relevant project first.
Next steps
Find openings on our jobs page, tailor your resume with the resume builder, and prepare for the SQL round with interview questions. For the bigger picture, read what a data analyst actually does.
Practise what you just read
Reading helps; writing the code yourself is what sticks. Start here: