System Analyst

Are you currently living in Moscow or planning to move to Moscow?

According to what logic, according to what rule will the matching occur?

And the last question. Imagine you recommended a friend for a developer position, but you see that he is not coping with the tasks in this company. What will you do?

How will the data move further?

Case 2: There are two independent data layers — product analytics of user sessions, devices, and advertising sources, and transactional backend of the credit pipeline. You need to develop a schema of relations and tables for a database that will allow collecting unit economics across marketing sources, indicating keys, and demonstrate a matching problem — merging the profile of an anonymous user before authorization with their real ID after receiving credit.

Evaluate your SQL level again (after technical communication issues).

Case 1: Design an event matrix for a credit application. Context: a user goes through fintech onboarding — comes through advertising, registers, fills out a form, passes scoring, receives a decision, signs a contract, and gets money on the card. Task — sketch a logical structure of the event matrix for end-to-end analytics: which events are recorded on the client, and which on the server (frontend/backend) and why, as well as specify critical attributes for key steps.

Where are we sending the event from and to, and how to determine if it is valid (has passed)?

Device ID is only visible when the user is already in the app, and before that, there is an anonymous user coming from advertising. How to connect these two data layers?

From which source did the user come and how much did we earn from each source?

The most important question — where do we send events from and where do we send them?

We send information about an event from our backend to the AppsFlyer server. What conditions do we set to secure data transmission, and how do we validate that the event was sent?

Interested specifically in the sequence of steps in a scenario: what stages occur and how data moves through these stages?

Note that there are two layers: an anonymous user and a real user. Next, you will need to build a report.

Case 5 (replaced): We want to create a new application — a translation service to send translations from one party to another. What should be the architecture of this application? Design the architecture.

Tell us how services interacted between your projects.

1. The developer asks you to hide problems that occur in the application processes because discussing them will only make things worse. What are your actions? Timing: 1 minute

Tell us about how you develop and improve your skills, and how you use neural networks in your work today.

Blitz - 5 questions 2. In your opinion, what is more important: achieving significant goals or following rules and instructions? Timing: 1 minute

Case 3: We are driving traffic from the web to the landing page. The user clicks 'apply for a loan', goes to stores, downloads the app. On first launch, they should see a specific loan product screen with the original UTM tags of the marketing campaign and sources preserved. Design a flow scheme for parameter movement: what methods are called to achieve the goal, expected result — a data flow scheme, stages in text, the scheme should include specific methods and logic for processing and transmitting tags to the analytics system.