DayShift / Job descriptions / Data analyst

Data analyst job description: what you'll do and what to write on your resume

Applying for data analyst at a company that needs reports and numbers explained? Copy the duties below into your resume, then read what the interview asks.

Duties to write on your resume

Start each line with what you did. Keep the ones you've really done.

• Collected and cleaned data from spreadsheets, databases and system exports before analysis
• Wrote SQL queries to pull sales, customer and operations data
• Built reports and dashboards in Excel and Power BI for managers
• Checked data for errors, duplicates and missing values before sharing results
• Tracked key numbers weekly and explained changes in simple language
• Created charts and summaries that helped teams make decisions
• Automated repeated reports using Excel formulas, macros or simple scripts
• Worked with other teams to understand what numbers they needed

No work experience yet? Use the same lines for school projects, thesis data work or a personal spreadsheet project, and say where.

A resume objective you can adapt

Fresh graduate looking for a data analyst job, skilled in Excel and SQL and ready to turn raw data into clear reports your team can use.

Skills employers ask for

• Excel, including pivot tables and formulas
• Basic SQL
• Making clear charts and dashboards
• Spotting errors and odd numbers in data
• Explaining results in plain English

What the interview asks

1. Tell me about a time you used data to answer a question. Pick one real project, say the question, what you did and what you found.
2. How do you check that your data is correct? Mention looking for duplicates, blanks and numbers that don't add up.
3. What tools have you used? Name only the tools you've really used, like Excel, SQL or Power BI.
4. How would you explain a report to someone who hates numbers? Start with the main finding, keep it short and use one simple chart.

The questions every interview asks, with sample answers

How to get hired

1. Most posts ask for a college degree in a field like statistics, IT, business or accounting, but some accept strong skills and projects.
2. Prepare a resume, a valid ID and your government numbers such as SSS, PhilHealth, Pag-IBIG and TIN.
3. Many posts ask for NBI clearance or a medical certificate once you pass the interview.
4. Expect a short interview, and sometimes a small test with Excel or SQL.

What the work is like

You sit at a desk and work on a computer for most of the day. The hard part is tight deadlines and messy data that takes time to clean.

Use the data analyst resume template

Questions

Do I need experience to work as a data analyst?

Many entry-level posts ask for little or none, but they often want to see Excel or SQL skills and a sample project.

What should I study to become a data analyst?

Most posts ask for a degree in statistics, IT, math, business or accounting. Free online courses in Excel and SQL can help you show skills.

Can a data analyst work from home?

Some posts allow it, but it depends on the company and the role.

Similar jobs

• Financial analyst
• Accountant
• Bookkeeper
• Data encoder
• Internal auditor

Want work from home in daylight hours?

DayShift lists remote jobs with Singapore and Asia clients, on the same clock as Manila. Applying is free, and we never ask you for money. See today's DayShift jobs