Role

Analytics engineer

The job exists because two dashboards disagreed about revenue. What a listing screens for is whether you can make a number mean one thing across a company — which is a political skill as much as a technical one.

An analytics engineer turns raw data into models the rest of the company queries, and owns what each metric means. The deliverable is agreement as much as it is a table.

What most listings require

  • SQL at modeling depth

    What it screens for: Whether you can build a layer other people query, not just answer a question.

    A sentence that proves it"I built the order model every dashboard now reads from; before that four teams each had their own definition of a completed order."

  • dbt or an equivalent

    What it screens for: Whether transformations are versioned, reviewed and tested.

    A sentence that proves it"I moved 60 transformations into dbt with tests on the primary keys; we have not shipped a silent duplicate since."

  • Metric definition

    What it screens for: The core of the job, and the part listings describe worst.

    A sentence that proves it"I wrote the definition of active customer that finance and product both signed off on, and the test that fails if the two queries ever diverge."

  • A BI tool

    What it screens for: Whether the work reaches somebody who decides something.

    A sentence that proves it"I rebuilt our Looker models so a question about churn takes a product manager two clicks instead of a request to me."

What counts as a bonus

  • Experiment analysis

    What it screens for: Whether you can say what a result means and what it does not.

    A sentence that proves it"I analyzed our pricing test and reported that the effect was inside the noise — we did not ship it, which was the right call."

  • Version control and review

    What it screens for: Whether you work like an engineer.

    A sentence that proves it"Every model change goes through a pull request with a sample diff of the affected rows attached."

The requirement nobody writes down

Whether people trust your numbers. The screen behind every question is: has this person ever been the reason a company stopped arguing about a metric?

Where candidates come up short

  • Agreement. Having got two departments to accept one definition is the strongest thing you can show and almost nobody writes it down.
  • Tests on data, as opposed to tests on code.
  • Saying no to a result — evidence of calling a negative outcome honestly.

Related roles

Analytics engineer: questions

What is the one thing analytics engineer listings screen for without writing it down?
Whether people trust your numbers. The screen behind every question is: has this person ever been the reason a company stopped arguing about a metric?
What do candidates for analytics engineer roles most often fail to evidence?
Agreement. Having got two departments to accept one definition is the strongest thing you can show and almost nobody writes it down. Tests on data, as opposed to tests on code. Saying no to a result — evidence of calling a negative outcome honestly.
How do I turn this into something a company can check?
Tell the agent what you actually did, in sentences like the examples on this page. Each becomes a claim carrying that sentence and the date it holds for, and a company matching you against a listing sees the requirement, the claim, and your own words behind it.

Prove it, requirement by requirement.

Write sentences like the ones on this page and each becomes a claim with a date. Then match yourself against a real analytics engineer listing and read what is still unmet — that list is the plan.