System Analyst

This is a great role at the intersection of IT and the commercial block. You will build an analytics system that connects business tasks with data and technical solutions — from collecting and formalizing requirements to designing a data model and ensuring its quality.

The role is aimed at building an end-to-end analytics loop: regular data loading from sources into the warehouse, a layer of data marts, and BI dashboards for commercial performance indicators. We work with PostgreSQL and ClickHouse, and use Apache Superset for visualization.

• Collecting and formalizing requirements — interviews, user stories, specifications with acceptance criteria
• Formalizing metrics and business logic — formulas, filters, periods, aggregations, agreeing on common definitions between functions
• Modeling AS-IS / TO-BE processes, identifying gaps and optimization points
• Working with data — SQL (JOIN, GROUP BY, subqueries, window functions), result reconciliation, discrepancy diagnostics
• Designing logical data models — keys, relationships, levels of detail, duplicate control during JOIN and aggregation
• Working with reference data and master data, data historicity
• Participating in DWH/data mart design — understanding layers, facts and dimensions, the "star" schema
• Organizing regular data loading from sources into the warehouse and monitoring its stability
• Data quality control — checks for completeness, uniqueness, acceptable values, reconciliation with the source

• Experience in collecting and formalizing requirements
• Understanding of basic business metrics and the ability to formalize metric definitions
• Confident SQL — JOIN, GROUP BY, subqueries, window functions, ability to reconcile results
• Understanding of data models and the ability to design logical models without duplication during JOIN and aggregation
• Understanding of reference data, master data, and data historicity
• Ability to find data errors and define quality checks
• Understanding of DWH layers and differences from operational databases, experience participating in DWH/data mart projects
• Understanding of facts and dimensions, ability to draw a simple model for a task
• Experience with PostgreSQL and/or ClickHouse
• Understanding of BI dashboard design principles (Apache Superset or similar)