System Analyst

What tools did you use when you were developing?

Have you used Kafka/RabbitMQ for stream processing in a project? What exactly did you do?

What basic data quality checks are usually configured?

The resume mentions Kafka — what is it, and have you used it?

Tell about the project at [organization] for DWH development and near real-time analytics of construction objects: what tasks were set, how they were solved, what achievements?

Tell about your experience — what you did on different projects (consulting, [organization], Econsoft, Beeline)?

-- 1. List clients without orders in the last month. -- Structure: -- customers (customer_id, name, registration_date) -- orders (order_id, customer_id, order_date, amount) SELECT DISTINCT c.customer_id, c.name FROM customers c LEFT JOIN orders o ON c.customer_id = o.customer_id and o.order_date >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '1 month' WHERE o.amount IS NULL -- 2. Calculate the share of each subcategory in the total revenue of the category -- sales (product_id, category, subcategory, revenue, sale_date) -- Result needed: category | subcategory | share_of_category

-- 1. List clients without orders in the last month. -- Structure: -- customers (customer_id, name, registration_date) -- orders (order_id, customer_id, order_date, amount) SELECT DISTINCT c.customer_id, c.name FROM customers c LEFT JOIN orders o ON c.customer_id = o.customer_id and o.order_date >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '1 month') WHERE o.amount IS NULL -- 2. Calculate the share of each subcategory in the total revenue of the category -- sales (product_id, category, subcategory, revenue, sale_date) -- Result needed: category | subcategory | share_of_category

Was the data loading itself written directly in Python?

Tell us about setting up CI/CD and containerization in Docker on the project — what exactly did you do?

Can you tell about the approaches to designing data warehouse architecture you have used? At least theoretically.

Do you have experience optimizing in ClickHouse (including data loading)?

Did you work with data quality in any way? Did you use a verification system?

In your team, there were two data engineers involved in implementation, and you were responsible for architecture and requirements — is that correct?

How familiar are you with Data Vault — with object types (Hub, Link, Satellite) and the design approach?

What role did you play in all these projects — as a developer or as an analyst setting requirements for developers?