Economist Sr. Engineering Manager Interview Questions

Economist Case Study

The Economist Group’s core business is our global news subscriptions business. Users subscribe to a weekly online magazine.
They go through various stages:
anonymous visitor ==> registered user ==> subscriber.

All subscription information is stored in upstream transactional systems - Salesforce and Zuora.
Different events can take place - cancellations, re-subscription/renewals.

From time to time, the Group offers various promotions and offers in order to acquire new customers.
The user behaviour data (click stream info) is also available in Google Analytics.

Design a data warehouse and associated data pipelines for the Economist Group so that the analysts and data scientists can report on key metrics. Document the
1. Architecture
2. Data flow, data model
3. Data observability
4. KPIs, metrics
5. Assumptions