Career Guide HQ

20 Hard Skills to Put on a Resume by Industry

Twenty testable abilities — from SQL and Power Query to HACCP checks and GD&T — matched to the roles that hire for them, each with a sample bullet.

Table of contents
Featured image for "20 Hard Skills to Put on a Resume by Industry"

Hard skills are the parts of your resume someone could test: a tool, a language, a machine, a procedure, a licence. This guide lists 20 of them across data, finance, HR, IT, marketing, sales, construction, healthcare, hospitality and manufacturing, says which roles each one suits, and gives an example resume bullet for each so you can see what "proof" looks like.

Use it as a checklist against a specific job ad. Listing skills you can't demonstrate is the fastest way to lose a phone screen.

How to use this list

Pick by the job ad, not by the list. Read the posting twice: once for the tools and procedures it names, once for the tasks it repeats. Those named tools are your keywords, and they belong on the resume in the same words the ad uses — "Power BI", not "data visualisation software".

Then split what you have into two places:

  • Skills section: 8–14 hard skills, grouped in 2–4 short lines by type (tools, languages, certifications). No rating bars, no percentages.
  • Experience bullets: the 4–6 skills the job is really about, each shown inside a bullet with a task and a number attached.

Anything you can't back up in an interview stays off. If a skill is central to the ad and you have it only in a course or a side project, put it under a projects or training block instead of claiming it as work experience.

The list at a glance

#SkillHard or softRoles it suits best
1SQL (joins, aggregation, window functions)HardData analyst, BI analyst, marketing ops, finance analyst
2Excel modelling (pivot tables, XLOOKUP, Power Query)HardFinance, operations, admin, supply chain
3Python for data analysis (pandas, Jupyter)HardAnalyst, data engineer, research assistant
4Dashboard building in Power BI or TableauHard, soft deliveryBI analyst, reporting analyst, ops manager
5Financial modelling and forecastingHardFP&A analyst, corporate finance, commercial analyst
6Bookkeeping and month-end close (QuickBooks, Xero, NetSuite)HardBookkeeper, accounts assistant, staff accountant
7Payroll and HRIS administration (ADP, Workday, BambooHR)HardPayroll administrator, HR coordinator, HR generalist
8Recruiting operations and ATS use (Greenhouse, Lever, Workday Recruiting)HardRecruiter, talent coordinator, HR generalist
9AWS cloud architecture (EC2, S3, RDS, VPC, IAM)HardCloud engineer, solutions architect, DevOps
10Hardware and OS troubleshooting (Windows, macOS, imaging)HardIT support technician, service desk, field tech
11Food safety and HACCP complianceHardChef, kitchen manager, food production supervisor, QA
12Security monitoring and vulnerability management (SIEM, Nessus)HardSOC analyst, security engineer, IT auditor
13Project scheduling and delivery (MS Project, Jira, Smartsheet)Hard, soft deliveryProject manager, PMO analyst, construction coordinator
14Technical documentation (Confluence, MadCap Flare, DITA)Hard, soft deliveryTechnical writer, support lead, implementation consultant
15SEO and web analytics (GA4, Search Console, Semrush)HardSEO specialist, content marketer, digital analyst
16Paid media buying (Google Ads, Meta Ads Manager)HardPerformance marketer, media buyer, growth marketer
17CRM administration (Salesforce, HubSpot)HardSales operations, RevOps, account manager, CRM admin
18CAD and drafting (AutoCAD, Revit, SolidWorks)HardDesign engineer, drafter, architectural technician
19EHR charting and clinical documentation (Epic, Cerner)HardNurse, medical assistant, health information clerk
20CNC machining and blueprint reading (GD&T, Mastercam)HardMachinist, manufacturing technician, QC inspector

Each skill, with an example bullet

1. SQL

Employers mean you can pull and shape data yourself without asking an engineer — joins across several tables, grouping, filtering, and ideally window functions and CTEs.

Data analyst bullet

Wrote and maintained 40+ SQL queries across a 12-table warehouse to produce a weekly churn report used by 3 regional managers.

2. Excel modelling

Not "knows Excel". They mean pivot tables, lookup functions, clean formula structure, and often Power Query to pull and refresh source data automatically.

Operations analyst bullet

Rebuilt a 14-tab budget workbook using Power Query, cutting month-end preparation from 6 hours to 90 minutes.

3. Python for data analysis

Enough Python to load, clean and join data with pandas, then repeat the job on a schedule — not software engineering.

Analyst bullet

Automated a monthly reconciliation in Python (pandas), processing 180,000 transaction rows in under 4 minutes and removing 2 days of manual checking.

4. Dashboard building in Power BI or Tableau

The hard part is the data model and the measures; the soft part is choosing what a manager actually needs to see.

BI analyst bullet

Built 6 Power BI dashboards on nightly-refreshed datasets, retiring 22 manual spreadsheet reports for a 45-person sales team.

5. Financial modelling and forecasting

Three-statement or driver-based models, scenario toggles, and assumptions someone else can follow six months later.

FP&A analyst bullet

Built a driver-based 5-year forecast with 3 scenarios for a 40-store retail chain, presented monthly to the finance director.

6. Bookkeeping and month-end close

Double-entry basics, bank and ledger reconciliation, accounts payable and receivable, and a named system you've closed a period in.

Bookkeeper bullet

Closed the books in QuickBooks Online for 3 legal entities each month and cleared a 200-line reconciliation backlog within 6 weeks.

7. Payroll and HRIS administration

Running cycles accurately in a named system, handling starters, leavers and deductions, and keeping records that survive an audit.

Payroll administrator bullet

Processed semi-monthly payroll for 260 employees across 4 states in ADP, with no off-cycle corrections in 9 months.

8. Recruiting operations and ATS use

Moving requisitions through a system, scheduling at volume, keeping candidate records clean and reporting on pipeline stages. If you are building towards HR certification, note that SHRM says the SHRM-CP requires no degree or specific HR experience, while the SHRM-SCP expects at least 3 years of strategic-level HR work — and at least 1,000 hours a year of strategic work to demonstrate it (SHRM, undated).

Talent coordinator bullet

Managed 30 open requisitions in Greenhouse, screened 480 applicants and coordinated 210 interviews across 2 quarters.

9. AWS cloud architecture

Designing and running workloads on named services with attention to cost, availability and access control. AWS says the target candidate for the Certified Solutions Architect – Associate exam has at least 1 year of hands-on experience designing AWS solutions, and 2 or more years before attempting the Professional level (AWS, undated).

Cloud engineer bullet

Migrated 14 on-premises services to AWS (EC2, S3, RDS) with multi-AZ failover, holding unplanned downtime under 30 minutes per quarter.

10. Hardware and OS troubleshooting

Diagnosing and fixing devices, operating systems, printers and accounts at ticket volume. CompTIA A+ is the usual entry credential; CompTIA says it takes two 90-minute exams covering nine domains, with no more than 90 questions each (CompTIA, 2024).

IT support technician bullet

Resolved 55–70 tier-1 tickets a week across Windows 11 and macOS and imaged 120 laptops for a company-wide refresh.

11. Food safety and HACCP compliance

Temperature control, allergen handling, cleaning schedules and written records that pass an unannounced inspection. Name the certificate you hold and the scheme it sits under in your country.

Kitchen manager bullet

Ran daily HACCP checks across 6 critical control points for a 180-cover kitchen and passed 2 unannounced inspections with no critical violations.

12. Security monitoring and vulnerability management

Triaging alerts in a SIEM, running and interpreting scans, and closing findings to a deadline rather than just listing them.

SOC analyst bullet

Triaged SIEM alerts across a 900-endpoint estate and remediated 120 critical Nessus findings inside a 30-day SLA.

13. Project scheduling and delivery

Building a schedule with dependencies, tracking against it, and reporting slippage early. For the PMP, eligibility with a bachelor's degree is 36 months of leading projects in the past 8 years plus 35 hours of project management education; with a high school diploma or associate's degree it is 60 months plus the same 35 hours (University of Texas at Tyler, undated).

Project coordinator bullet

Ran a 9-month, 12-person rollout across 5 sites in Jira and Smartsheet, delivering 4 of 5 milestones on the baseline date.

14. Technical documentation

Writing procedures, release notes and help articles that a stranger can follow, in a real authoring tool with version control.

Technical writer bullet

Rewrote 60 help-centre articles in Confluence and cut repeat "how do I" tickets on those topics by a quarter over 3 months.

15. SEO and web analytics

Technical fixes, keyword and intent research, and reading GA4 or Search Console well enough to say what changed and why.

SEO specialist bullet

Fixed 340 crawl errors flagged in Search Console and grew organic entrances to 25 priority pages by 42% in 6 months.

16. Paid media buying

Structuring accounts, writing and testing creative, and managing spend against a cost-per-result target in a named platform.

Performance marketer bullet

Managed 18 Google Ads campaigns against a fixed monthly budget cap and lowered cost per qualified lead by 27% over 2 quarters.

17. CRM administration

Keeping records, pipeline stages, fields and reports in order — and knowing what you can configure without breaking reporting.

Sales operations bullet

Rebuilt 7 Salesforce pipeline reports and merged 9,000 duplicate records, lifting contact data completeness to 96%.

18. CAD and drafting

Producing drawings or models to standards and tolerances, and coordinating them with other disciplines.

Architectural technician bullet

Produced 45 Revit sheets for a 3-storey office fit-out and resolved 60 clashes against 4 consultant models before tender.

19. EHR charting and clinical documentation

Accurate, timely records in a named system alongside the clinical tasks themselves, plus current licence and life-support certification.

Registered nurse bullet

Charted care for 18–22 patients per shift in Epic, completing all medication administration records before handover.

20. CNC machining and blueprint reading

Setting up and running machines to a drawing, interpreting GD&T symbols, and holding tolerance and scrap targets.

Machinist bullet

Set up and ran 3 Haas CNC mills to drawings toleranced at ±0.001 in, holding scrap below 2% across 12,000 parts.

How to show them on your resume

  1. Mine the ad for keywords. Copy the posting into a blank document and underline every tool, system, certification and procedure. Sort them into: have and can prove, have but rusty, don't have. The first group is your shortlist for this application.
  2. Build the skills section. Put it near the top for technical, clinical, trade and tools-heavy roles; below experience for management and client-facing roles. Keep it to 8–14 hard skills in 2–4 lines, grouped by type. Use the employer's spelling of each tool. Leave out software everyone has, and drop rating bars — they say nothing.
  3. Prove the top 4–6 inside experience bullets. A skill named in a skills list is a claim; the same skill inside a bullet with a task and a number is evidence. Weak: "responsible for reporting in Power BI." Strong: "Built 6 Power BI dashboards on nightly-refreshed data, retiring 22 manual reports."
  4. Put two or three in the summary. Three or four lines at the top, naming your job title, years in the work, and the two or three skills the ad leads with. If the ad opens with SQL and forecasting, so should you.
  5. List certifications and licences with dates and status. Give the full name, the issuing body, and the year gained or renewed. "In progress" and an exam date is fine and honest; an expired licence presented as current is not.
  6. Retailor for each application. Keep one master file with every skill and bullet you own, then cut it down per job: reorder the skills lines, swap 3–5 bullets, adjust the summary. Keep the finished resume to 1 page under 10 years' experience, 2 pages above, at 10–11 pt body text with 0.75–1 inch margins, and save as PDF unless the employer asks for a Word file.

Frequently asked questions

How many hard skills should I list?

Aim for 8–14 in the skills section — enough to cover the ad, few enough that a reader believes all of them. Beyond about 15 the list reads as inventory rather than expertise, and the important ones get lost. Then make sure the 4–6 that matter most also appear inside your experience bullets, because that is where a hiring manager looks for proof. If you have far more skills than that, keep them in a master file and cut down per application rather than pasting everything in.

What's the difference between hard and soft skills, and do I need both?

A hard skill is testable: SQL, payroll processing in ADP, GD&T, HACCP record-keeping, a forklift licence. A soft skill is behavioural — how you communicate, prioritise or handle conflict. You need both, but they go in different places. Hard skills belong in a skills section and in bullets. Soft skills are almost worthless as adjectives in a list; show them through what happened instead — training 4 new starters, chairing a weekly meeting with 3 consultant teams, handling escalations from 12 accounts. Some skills sit in between, like project delivery or technical writing: the tools and methods are hard, the judgement around them is not.

Can I list a skill I've learned but never used at work?

Yes, if you place it honestly. Keep it out of your experience bullets, where it would imply paid use, and put it under a heading that tells the truth: Projects, Training, or Coursework. Describe what you actually built or completed with a number attached — a dashboard on a public dataset, 3 completed labs, a 40-hour course. If the skill is central to the job, expect to be asked to talk it through or do a short exercise, so keep your practice work where you can open it.

Do certifications count as hard skills?

They are evidence of a hard skill, not a substitute for one, so list them in their own section with the issuing body and date. Check the current requirements with the body itself before you plan around them, since they change. For context: AWS reports its Solutions Architect – Associate exam as a scaled score of 100–1,000 with 720 to pass, and 50 scored plus 15 unscored questions (AWS, undated); SHRM publishes global pass rates of 69% for the SHRM-CP and 52% for the SHRM-SCP and requires recertification every three years through 60 professional development credits or a retest (SHRM, undated and 2025).

Should I claim a level, like "advanced Excel"?

Only if you can define it in an interview. Self-assigned levels mean different things to different readers, and "advanced" invites a test. It is stronger to show the level through the work: naming Power Query and a 14-tab model tells a reader more than the word advanced. If an employer's own application form asks you to rate yourself, answer it in their terms and keep the rating consistent with your bullets.

Sources

  1. The University of Texas at TylerPMP Certification Requirements: A Complete Guide
  2. CompTIAWhat Is on the CompTIA A+ (1101/1102) Exam?2024-12-18
  3. CompTIACompTIA A+ Has Two Exams: What You Need to Know2024-11-13
  4. AWS (Amazon Web Services)AWS Certified Solutions Architect - Associate (SAA-C03) - AWS Certification
  5. AWS (Amazon Web Services)AWS Certified Solutions Architect - Associate (SAA-C03) - AWS Certified Solutions Architect - Associate
  6. AWS (Amazon Web Services)AWS Certified Solutions Architect - Professional
  7. SHRMEligibility Criteria - SHRM Certification
  8. SHRMSHRM Certification
  9. SHRMSHRM Certification Handbook2025