Data Analyst

TL;DR

Data Analyst: Developing and supporting ETL/ELT processes for HR automation with an accent on dbt, SQL, and ClickHouse. Focus on designing and optimizing data models, creating dashboards, and ensuring data quality through testing and monitoring.

Локация: Можно удалённо из РФ

Salary: 155 000 ₽

Компания

Voxys is the largest communication center in Russia, helping to improve top companies and projects for over 20 years.

Что делать

• Develop and support ETL/ELT processes using dbt.
• Design and optimize models in the showcase layer.
• Create and maintain dashboards, reports, and visualizations in Apache Superset.
• Write complex SQL queries, including window functions and CTEs.
• Control data quality by writing tests in dbt and monitoring anomalies.
• Document data and processes.

Требования

• Confident knowledge of SQL at an advanced level and experience with T-SQL (SQL Server) and ClickHouse SQL.
• Experience developing on dbt Core or dbt Cloud.
• Understanding of ClickHouse architecture, table engines, and partitioning principles.
• Experience with Superset, including dataset configuration and access management.
• Knowledge of Git.

Хорошо, если есть

• Experience migrating data from SQL Server to ClickHouse.
• Knowledge of pipeline orchestrators (Airflow, Dagster) for launching dbt.
• Python programming skills for custom scripts or dbt operators.
• Experience with MPP engines (Trino).

Культура и преимущества

• Timely "white" salary (fixed salary).
• Official employment and social guarantees from the first day of work.
• Remote work in the Moscow time zone.
• Opportunity to receive health insurance after the trial period (3 months).
• Work in an IT-accredited company.