👋 Hi there!

To get a better understanding of your work and thinking process, we’ve put together a homework assignment we’d like you to do. It's meant to help us make informed and fair hiring decisions. Feel free to reach out to us ([email protected], telegram: @severenkov) if you have any questions.

We’d love to see your work and get insights into:

• how you approach such a task in general
• on what criteria you base your decisions
• your tech approach for such problems

Please make sure to cover technical and non-technical insights that went into the final solution.

Description

We'd like you to design the first iteration of the Fjor BI:

1. Describe what data do we need for CAC/LTV analysis at Fjor and how it'll be used by Fjor teams.
2. Model the data for effective CAC/LTV analysis, focusing on insights that could inform better marketing decisions and strategies.
3. Outline tech solutions that would enable 1 and 2.

Tech details

At the moment, we're eyeing at the Snowflake, dbt, Metabase/Tableau stack, but feel free to use any technologies you're comfortable with. The goal is not to find the solution, but a solution you believe is right and you're comfortable talking about during further interview stages.

Acceptance criteria

It's worth to mention that we don't expect you to write any code. Your task is only to propose a system and describe it in as much detail as possible (just like you'd pitch it to the company if you were an employee). Just make sure your solution covers all points from the description.

Please don't spend more that 4 hours on the task.

Share your solution with us in any way you like: a document, Miro board, Github repo, a plan email, etc.

We hope you'll enjoy the challenge. Thank you for your time and good luck! 🚀