Data · Mid-career

Data Analyst Resume Example

This example suits an analyst with two to seven years of experience in reporting, business intelligence or commercial analysis. It shows how to connect queries and dashboards to the people who used them and the decisions that followed, and how to give data quality work the space it deserves.

The example resume

Laid out in the Kerning template. The person, employers, schools and figures in this example are invented for illustration. Any resemblance to real people or organisations is unintended.

Mateus Carvalho

Data Analyst | SQL, Power BI, Excel

  • mateus.carvalho@example.com
  • +1 555 0118
  • Dublin, Ireland
  • linkedin.example.com/in/mateus-carvalho

Professional summary

Data analyst with six years of experience turning sales, stock and customer data into reports that commercial teams use every week. Strong in SQL and Power BI, comfortable with Python for cleaning and ad hoc analysis, and careful about data quality and metric definitions.

Work experience

Data Analyst

Fennick Home & Garden, Dublin

Mar 2022 – Present

  • Built a Power BI sales and margin dashboard used weekly by 30 buyers and store managers, replacing 14 separate Excel reports
  • Wrote and maintained SQL views in Snowflake covering 4 million order lines a year across 22 stores and the website
  • Analysed promotion performance for the commercial director and showed that 9 of 40 recurring offers lost margin; six were withdrawn the following season
  • Found and fixed a join error that double-counted click-and-collect orders, correcting reported online revenue by 6%
  • Agreed a single definition of "active customer" with marketing and finance, and documented 35 core metrics in a shared data dictionary

Reporting Analyst

Ashgrove Mutual Insurance, Dublin

Sep 2020 – Feb 2022

  • Produced monthly claims and renewals reports from SQL Server, cutting preparation time from two days to four hours with stored procedures and Power Query
  • Automated a weekly call-centre report in Excel that had been compiled by hand from five system exports
  • Investigated a rise in motor claim handling time and traced most of the delay to one document check; the process change cut the average by 2.5 days
  • Ran monthly reconciliation checks between the policy system and the data warehouse, flagging mismatches to IT before reports were issued

Skills

Querying: SQL (Snowflake, SQL Server), window functions, CTEs

Spreadsheets: Excel (Power Query, pivot tables, XLOOKUP)

Visualisation: Power BI (DAX, data modelling), Tableau

Analysis: cohort and trend analysis, A/B test read-outs, Python (pandas)

Practice: requirements gathering, metric definitions, data validation, documentation

Education

BSc Economics and Statistics

Carrowmore University, Dublin

2016 – 2020

Certifications

Microsoft Certified: Power BI Data Analyst Associate

Microsoft

2023

Languages

  • Portuguese (native)
  • English (fluent)
  • Spanish (conversational)

Open this example in the resume builder Start empty with this template

Why this resume works

  • Every bullet in the current role names who used the work: buyers and store managers, the commercial director, marketing and finance. Analysis has value when someone acts on it, and the document shows that each time.
  • The dashboard bullet states what it replaced (14 separate Excel reports) and how many people rely on it (30), which measures a BI project better than a list of chart types would.
  • Data quality gets two concrete bullets: a join error that overstated online revenue by 6%, and an agreed definition of "active customer". Both show judgement that a tool list cannot.
  • SQL, Power BI and Excel appear in the headline, the skills section and inside bullets, so the tools most analyst adverts ask for are shown in use and not only listed.
  • The earlier insurance role is kept to four bullets yet still shows progression, from producing scheduled reports to investigating why a number moved.

What employers look for in this role

  • Query, clean and combine data from databases, spreadsheets and business systems using SQL
  • Build and maintain dashboards and regular reports in a BI tool such as Power BI, Tableau or Looker
  • Answer ad hoc questions from commercial, operations, finance or marketing teams and explain the findings
  • Define metrics with stakeholders and document how each one is calculated
  • Check data quality, investigate discrepancies and work with data engineers to fix them at source
  • Identify trends and anomalies, and present recommendations to non-technical audiences

Skills to consider

List only the skills you can back up with an example. These are the ones that come up most for this kind of role.

Querying and data preparation
SQL (joins, window functions, CTEs), Excel and Power Query, Python with pandas, R, dbt, Data cleaning and validation
Visualisation and reporting
Power BI and DAX, Tableau, Looker or Looker Studio, Dashboard design, Self-service reporting
Analytical methods
Descriptive statistics, Cohort and funnel analysis, A/B test interpretation, Trend and seasonality analysis, Customer segmentation, Basic regression
Working with stakeholders
Requirements gathering, Metric definition, Presenting findings, Data dictionaries and documentation

More bullet points to adapt

Each of these follows the same pattern as the example: an action, what it was applied to, and what changed. Swap in your own facts and figures. The bullet builder assembles the pattern for you.

  • Rebuilt the weekly trading report as a single Power BI model with row-level security, so 12 regional managers each see only their own stores
  • Analysed two years of returns data and identified three product lines behind 41% of refunds, which the buying team then renegotiated or delisted
  • Read out an A/B test of the checkout page on 48,000 sessions, confirming a 1.8 point rise in conversion before the change was rolled out
  • Cut the runtime of the daily stock query from 25 minutes to under three by replacing nested subqueries with staging tables
  • Set up automated checks for nulls, duplicates and late files on 18 source tables, with alerts sent to the data team channel
  • Answered a board question on retention with a cohort analysis of repeat purchase within 90 days, split by acquisition channel

Words that recur in adverts

These terms appear often in adverts for this kind of role. Use the ones that are true of you, in sentences that show the skill in use, and check a specific advert with the keyword checker.

  • SQL
  • Power BI
  • Tableau
  • Excel
  • Dashboards
  • Data visualisation
  • KPIs
  • Ad hoc analysis
  • Data quality
  • Stakeholder management
  • Data modelling
  • ETL
  • Self-service reporting
  • Insights

Which sections to include

Lead with a two or three sentence summary that names your main tools and the business area you analyse, such as sales, operations or marketing. Experience follows and should take up most of the page, with each bullet tying a piece of analysis to the people who used it. Put skills next, grouped into querying, spreadsheets, visualisation and methods, because readers check tool names quickly. Education comes after that; a quantitative degree deserves a line of detail early in your career and less later. A vendor certification or a short languages section can close the page if there is room.

Mistakes to avoid

  • Listing tools without showing a question answered. "Proficient in SQL and Tableau" tells a reader less than one bullet describing what you found with them and what the business did next.
  • Describing dashboards by their features. Say who uses the dashboard, how often and what it replaced, instead of counting pages, slicers or visuals.
  • Leaving out data quality work because it seems unglamorous. Reconciling sources, fixing a broken join or agreeing a metric definition is what experienced analysts are trusted to do.
  • Claiming machine learning experience on the strength of one online course. If the target role is analysis, keep the emphasis on SQL, reporting and insight, and label any modelling honestly.
  • Giving row counts as the only number. Data volume adds context, but pair it with an outcome such as hours saved, an error corrected or a decision changed.

Questions and answers

How do I show impact when my job is mostly producing reports?

Describe each report through its use. Say who reads it, what decision it supports, what manual work it replaced and how much time it saved. If a finding led to a change, such as an offer withdrawn or a process fixed, state that. The bullet builder can help you fit the action, method and result into one line.

Do I need Python or R on a data analyst resume?

It depends on the adverts you are answering. Many analyst roles centre on SQL, a spreadsheet and a BI tool, and treat Python or R as a useful extra for cleaning data and automating repeated work. List them if you use them for real tasks and say what for, as in "Python (pandas)" under analysis here.

Should I link to a portfolio of dashboards or notebooks?

A link helps most when you have little paid experience or your work is confidential. Include one or two finished pieces with a clear question, method and finding, and check that nothing contains data belonging to an employer. Once you have several years of experience, your bullets carry more weight than a portfolio.

How is a data analyst resume different from a data scientist resume?

An analyst resume emphasises answering business questions: SQL, dashboards, metric definitions and clear communication. A data scientist resume gives more space to building and evaluating models, designing experiments and deploying them with engineers. If you are moving from one to the other, compare this page with the data scientist example and adjust the emphasis.