Business Intelligence Analyst

Business Intelligence Analyst completes the role’s practical duties here and this page includes 20 real tasks to review. The notes highlight what newcomers often overlook and how to get consistency. Each one shows where we found it, and comes with an AI prompt you can copy and use straight away.

20evidenced tasks
20ready prompts
8tools of the trade
15-2051.01O*NET-SOC code
262,440hold this job (US, BLS 2025)
$120,230median pay/yr (US)
Open Business Intelligence Analyst in the interactive atlas →

What it pays

Government survey numbers — not estimates, not ads.

Half of all Data Scientists in the U.S. earn more than $120,230 a year — the middle 80% land between $67,240 and $199,130. About 262,440 people in the U.S. do this work. Figures are for the U.S. occupation group “Data Scientists”. (U.S. Bureau of Labor Statistics survey, published 2025.) In India, Professionals earn about ₹38,298 a month on average — around ₹4.6 lakh a year (government PLFS survey via ILOSTAT, occupation-family figure).
$120,230typical pay / year
262,440people in this work
$199,130+top 10% earn
₹4.6 lakha year in India (family avg)
Think you get this job?Six quick questions on how it really works — with a hint and the reason behind every answer.
Test yourself →

The work, task by task

These are the real jobs-to-be-done, not a wish list. Each task shows where we found it, and the prompt underneath is written for that exact task.

Analysing2
km/h RPM

Create and maintain BI dashboards and reports

+
Build and update the weekly executive dashboard showing sales, churn, and operational KPIs; automate data…
Build and update the weekly executive dashboard showing sales, churn, and operational KPIs; automate data refresh, add drill-down by region and product, validate calculations against source extracts, and publish the dashboard to leadership before Friday 10:00.
The tools that do the workAmazon RedshiftApache Sparkjob descriptionsO*NET

Collect and analyze corporate data

+
Ingest last quarter's transactional and HR feeds, profile and clean the data, run cohort and retention…
Ingest last quarter's transactional and HR feeds, profile and clean the data, run cohort and retention analysis, and deliver a summary report with recommended metric definitions and a validated dataset by Wednesday COB.
The tools that do the workApache HadoopApache Hivejob descriptionsO*NET
Learning1

Improve company operations

+
Map current operational workflows, quantify bottlenecks using throughput and error rates, run root-cause…
Map current operational workflows, quantify bottlenecks using throughput and error rates, run root-cause analysis on the top two pain points, and deliver a prioritized improvement plan with ROI estimates for the operations director by next Monday.
The tools that do the workAmazon Web Services AWSAmazon RedshiftESCOjob descriptions
The daily work17

Present visual data to leadership

+
Create a concise deck of the last quarter’s sales and churn trends with clear visuals, two-slide executive…
Create a concise deck of the last quarter’s sales and churn trends with clear visuals, two-slide executive summary, three recommended actions, and speaker notes for Anna and Marcus before Wednesday’s leadership review.
The tools that do the workApache Sparkjob descriptions

Identify opportunities for process optimization

+
Run a diagnostics review of the order-to-fulfilment workflow, highlight three bottlenecks with supporting…
Run a diagnostics review of the order-to-fulfilment workflow, highlight three bottlenecks with supporting metrics and estimated weekly savings for each, and propose one quick test to run next sprint.
The tools that do the workAlteryxjob descriptions

Develop data models and databases

+
Design the customer 360 data model: list core entities, keys, update cadence, and retention rules, then…
Design the customer 360 data model: list core entities, keys, update cadence, and retention rules, then deliver SQL DDL and a migration plan for the current product and billing tables.
The tools that do the workAmazon Redshiftjob descriptions

Translate stakeholder requirements into analysis solutions

+
Turn Mara and Dev’s interview notes into three analysis options, map required data sources and estimated…
Turn Mara and Dev’s interview notes into three analysis options, map required data sources and estimated effort for each, then recommend the option that answers the top three stakeholder KPIs.
The tools that do the workApache Hivejob descriptions

Report data findings to management

+
Prepare a two-page report of this month’s product usage signals, call out the top five insights with business…
Prepare a two-page report of this month’s product usage signals, call out the top five insights with business impacts and one recommended decision for the C-suite meeting on Friday.
The tools that do the workApache Sparkjob descriptions

Monitor data collection processes

+
Audit the streaming pipelines for data completeness and latency over the last 72 hours, list failing sources…
Audit the streaming pipelines for data completeness and latency over the last 72 hours, list failing sources and suggested fixes, and set an alert threshold to reduce missed records.
The tools that do the workApache Kafkajob descriptions

Identify and analyze industry or geographic trends with business strategy implications.

+
Analyse sales and customer data across North America and Western Europe for the last 24 months, identify…
Analyse sales and customer data across North America and Western Europe for the last 24 months, identify three industry or regional trends that change our market position, quantify revenue impact, and recommend two strategic actions for product, pricing, or channel by next Tuesday.
The tools that do the workApache SparkO*NET

Conduct or coordinate tests to ensure that intelligence is consistent with defined needs.

+
Design and run acceptance tests that validate our weekly intelligence report meets procurement and sales…
Design and run acceptance tests that validate our weekly intelligence report meets procurement and sales needs: define test cases, run comparisons against source data, log discrepancies, and deliver a pass/fail summary with remediation steps by Friday.
The tools that do the workApache HiveO*NET

Maintain library of model documents, templates, or other reusable knowledge assets.

+
Consolidate our approved BI templates, model specs, and dashboards into a single searchable library,…
Consolidate our approved BI templates, model specs, and dashboards into a single searchable library, standardise naming and version notes, and publish access rules so analysts can reuse assets starting Monday.
The tools that do the workAmazon RedshiftO*NET

Create projections for company growth

+
Build three growth projection scenarios for the next three fiscal years using current bookings, churn, and…
Build three growth projection scenarios for the next three fiscal years using current bookings, churn, and pipeline conversion rates, show assumptions, upside/downside drivers, and deliver the forecast model and one-page executive summary by Wednesday.
The tools that do the workApache Sparkjob descriptions

Conduct data quality checks

+
Run data quality checks on customer master and transactions for the last quarter: flag duplicates, missing…
Run data quality checks on customer master and transactions for the last quarter: flag duplicates, missing keys, anomalous amounts, record error rates, and produce a prioritized remediation list for data engineering by Friday noon.
The tools that do the workAlteryxjob descriptions

Manage analytics and metrics

+
Define and maintain the monthly analytics scorecard: select five KPIs, set calculation logic and ownership,…
Define and maintain the monthly analytics scorecard: select five KPIs, set calculation logic and ownership, automate refresh and anomaly alerts, and circulate the first updated scorecard to leadership on the first of next month.
The tools that do the workApache Kafkajob descriptions

Gain knowledge of the industry

+
Map out the competitive landscape for our sector this quarter: gather recent market reports, list top five…
Map out the competitive landscape for our sector this quarter: gather recent market reports, list top five competitors, extract pricing models, customer segments, and emerging tech trends, then summarise gaps we can exploit in one executive brief by Wednesday.
The tools that do the workApache SparkESCO

Contrast industry processes with company operations

+
Compare our operating workflows to standard industry processes: pull current process metrics, identify three…
Compare our operating workflows to standard industry processes: pull current process metrics, identify three major deviation points with root causes, estimate cost or time impact for each, and recommend two corrective changes for operations and one for IT by next Friday.
The tools that do the workAlteryxESCO

Focus analysis on sales

+
Run a sales-focused deep dive: extract last twelve months of transactions, segment by product, region and…
Run a sales-focused deep dive: extract last twelve months of transactions, segment by product, region and rep, highlight top three underperforming combinations with possible causes, and propose two targetable experiments to increase conversion next quarter.
The tools that do the workAmazon RedshiftESCO

Facilitate communication

+
Prepare a stakeholder communication package to align teams: synthesize recent analytic findings into one…
Prepare a stakeholder communication package to align teams: synthesize recent analytic findings into one one-page summary, create three talking points for sales, product and finance, and schedule a 30-minute sync with each lead next week to resolve outstanding questions.
The tools that do the workAdobe AcrobatESCO

Improve revenue

+
Identify revenue improvement opportunities from data: analyse customer lifetime value, churn drivers and…
Identify revenue improvement opportunities from data: analyse customer lifetime value, churn drivers and upsell rates, model three pricing or bundle changes with projected revenue lift and required implementation effort, then present a recommended next-step to the head of revenue by Friday.
The tools that do the workApache HiveESCO

Says who?

These are the pages we read to build this. Open any of them and check us.

The logs, files & records this job keeps

Shared with other careers — the same record means something different in each.

Related careers

Same family of work — each with its own tasks and prompts.

The LLOS Work Atlas is the world's largest evidenced task library — a map of human work, with a ready prompt behind every task. 1,774 careers · every task named by the sources that witnessed it — O*NET, ESCO, real job descriptions, Wikipedia — and the deepest tasks by several at once. And it is honest about limits: where AI cannot help, the map says so.

The rest of the map

Same library, five ways in.

Copyright © LLOS.ai · 2026 — original pedagogy, voice, and design — all rights reserved.
Built on public evidence: O*NET®, ESCO, Wikipedia, U.S. Bureau of Labor Statistics, ILOSTAT. All sources & licenses