Vacancy: Data Analyst Grade: Middle+ Company: JETLYN Format: Remote Location: Russia Citizenship: #RF Salary Range: from 190,000 to 260,000 rubles net per month Employment terms, format: Labor Code/Sole Proprietor

🟡About the project: We are looking for a Data Analyst to support and develop the corporate data warehouse (DWH). You will be responsible for data completeness and correctness, interact with business units to investigate incidents, and monitor data correction on the source system side.

The team works with a modern stack: Greenplum, ClickHouse, dbt, OpenMetadata, Superset/Forsight, which allows solving interesting tasks of ensuring data quality at scale.

🟡What you will do: Data and Quality Management Monitoring data quality: completeness, consistency, timeliness, validation of business rules. Investigating and resolving incidents related to incorrect or incomplete data. Initiating and controlling data correction in source systems (coordinating with owner teams).

Analytics and Development Researching and analyzing data in source systems to identify root causes of anomalies. Writing complex Ad-Hoc SQL queries for incident investigation and hypothesis validation. Creating and modifying data marts in Greenplum / ClickHouse.

Interaction and Documentation Communicating with business stakeholders: gathering requirements, clarifying calculation logic, presenting results. Documenting data quality rules, metadata, and business logic in OpenMetadata and Confluence. Managing tasks in Jira: estimation, decomposition, tracking correction status.

‼️Mandatory candidate requirements

SQL (advanced level) Proficient use of: JOIN, window functions, CTE, subqueries, aggregation, query optimization. Experience with DWH Understanding of warehouse architecture, layers (ODS, EDW, Data Marts), modeling principles. Data Quality / Data Analysis Experience in anomaly detection, data validation, incident investigation. Ability to formalize business rules, describe specifications, work with metadata. Experience with Jira, Confluence, data visualization tools. Experience with Greenplum or PostgreSQL (MPP architecture, distributed queries). Experience with ClickHouse (optimization for analytical workloads).

Will be an advantage: ✅ Experience with dbt (data transformation, testing, documentation). ✅ Practical use of OpenMetadata or similar tools (Data Catalog, lineage). ✅ Visualization skills in Apache Superset or Forsight. ✅ Understanding of ETL/ELT processes and experience interacting with data engineers.