Country or region and language

    Choose your country or region and your language.

    Suggested for you

      All countries and regions

        Choose your character

        It shows in the top bar and on your profile. Change it any time.

        Analytics engineer

        SQL and dbt models, tests, warehouse design and trusted metrics.

        Speak or type. Every round ends with feedback linked to your own words.

        These fictional companies give your interview a team and business context. Your choice changes the industry, product, and questions. A job ad uses the real company's name.

        Your interview level

        Practice company

        Your practice loop

        This suggested order covers common rounds for the role. Employers change the sequence. Finish the rounds for one combined verdict.

        Analytics engineer loop

        A screen and introduction, dbt tests, a warehouse fanout task, a star schema and a cohort query, then a metric definition call, fit, a SQL review, a panel and the offer.

        Rounds
        11
        In all
        5 h 22 min

        Screen2 rounds · 37 min

        1. Round 1 · Phone screenAnalytics engineer screen: your toolsStart 25 min
        2. Round 2 · IntroductionAnalytics engineer introduction: work you are proud of12 min

        Technical4 rounds · 2 h 5 min

        1. Round 3 · PipelinesSlate Service: Accepted-value tests30 min
        2. Round 4 · SQLFanout in a finished report30 min
        3. Round 5 · Data modelingOrders, returns and a star schema30 min
        4. Round 6 · SQLMature customer retention cohorts35 min

        Fit2 rounds · 1 h

        1. Round 7 · Situational judgmentData modeling: two meanings of one status25 min
        2. Round 8 · BehavioralAnalytics engineer: a mistake and its repair35 min

        Final rounds3 rounds · 1 h 40 min

        1. Round 9 · Take-home reviewA SQL take-home review35 min
        2. Round 10 · PanelAnalytics engineer panel: quality against speed50 min
        3. Round 11 · OfferAnalytics engineer offer: what you will own15 min

        Screen2 round types

        Technical3 round types

        Fit2 round types

        Final rounds3 round types

        Presentation or take-home review

        Bring nonconfidential prepared work or describe a fictional example and defend it.

        11 scenarios

        Panel or final round

        Respond to three named interviewers with different concerns and voices.

        21 scenarios

        Salary and offer conversation

        Clarify written terms and practice a request without invented pay benchmarks.

        21 scenarios

        Preparation

        Each problem includes lesson links and a junior, mid, and senior rubric. Presentation practice uses work you describe in the shared notes. Keep personal and employer information out of your answers.

        Other interview types

        Interview Hub access

        The Interview Hub is included in All Access. Choose a plan or sign in to your account to continue.

        View plansSign in or join

        Your Work Gym account

        Save your progress and pick up on another device. Your browser's progress comes with you.

        or

        You can keep practicing without an account.

        Help and feedback

        Ask a question, tell us what is not working, or share an idea. We reply by email.

        What is it about?

        We use it only to reply to you.