Career Growth & Skills

What Does a Business Analyst Actually Do Day to Day?

A look at the meetings, requirements documents, SQL queries and dashboards that fill a business analyst's week, and how to tell if the work fits you.

Featured image for "What Does a Business Analyst Actually Do Day to Day?"

A business analyst sits between the people who need something changed and the people who build or approve the change. Day to day that means interviewing staff about how work actually gets done, turning what you hear into written requirements and process diagrams, pulling data to test whether the problem is real, and presenting recommendations to managers who will fund or kill the idea.

The title covers a wide range. In some companies it is close to project delivery and software requirements; in others it is reporting and dashboards. The core skill is the same: asking precise questions and writing down the answers in a way other people can act on.

What the Job Involves Day to Day

Expect a week built from recurring blocks of work rather than one big project task.

  • Running requirements sessions and writing up what was said. You book 45 minutes with a claims processor, a warehouse supervisor or a finance lead, walk through how they do a task today, and write it up the same day. The U.S. Bureau of Labor Statistics (2025) lists interviewing personnel and conducting onsite observations as standard duties for management analysts, and in practice that observation is often a screen-share of someone doing their job while you take notes.
  • Writing user stories and acceptance criteria in a tracker. Jira and Azure DevOps are the two tools you are most likely to be given. You write the story, attach the mockup, define what "done" looks like, and then defend it in a backlog refinement meeting when a developer says the edge case is not covered.
  • Documenting process flows. Current-state and future-state diagrams in Microsoft Visio, Lucidchart or Miro, usually with a swimlane per department so the handoffs are visible.
  • Querying and reconciling data. Writing SELECT statements in SQL to check whether the "we get 200 duplicates a week" claim holds up, cleaning the extract in Excel with pivot tables and lookups, and building or maintaining reports in Power BI or Tableau. ONET lists business analyst as an alternate title for business intelligence analysts, whose tasks include generating standard or custom reports summarizing business, financial or economic data and maintaining business intelligence tools, databases and dashboards (CareerOneStop / ONET OnLine, undated).
  • Writing requirements documents and keeping them current in Confluence or SharePoint, including a traceability matrix that maps each requirement to a test case.
  • User acceptance testing. Writing test scripts, sitting with business users while they run them, logging defects, and deciding which ones block release.
  • Presenting recommendations. The Bureau of Labor Statistics (2025) describes analysts developing solutions and making recommendations to management through presentations or written reports — usually a short PowerPoint deck with the options, the cost, and the one you recommend.

Meeting load is heavy. On a delivery team you may spend half the day in stand-ups, refinement, stakeholder calls and demos, and the other half writing.

Who Thrives in This Role

The Bureau of Labor Statistics (2025) lists analytical, communication, interpersonal, problem-solving and time-management skills as important qualities for management analysts. In day-to-day terms that looks like this:

  • You are comfortable interrupting a senior manager mid-sentence to ask "when you say customer, do you mean the account holder or the person who called?" — ambiguity in a requirement becomes a defect later.
  • You can write a two-page summary of a 90-minute workshop that the attendees agree is accurate, without padding it.
  • You will open the data and check a claim yourself rather than repeating it, which means writing a SQL query or building a pivot table before you write the business case.
  • You can hold a neutral position when two departments want opposite things and still produce a single recommendation.
  • You tolerate rewriting the same requirement three times as scope shifts, without treating it as wasted work.
  • You keep your own backlog in order across three or four concurrent initiatives, because nobody will sequence your week for you.
  • You can present to a room that includes a developer who wants detail and a director who wants one slide, and satisfy both.
  • You are willing to sit through user acceptance testing with someone who is slow, frustrated and has no interest in your project.

Typical Career Path and Advancement

Titles vary by employer, and in consulting firms the ladder moves faster and with more travel than in corporate in-house teams. A common progression:

  1. Years 0–2 — Junior Business Analyst, Associate Business Analyst, Business Systems Analyst or Reporting Analyst. You take requirements that someone else scoped, write stories, maintain dashboards, run test scripts, and take the notes in workshops you do not lead. A bachelor's degree is the typical entry-level education for management analysts (U.S. Bureau of Labor Statistics, 2025).
  2. Years 2–5 — Business Analyst. You own a product area or a workstream end to end: you run the elicitation sessions, write the business case, and present to a steering group. The Bureau of Labor Statistics (2025) puts typical related work experience for management analysts at less than five years, which is roughly where this band sits. This is also the window for the Certification of Capability in Business Analysis, which IIBA (undated) describes as being for practitioners with two to three years of experience and requires 3,750 work-history hours within the last seven years.
  3. Years 5–8 — Senior Business Analyst, Lead Business Analyst, Product Owner or Business Architect. You set the analysis approach for a programme, review other analysts' documentation, and are brought in early when the problem is still vague. IIBA's CBAP recognizes professionals who lead and have over five years of business analysis experience and requires 7,500 hours in the last ten years (Adaptive US, summarizing IIBA's certification framework, undated).
  4. Years 8+ — Principal Analyst, BA Practice Manager, Product Manager, Programme Manager or Director. The Bureau of Labor Statistics (2025) notes that senior-level analysts may supervise teams, become partners in a consulting firm, or move into management positions at non-consulting organizations.

Two common sideways moves: into product management, if you enjoyed owning the backlog more than the documentation, and into data analytics or business intelligence, if the SQL and dashboard half of the job was the part you liked.

Salary and Demand Snapshot

No single federal occupation is labeled "business analyst." The closest federal match for the consulting-style role is management analysts, and ONET also lists business analyst as an alternate title for business intelligence analysts (CareerOneStop / ONET OnLine, undated). Pay is usually a base salary, sometimes with an annual bonus; consulting firms may add utilization or performance bonuses.

MeasureFigureSource and year
Entry level (10th percentile, management analysts)Less than $60,640 per yearU.S. Bureau of Labor Statistics, May 2025
25th percentile$77,950 per yearCareerOneStop national wage table, undated
Median$101,860 per year, or $48.97 per hourU.S. Bureau of Labor Statistics, May 2025
Experienced (75th percentile)$133,370 per yearCareerOneStop national wage table, undated
Experienced (90th percentile)More than $171,640 per yearU.S. Bureau of Labor Statistics, May 2025
Reported average for the title "Business Analyst"$98,662 per year, about $47.43 per hourZipRecruiter, October 2026
Self-reported median total pay$108,232, with a range of $85,319 to $138,712, from 130,924 salariesGlassdoor, undated
Whole business and financial operations group, for comparison$82,660 medianU.S. Bureau of Labor Statistics, May 2025
Projected employment growth10 percent from 2025 to 2035, "much faster than average"U.S. Bureau of Labor Statistics, 2025

These are national figures. Pay varies substantially by state, metro area, industry and employer size, and the Glassdoor and ZipRecruiter numbers are self-reported rather than survey-based. Check the BLS Occupational Employment and Wage Statistics tables for your state and metro, and your state labor department's wage data, before you anchor on any number.

How to Get Started

  1. Confirm the baseline credential, which is usually a bachelor's degree. The Bureau of Labor Statistics (2025) gives a bachelor's as typical entry-level education for management analysts, and CareerOneStop (undated) notes most business intelligence analyst positions require a bachelor's degree with many holders also having a master's. Business administration, finance, information systems, economics and accounting all map cleanly; so does any degree plus demonstrable analysis work.
  2. Take the Entry Certificate in Business Analysis (ECBA) if you have no BA job history yet. IIBA (undated) states the ECBA has no specific eligibility or work-experience requirement to sit the exam — you agree to IIBA's Code of Ethical Conduct and certification terms. Allow roughly 2–4 months of part-time study. The Bureau of Labor Statistics (2025) notes certification is not required for management analysts but may give jobseekers a competitive advantage.
  3. Build a three-artifact portfolio over 6–10 weeks. Pick a process you actually know — a volunteer group's intake form, your employer's expense approvals — and produce a current-state swimlane diagram in Lucidchart or Visio, a short requirements document with numbered requirements and acceptance criteria, and a Power BI or Tableau dashboard built from a public dataset. These three files answer the question most hiring managers ask: can you write?
  4. Learn enough SQL to be dangerous in 4–8 weeks. SELECT, WHERE, JOIN, GROUP BY and basic aggregation cover most of what the job demands. Pair it with Excel pivot tables and lookups.
  5. Target an adjacent entry title if a straight BA role is out of reach. Reporting Analyst, Business Systems Analyst, Operations Analyst, Project Coordinator and Data Analyst all generate the kind of experience that counts, and the Bureau of Labor Statistics (2025) notes work experience in a related occupation — typically less than five years — is part of the usual route in.
  6. Volunteer for elicitation and documentation in your current job. Ask to take minutes in a requirements workshop, write the test script for the next system change, or own the process map. These hours are what you will later count toward CCBA or CBAP.
  7. Plan one experience-based certification for years 3–5. The PMI Professional in Business Analysis requires, for candidates with a bachelor's degree, at least 36 months of unique nonoverlapping professional business analysis experience plus 35 contact hours of business analysis education; candidates with only a secondary degree need 60 months (Project Management Institute, undated).

Is It Right for You? Self-Check

Answer each one yes or no.

  • Can you hold a bachelor's degree or be on track for one, since that is the typical entry-level education for management analysts (U.S. Bureau of Labor Statistics, 2025)?
  • Are you willing to spend 3–4 hours of a typical day in meetings you did not call?
  • Do you want to write for a living — requirements documents, user stories, test scripts, summary emails — most days?
  • Will you learn SQL to the point of writing your own joins and group-bys, rather than asking someone else to pull every extract?
  • Can you accept that a developer or a director, not you, makes the final call on what gets built?
  • Are you comfortable telling a stakeholder their requested feature does not match the data you found?
  • Can you keep three or four initiatives moving at once without a manager sequencing your week?
  • Are you prepared to log 3,750 hours of business analysis work within seven years if you want IIBA's CCBA (IIBA, undated), or 36 months of experience for PMI-PBA (Project Management Institute, undated)?
  • If the role is consulting-based, can you travel to client sites and conduct onsite observations (U.S. Bureau of Labor Statistics, 2025)?

Six or more yes answers suggests a good fit. If you said no to the writing and meetings items, look at data analyst or business intelligence roles instead, where the balance tips toward building and querying.

Frequently asked questions

Do I need to know how to code to be a business analyst?

Programming is rarely a requirement, but SQL usually is — you will be expected to pull and check data yourself rather than queue a request. Expect to use Excel heavily, plus a visualization tool such as Power BI or Tableau. If a posting asks for Python or R, it is leaning toward the business intelligence or data analyst end of the spectrum.ersatz

How is a business analyst different from a project manager?

The split is usually what versus when. You define the problem, the requirements and the acceptance criteria; the project manager owns the schedule, budget and resourcing. In smaller organizations one person does both, which is worth checking in the interview before you accept.

Is certification worth it before my first business analyst job?

The Bureau of Labor Statistics (2025) notes credentials are not required for management analysts but may give jobseekers a competitive advantage. The ECBA is the only IIBA core certification you can sit without a work-history requirement (IIBA, undated), so it is the realistic option pre-hire. Pair it with portfolio artifacts, because hiring managers tend to read the documents you wrote before they read your certificate line.

What does the PMI-PBA exam actually test?

It runs 200 questions over 240 minutes across five domains: Needs Assessment at 18 percent, Planning at 22 percent, Analysis at 35 percent, Traceability and Monitoring at 15 percent, and Evaluation at 10 percent (Project Management Institute, undated). The weighting tells you where the profession places its emphasis — elicitation and analysis over documentation for its own sake.

Which industries hire the most business analysts?

Financial services, healthcare, insurance, government contracting, retail and software all run large analyst functions, and consulting firms hire in cohorts. The industry changes the vocabulary and the regulatory load more than the method — claims adjudication rules in insurance, revenue cycle in healthcare. Pick one domain and go deep; domain knowledge is what moves you from analyst to senior analyst faster than tooling does.

Sources

  1. U.S. Bureau of Labor Statistics — Management Analysts : Occupational Outlook Handbook (2025)
  2. U.S. Bureau of Labor Statistics — Business and Financial Occupations : Occupational Outlook Handbook (2025)

Written by

Lena Vostrikova

Lena writes a running column on career pivots, burnout, and the strange math of figuring out what to do next. She favors first-person stories over tidy advice lists.