Intermediate 6 topic areas 68+ exercises

Analytics Engineer

Analytics engineers build the data models and semantic layers that power business intelligence, acting as translators between raw data pipelines and the analysts and executives who consume them. Their English must be precise enough to write data contracts and clear enough to explain model logic to non-technical stakeholders. This path covers the vocabulary, writing, and communication patterns unique to the analytics engineering role.

Topics covered

  • dbt & data modelling
  • Semantic layers
  • Data contracts
  • BI stakeholder communication
  • Data quality & testing
  • Lineage documentation

Vocabulary spotlight

4 terms every Analytics Engineer should know in English:

data contract n.

A formal agreement on the schema, quality rules, and SLAs for a data asset shared between producers and consumers

"We published a data contract for the orders table so downstream teams know what to expect."
grain n.

The level of detail represented by a single row in a data model

"Before we join these tables, confirm the grain — is it one row per order or per line item?"
mart n.

A purpose-built data model designed for a specific business domain or team

"The finance mart exposes pre-aggregated revenue figures so analysts don't need to write complex SQL."
lineage n.

The documented chain of transformations from raw source data to a final model

"The lineage graph shows that this revenue figure traces back to three source systems."
Open full glossary →

📚 Vocabulary Reference

Key terms organised by category for Analytics Engineers:

dbt & Modelling

modelmartgrainstaging layerintermediate modelfinal modelmaterialisationincremental modelsnapshotseed

Data Contracts & Quality

data contractschemaSLAdata quality testfreshness checknullabilityuniqueness constraintanomaly detectionbreaking changedeprecation

Semantic Layer & BI

semantic layermetricdimensionmeasureslice and dicedashboarddata cataloguebusiness glossarycertified datasetself-serve analytics

Lineage & Governance

lineageupstreamdownstreamsource systemtransformationdata ownerstewardaccess controlPIIdata mesh
Study full vocabulary modules →

Recommended exercises

Real-world scenarios you'll practise

  • Writing a data contract for a shared mart and presenting it in a data governance review.
  • Explaining dbt model grain and lineage to a business analyst who needs to trust the numbers.
  • Communicating a breaking schema change to downstream consumers — proposing a migration timeline and deprecation notice.
  • Presenting data quality test failures to stakeholders and recommending remediation steps.

Recommended reading

Explore another role

⚡ Developer Productivity Engineer

Open path →

Frequently Asked Questions

What English skills do Analytics Engineers most need to improve?+

Analytics Engineers most commonly need to improve: technical vocabulary (the correct English terms for domain concepts), collocation accuracy (using the right verb for each action), written communication (bug reports, PR descriptions, technical docs), and spoken communication for standups, code reviews, and stakeholder meetings.

How long does the Analytics Engineer learning path take?+

The Analytics Engineer learning path contains 20–40 hours of material studied comprehensively. Most learners focus on the highest-priority modules first and return to the rest over time. Spending 30 minutes per day for 4–6 weeks produces noticeable improvement in workplace English.

What vocabulary should a Analytics Engineer prioritise first?+

Start with the vocabulary that appears most in your daily work — terms you read in documentation, use in commit messages, and hear in meetings. The Analytics Engineer path begins with the most frequent vocabulary clusters before moving to advanced communication patterns.

Are there interview exercises for Analytics Engineer roles?+

Yes. The Analytics Engineer path includes role-specific interview question modules with model answers and key phrases — the actual questions interviewers ask and the vocabulary needed to answer them fluently. There is also a dedicated Interview Practice hub for general interview skills.

Does this path include pronunciation help?+

Yes. The path links to pronunciation exercises for the technical terms most commonly mispronounced in this domain. The Pronunciation hub includes drills for acronyms, silent letters, word stress, and minimal pairs — all in IT context.

What are the most common English mistakes Analytics Engineers make?+

The most common mistakes: incorrect collocations (using the wrong verb with a technical noun), false friends from L1, tense errors when narrating past incidents or walkthroughs, and using overly formal or overly casual register in written communication.

How do I improve my English for code reviews?+

Learn the standard code review collocations: approve a PR, request changes, leave a nit, address feedback, block a merge, resolve a conversation. Use hedging language for suggestions: "This might be cleaner as…", "Have you considered…?". The Collocations section includes a dedicated Code Review set.

Can I use this path alongside my daily work?+

Yes — the path is designed for working professionals. Each exercise set takes 10–15 minutes. The most effective approach is to study a vocabulary module before a meeting or task where you'll use that vocabulary, then practise immediately after. Context-linked practice produces much faster retention.

Is the content free?+

Yes, completely free. No registration required, no payment, no time limit. All vocabulary modules, exercises, glossary entries, and learning path guides are open access.

How do I track my progress through this path?+

Progress is tracked in your browser's local storage — completed exercise sets are marked with a checkmark when you return. No account is needed. You can bookmark specific modules and use the exercises overview to see which sets you've completed.