Skip to content
beginner Phase 1 · Analyst Role and Data Lifecycle

Analyst Role and Responsibilities

Map what data analysts own versus data scientists and engineers on a team.

30m
0 problems
Topic Progress 0%

Where the Analyst Sits on the Data Team

Where the Analyst Sits on the Data Team

Every data-driven organization builds its analytics capability from three distinct roles: data engineers, data analysts, and data scientists. Confusing these roles is one of the most common sources of friction in real teams, because the boundaries are not always clean and job titles vary across companies. Understanding what each role owns prevents duplicated work, misaligned expectations, and the classic failure mode where an analyst spends 80% of their time cleaning data that an engineer should have cleaned upstream.

Data engineers build and maintain the infrastructure. They design schemas, construct ETL or ELT pipelines, manage data warehouses and lakes, and ensure that data arrives reliably, on time, and in a queryable form. When a dashboard shows stale numbers or a table is missing a column, the engineer is the right partner. Engineers think in terms of systems: throughput, latency, idempotency, and data contracts.

Data analysts turn data into decisions. They write SQL queries, build dashboards, perform ad-hoc investigations, and translate business questions into analytical frameworks. The analyst's primary output is insight delivered to a non-technical audience: a weekly metrics report, a root-cause analysis of a drop in conversion, a recommendation backed by evidence. Analysts think in terms of questions, definitions, and narratives.

Data scientists build predictive models and run controlled experiments. They work on problems where the answer is not in the data yet: forecasting demand, classifying support tickets, optimizing pricing with reinforcement learning. Their output is a model, an experiment result, or a statistical estimate with confidence intervals. Scientists think in terms of distributions, hypotheses, and generalization error.

The analyst sits between the engineer and the scientist, and between the technical team and the business. This positioning is a feature, not a limitation. The analyst is the role that must be bilingual: fluent enough in SQL and statistics to interrogate the data directly, and fluent enough in the business domain to know which questions are worth asking. A team where the analyst cannot write SQL becomes dependent on engineers for every question, and the queue grows until insights arrive weeks late. A team where the analyst cannot frame a business question produces technically correct analyses that answer the wrong thing.

What the Analyst Owns

What the Analyst Owns

Ownership is the clearest way to understand a role. The analyst owns four things, and everything else is support.

1. Metric definitions. The analyst decides what "active user" means, what counts as a "conversion," and how "revenue" is recognized. This is not a clerical task. Two teams using different definitions of the same metric will produce conflicting reports, and the resulting arguments waste more time than any technical bug. The analyst documents definitions, socializes them, and defends them when someone proposes a change that would make historical comparisons impossible.

2. The analytical narrative. Querying data is mechanical. Deciding what the data means is the analyst's job. When revenue drops 12% week-over-week, anyone can produce the chart. The analyst determines whether the drop is real or a tracking artifact, whether it is concentrated in one segment or broad, and whether it correlates with a known event. The deliverable is not a query result; it is a written conclusion with evidence.

3. Self-serve enablement. Analysts build the dashboards, documented data models, and trained stakeholders that allow the business to answer routine questions without filing a ticket. This is leverage. An analyst who answers the same question ten times has failed to scale their impact. The goal is to make the analyst unnecessary for questions that follow a known pattern, freeing them for investigations that require judgment.

4. Data quality advocacy. Analysts are usually the first to notice that numbers look wrong, because they stare at the data daily. They do not fix pipeline bugs, but they file precise reproduction cases: which dashboard, which date range, which filter, what was expected versus observed. The analyst who says "the numbers look off" without specifics forces the engineer to investigate blind.

What the analyst does not own: building production pipelines, deploying models, or making final business decisions. The analyst informs decisions; the decision-maker owns them. This boundary matters because it keeps the analyst credible. An analyst who is seen as advocating for a particular outcome rather than presenting evidence loses trust on both sides.

Collaboration Patterns

Collaboration Patterns

The analyst's work is a series of handoffs, and most collaboration failures happen at the boundaries, not within the work itself.

With stakeholders (product managers, executives, marketers): The stakeholder arrives with a question, often vague: "Why are users churning?" The analyst's first job is not to query. It is to translate. What does "churning" mean operationally? Over what time window? For which cohort? The analyst reframes the question into something testable, proposes an approach, and sets expectations on timeline and confidence. This translation step is where junior analysts struggle most, because it requires domain knowledge and communication skill, not technical skill.

With data engineers: The analyst requests data, schemas, and pipeline changes. The best requests include the business context, the specific fields needed, the grain (one row per what?), and the reason. "I need a table of daily active users by signup cohort, because we are investigating whether the onboarding change in March improved retention" gives an engineer everything needed to build the right thing. "I need user data" gives them nothing.

With data scientists: The analyst hands off questions that require modeling: "We know retention dropped; can you predict which users are at risk?" The scientist hands back findings that the analyst contextualizes: the model flags a segment, and the analyst investigates whether the flag is actionable and whether the segment is large enough to matter.

With other analysts: Peer review of definitions and methodology. When two analysts on the same team calculate "monthly recurring revenue" differently, the problem is not arithmetic; it is that no one documented the definition. Regular metric reviews prevent this.

The pattern across all four: the analyst is the hub of a wheel, not a spoke. Information flows through them, and their value is determined by the quality of the translation at each boundary.

Core Deliverables and Career Progression

Core Deliverables and Career Progression

The analyst's work product falls into four categories, and a healthy role requires all four.

Ad-hoc analysis: A one-time investigation answering a specific question. "Did the pricing change increase revenue per user?" The output is a written analysis with charts, a clear conclusion, and stated limitations. Ad-hoc work is the most visible and the most variable. It is also where the analyst demonstrates judgment.

Recurring reporting: Weekly or monthly metrics packages, dashboards, and automated alerts. This is the least glamorous work and the most valuable. A business that cannot see its current state cannot respond to change. The analyst who builds a reliable weekly metrics report creates more organizational value than the analyst who produces one brilliant deep-dive per quarter.

Exploratory analysis: Open-ended investigation without a predefined question. "What patterns exist in our churned users?" This work generates hypotheses that become ad-hoc analyses or models. It requires the most statistical sophistication and the most tolerance for ambiguity.

Enablement: Documentation, training, data dictionaries, and self-serve tooling. This work is invisible when done well and catastrophic when neglected. New team members take weeks to become productive without a data dictionary; with one, they are productive in days.

Career progression for analysts typically moves from execution to scope. A junior analyst receives well-defined questions and executes them. A senior analyst defines which questions should be asked and builds the systems that answer them repeatedly. A staff or principal analyst shapes how the organization thinks about data: which metrics matter, which investments in data infrastructure are worth it, and how to resolve cross-team definitional conflicts. The technical bar rises at each level, but the communication and judgment bar rises faster. The analysts who advance are not necessarily the best SQL writers; they are the ones whose analyses change decisions.

Practice Problems

0 / 2 solved
Role Boundary Identification

A stakeholder asks you to build a machine learning model to predict which customers will churn next quarter, and also to fix a broken ETL job that loads the daily sales table. Which parts of this request belong to you as a data analyst, and which belong to other roles?

Solution
Neither task belongs to the analyst as primary owner. The broken ETL job is a data engineering task — it involves pipeline infrastructure and data loading, which engineers own. The churn prediction model is a data science task — it requires building and validating a predictive model. The analyst's contribution would be: (1) filing a precise bug report for the ETL issue with reproduction steps, and (2) framing the churn question, defining what 'churn' means operationally, and providing the historical analysis that informs what the model should predict. The analyst should route each request to the right role while offering the contextual support that makes those roles effective.
Ownership Dispute

Two teams report different numbers for 'monthly active users.' Team A says 45,000. Team B says 52,000. Both use the same data warehouse. As the analyst, what do you do?

Solution
First, do not assume one team is wrong. The most common cause of conflicting metrics is different definitions. Investigate: (1) Does 'active' mean logged in, performed a key action, or simply opened the app? (2) Is the time window calendar month or rolling 30 days? (3) Are deactivated or test accounts excluded? (4) Is the count distinct users or total sessions? Once you identify the definitional differences, document a single canonical definition, present both teams with the explanation, and propose adopting the canonical definition going forward. If the discrepancy persists after aligning definitions, then investigate data quality issues with the engineering team.

Quiz

1. A product manager asks you to investigate why user retention dropped after a recent app update. Which role primarily owns this task?

Question 1 options

2. What is the analyst's primary output?

Question 2 options

3. Two teams report different revenue numbers for the same month. What is the most likely cause?

Question 3 options

Flashcards

Question

What are the three core roles on a data team and what does each own?

Answer

Data engineers own infrastructure and pipelines. Data analysts own metric definitions, analytical narratives, and translating data into decisions. Data scientists own predictive models and controlled experiments.

Question

What are the four things a data analyst owns?

Answer

1) Metric definitions, 2) The analytical narrative (what the data means), 3) Self-serve enablement (dashboards, documentation), 4) Data quality advocacy (filing precise bug reports).

Question

What is the analyst's first job when a stakeholder asks a vague question?

Answer

Translate. Reframe the vague question into something testable by defining terms, specifying time windows, and identifying the relevant segment. Do not start querying before the question is well-defined.

Question

What are the four categories of analyst deliverables?

Answer

Ad-hoc analysis (one-time investigations), recurring reporting (dashboards and metrics packages), exploratory analysis (open-ended hypothesis generation), and enablement (documentation, training, self-serve tools).

Revision Notes

Key Takeaways

  • 1. Analysts translate between business questions and data; engineers build infrastructure; scientists build models
  • 2. The analyst owns metric definitions, not just queries
  • 3. Conflicting metrics are usually definitional problems, not data errors
  • 4. The analyst's primary output is a written conclusion with evidence, not a query result
  • 5. Career progression moves from executing defined questions to defining which questions matter

Interview Tips

  • • Be ready to describe a time you translated a vague stakeholder request into a specific analysis
  • • Know the difference between analyst, scientist, and engineer responsibilities with concrete examples
  • • Emphasize communication and judgment over technical tools — interviewers test whether you understand the role's purpose

Cheat Sheet

Cheat Sheet: Analyst Role Boundaries

Role Ownership

  • Data Engineer: Pipelines, schemas, infrastructure, data loading
  • Data Analyst: Metric definitions, insights, dashboards, business translation
  • Data Scientist: Predictive models, experiments, statistical estimates

Analyst's Four Ownerships

  1. Metric definitions (what does 'active' mean?)
  2. Analytical narrative (what does the data mean?)
  3. Self-serve enablement (dashboards, docs, training)
  4. Data quality advocacy (precise bug reports)

Collaboration Partners

  • Stakeholders: Translate vague questions into testable briefs
  • Engineers: Request data with business context and grain
  • Scientists: Hand off predictive questions, contextualize results

Deliverable Types

  • Ad-hoc analysis
  • Recurring reporting
  • Exploratory analysis
  • Enablement

Continue Learning

Before You Start

  • No prerequisites listed.

Next Topics

Related Reading