We use technical cookies and Zorky's de-identified visit log. Yandex Metrica (data is stored on servers in Russia) runs only with your consent. We never sell data. More about cookies and statistics.
Zorky is in test mode — everything is free. Jobs and company pages are open to everyone; links to postings and your personal feed open after you sign up. Sign up →

Data Warehouse: market

Data as of November 19, 2026: 442 open Data Warehouse jobs, 39% remote among jobs that state a work format; median advertised salary $7,880/mo (from 52 postings that state a salary). Source: Zorky, updated daily.

Data Warehouse Engineer — specialisation in cloud DWH (Snowflake/BigQuery/Redshift/ClickHouse). A Data Engineer sub-segment with focus on DWH modelling + dbt + cloud data platforms. A premium niche thanks to cloud-DWH expertise. Role family: Snowflake Engineer (cloud-DWH dominator — schema design + dbt + cost optimisation), BigQuery Engineer (Google Cloud data stack), ClickHouse Engineer, Redshift Engineer (AWS legacy), Data Warehouse Architect (modeling specialist — Kimball/Data Vault). Stack: SQL at mastery level (must — window functions, recursive CTE, query optimisation, partition pruning, materialised views), Snowflake (cloud premium — Tasks, Streams, Time Travel, micro-partitions, Snowpipe ingestion), BigQuery (GCP — slot-based pricing, BQML for in-DB ML), ClickHouse (OLAP dominator in CIS — ReplicatedMergeTree, distributed engines, materialised views), Redshift (AWS legacy — distkey/sortkey), Greenplum (CIS enterprise), dbt (transform layer standard + dbt-snowflake / dbt-bigquery / dbt-clickhouse adapters), Apache Airflow for ingestion orchestration, Looker/Mode/Metabase/Superset/Yandex DataLens for BI on DWH. Top stack: snowflake, cloud, sql, python, dbt. Among jobs with a stated work format, 39% are remote. Senior Snowflake/BigQuery — premium 10-15% over Senior Data Engineer for the cloud-DWH speciality.

Data as of:

Key numbers for the Data Warehouse market: open jobs, median salary, observed talent pool and remote share.

442
open jobs — by job title, reposts merged
$7,880
median $/mo
39%
remote

The Data Warehouse market currently has 442 open roles, 385 of them freshly observed. Median salary $7,880/mo.

Among jobs with a stated work format, 39% are remote. Work is fully cloud-based. Russian product companies — hybrid or remote. Sber — more often office. International cloud-DWH SaaS (Snowflake/BigQuery/dbt Labs) — full-remote.

⚠ salary known for 52 of 442 jobs; remote share from 362 with a stated format; 385 counted as fresh observations; trend and hiring difficulty are not shown

Timeline: postings and sources

How many Data Warehouse postings appeared each week since Jun 1, and from how many sources. The lower chart separates market growth from coverage growth: a jump in the week new sources were connected means we started seeing more, not that the market grew.

New postings per week

Chart data
New postings per week. Block data table. A missing value is not zero; units and sample are stated in the metric description.
PeriodNew postings per week
2026-06-0132
2026-06-0829
2026-06-1538
2026-06-2289
2026-06-2988
2026-07-0661
2026-07-1375
2026-07-2088
2026-07-2769
2026-08-0345
2026-08-1021
2026-08-1727
2026-08-2437
2026-08-3141
2026-09-0737
2026-09-1434
2026-09-2170
2026-09-2891
2026-10-0594
2026-10-12200
2026-10-1992
2026-10-2693
2026-11-0291
2026-11-09124

Active sources per week

Sources over the period: 100. ▲ — a week with a large batch of new sources.

Chart data
Active sources per week. Block data table. A missing value is not zero; units and sample are stated in the metric description.
PeriodActive sources
2026-06-017
2026-06-089
2026-06-1511
2026-06-2220
2026-06-2916
2026-07-0619
2026-07-1323
2026-07-2024
2026-07-2722
2026-08-0321
2026-08-1012
2026-08-1710
2026-08-2414
2026-08-3119
2026-09-0714
2026-09-1415
2026-09-2129
2026-09-2824
2026-10-0524
2026-10-1233
2026-10-1931
2026-10-2630
2026-11-0231
2026-11-0937
New sources connected: Jun 22 +13 · Jun 29 +6 · Jul 6 +8 · Jul 13 +6 · Jul 20 +8 · all weeks (21) in the table
WeekNew sourcesNew postings
Jun 8+329
Jun 15+338
Jun 22+1389
Jun 29+688
Jul 6+861
Jul 13+675
Jul 20+888
Jul 27+569
Aug 3+345
Aug 17+127
Aug 24+237
Aug 31+341
Sep 7+137
Sep 14+334
Sep 21+570
Oct 5+594
Oct 12+5200
Oct 19+392
Oct 26+393
Nov 2+491
Nov 9+3124

The current week is not over yet and is not shown: an incomplete week would look like a drop.

Week = posting first-seen date, all statuses; postings are selected by the same rule as this page's counter. Sources are distinct collection channels; their names are not published.

Chart data
Timeline: postings and sources — Data Warehouse. Block data table. A missing value is not zero; units and sample are stated in the metric description.
WeekNew postings per weekActive sources
2026-06-01327
2026-06-08299
2026-06-153811
2026-06-228920
2026-06-298816
2026-07-066119
2026-07-137523
2026-07-208824
2026-07-276922
2026-08-034521
2026-08-102112
2026-08-172710
2026-08-243714
2026-08-314119
2026-09-073714
2026-09-143415
2026-09-217029
2026-09-289124
2026-10-059424
2026-10-1220033
2026-10-199231
2026-10-269330
2026-11-029131
2026-11-0912437

Salaries over time

Median Data Warehouse salary per week, USD per month.

Median salary, USD per month

Chart data
Median salary, USD per month. Block data table. A missing value is not zero; units and sample are stated in the metric description.
PeriodMedianPostings with a salary per week (n)
2026-10-127,61813
2026-10-196,31213
2026-10-268,14318
2026-11-029,58311
2026-11-096,37519

The series starts on Oct 12: there is no data before that.

Postings with a salary per week (n)

Only postings with a USD salary and a known period (month or year), $500–$50,000 per month. Weeks with fewer than 10 such postings are left blank — that means no data, not zero.

Chart data
Salaries over time — Data Warehouse. Block data table. A missing value is not zero; units and sample are stated in the metric description.
WeekMedian
2026-06-01—
2026-06-08—
2026-06-15—
2026-06-22—
2026-06-29—
2026-07-06—
2026-07-13—
2026-07-20—
2026-07-27—
2026-08-03—
2026-08-10—
2026-08-17—
2026-08-24—
2026-08-31—
2026-09-07—
2026-09-14—
2026-09-21—
2026-09-28—
2026-10-05—
2026-10-127,618
2026-10-196,312
2026-10-268,143
2026-11-029,583
2026-11-096,375

Remote work over time

Share of Data Warehouse postings offering fully remote work, per week.

Remote postings, %

Chart data
Remote postings, %. Block data table. A missing value is not zero; units and sample are stated in the metric description.
PeriodRemote
2026-06-0172
2026-06-0842.9
2026-06-1558.8
2026-06-2252.4
2026-06-2952.8
2026-07-0648.4
2026-07-1350
2026-07-2068.7
2026-07-2775
2026-08-0323.7
2026-08-1013.3
2026-08-1715.4
2026-08-2440
2026-08-3131.4
2026-09-0725.8
2026-09-1426.9
2026-09-2121.3
2026-09-2849.3
2026-10-0532.9
2026-10-1236.4
2026-10-1927.6
2026-10-2650
2026-11-0242.9
2026-11-0929.6

The share is among postings that state a format (remote, hybrid, office). Weeks with fewer than 10 such postings are left blank.

Chart data
Remote work over time — Data Warehouse. Block data table. A missing value is not zero; units and sample are stated in the metric description.
WeekRemote
2026-06-0172
2026-06-0842.9
2026-06-1558.8
2026-06-2252.4
2026-06-2952.8
2026-07-0648.4
2026-07-1350
2026-07-2068.7
2026-07-2775
2026-08-0323.7
2026-08-1013.3
2026-08-1715.4
2026-08-2440
2026-08-3131.4
2026-09-0725.8
2026-09-1426.9
2026-09-2121.3
2026-09-2849.3
2026-10-0532.9
2026-10-1236.4
2026-10-1927.6
2026-10-2650
2026-11-0242.9
2026-11-0929.6

Technologies over time

How the share of Data Warehouse postings mentioning each of the top technologies changed.

Postings mentioning the technology, %

Chart data
Postings mentioning the technology, %. Block data table. A missing value is not zero; units and sample are stated in the metric description.
PeriodSnowflakeSQLcloud
2026-08-1780.811.534.6
2026-08-2474.322.922.9
2026-08-3172.517.525
2026-09-0776.517.629.4
2026-09-1464.538.716.1
2026-09-2176.222.231.7
2026-09-285626.259.5
2026-10-0570.849.447.2
2026-10-1275.334.343.3
2026-10-1978.765.242.7
2026-10-2677.460.244.1
2026-11-0272.158.152.3
2026-11-0971.948.842.1

The series starts on Aug 17: there is no data before that.

Up to 5 on the chart:

Share among postings with a tagged stack; the series starts on Aug 10: earlier stack tags were assigned differently. Weeks with fewer than 20 tagged postings are left blank.

Chart data
Technologies over time — Data Warehouse. Block data table. A missing value is not zero; units and sample are stated in the metric description.
WeekSnowflakeSQLcloudPythondbt
2026-08-10—————
2026-08-1780.811.534.63.87.7
2026-08-2474.322.922.928.62.9
2026-08-3172.517.5251015
2026-09-0776.517.629.411.82.9
2026-09-1464.538.716.119.46.5
2026-09-2176.222.231.731.719
2026-09-285626.259.529.814.3
2026-10-0570.849.447.242.716.9
2026-10-1275.334.343.320.216.9
2026-10-1978.765.242.744.940.4
2026-10-2677.460.244.148.432.3
2026-11-0272.158.152.352.340.7
2026-11-0971.948.842.137.233.1

Countries over time

How the share of Data Warehouse postings in each of the top countries changed, per week.

Postings in the country, %

Chart data
Postings in the country, %. Block data table. A missing value is not zero; units and sample are stated in the metric description.
PeriodPolandUSAUK
2026-06-0156.228.10
2026-06-0827.637.93.4
2026-06-1543.218.98.1
2026-06-2263.212.61.1
2026-06-2937.934.53.4
2026-07-0617.951.80
2026-07-1324.631.11.6
2026-07-2055.214.911.5
2026-07-2765.55.212.1
2026-08-0317.112.222
2026-08-10102040
2026-08-1713.69.145.5
2026-08-242517.928.6
2026-08-3111.113.938.9
2026-09-076.713.336.7
2026-09-147.429.618.5
2026-09-2114.3258.9
2026-09-2818.615.17
2026-10-0537.28.19.3
2026-10-1223.419.310.3
2026-10-1942.715.94.9
2026-10-2639.814.810.2
2026-11-0227.725.36
2026-11-0923.314.68.7
Up to 5 on the chart:

Share among postings with a known country; the chart shows the five countries with the most postings over six months. Weeks with fewer than 20 postings with a known country are left blank. A rising share can mean a newly connected source in that country rather than market growth.

Chart data
Countries over time — Data Warehouse. Block data table. A missing value is not zero; units and sample are stated in the metric description.
WeekPolandUSAIndiaUKAustralia
2026-06-0156.228.16.200
2026-06-0827.637.917.23.40
2026-06-1543.218.95.48.12.7
2026-06-2263.212.681.11.1
2026-06-2937.934.55.73.42.3
2026-07-0617.951.816.100
2026-07-1324.631.121.31.63.3
2026-07-2055.214.96.911.53.4
2026-07-2765.55.23.412.13.4
2026-08-0317.112.219.5224.9
2026-08-101020104015
2026-08-1713.69.118.245.59.1
2026-08-242517.917.928.63.6
2026-08-3111.113.916.738.911.1
2026-09-076.713.316.736.73.3
2026-09-147.429.629.618.53.7
2026-09-2114.32512.58.95.4
2026-09-2818.615.111.677
2026-10-0537.28.111.69.32.3
2026-10-1223.419.315.210.30.7
2026-10-1942.715.912.24.96.1
2026-10-2639.814.812.510.25.7
2026-11-0227.725.34.861.2
2026-11-0923.314.65.88.70

Clean market: hiring index

The same 7,505 employer job boards; the posting count comes from the board itself. Connecting new sources does not move this index — it shows the market, not our coverage. This is the whole panel market, not just Data Warehouse.

Hiring index, Oct 16 = 100

Chart data
Hiring index, Oct 16 = 100. Block data table. A missing value is not zero; units and sample are stated in the metric description.
PeriodHiring index
2026-10-16100
2026-10-17100.03
2026-10-1899.76
2026-10-1999.68
2026-10-2099.27
2026-10-2198.6
2026-10-2299.07
2026-10-2397.4
2026-10-2497.41
2026-10-2697.33
2026-10-2796.76
2026-10-2896.21
2026-10-2995.17
2026-10-3095.13
2026-10-3193.65
2026-11-0193.33
2026-11-0292.67
2026-11-0392.65
2026-11-0492.41
2026-11-0592.13
2026-11-0690.44
2026-11-0790.48
2026-11-0890.45
2026-11-1090.29
2026-11-1190.22
2026-11-1390.12
2026-11-1489.7
2026-11-1589.68
2026-11-1689.62
2026-11-1888.91
2026-11-1988.02

Chain index: each day compares only boards polled on both that day and the previous one; outliers and platform-wide polling outages are excluded. Days with no comparable pairs are left blank.

Chart data
Clean market: hiring index — Data Warehouse. Block data table. A missing value is not zero; units and sample are stated in the metric description.
DayHiring index
2026-10-16100
2026-10-17100.03
2026-10-1899.76
2026-10-1999.68
2026-10-2099.27
2026-10-2198.6
2026-10-2299.07
2026-10-2397.4
2026-10-2497.41
2026-10-2697.33
2026-10-2796.76
2026-10-2896.21
2026-10-2995.17
2026-10-3095.13
2026-10-3193.65
2026-11-0193.33
2026-11-0292.67
2026-11-0392.65
2026-11-0492.41
2026-11-0592.13
2026-11-0690.44
2026-11-0790.48
2026-11-0890.45
2026-11-1090.29
2026-11-1190.22
2026-11-1390.12
2026-11-1489.7
2026-11-1589.68
2026-11-1689.62
2026-11-1888.91
2026-11-1988.02

How many open Data Warehouse jobs there are and how many matching specialists Zorky observes.

Demand and observed supply

Chart data
Block data table. A missing value is not zero; units and sample are stated in the metric description.
MetricValue
Open demand442
Open demand442
Observed supply— not published

Data Warehouse Engineer forms a steady job flow. Drivers: legacy DWH (Greenplum/Redshift) migrations to Snowflake/BigQuery/ClickHouse, modern data stack growth (dbt + cloud DWH), ClickHouse dominator in CIS product teams.

⚠ candidates matching a vacancy are not counted yet: demand and the observed pool are shown

How salaries in Data Warehouse jobs are distributed, in US dollars per month.

Salary distribution

P25 $6,062 · P50 $7,880 · P75 $10,250
Chart data
Block data table. A missing value is not zero; units and sample are stated in the metric description.
MetricValue
<$1k0
$1–2k0
$2–3k0
$3–4k0
$4–5k5
$5–6k6
$6–7k11
$7–8k5
$8–9k7
$9–10k3
$10–12k9
$12–15k4
$15–20k1
$20k+1
Salary in postings: base 442
  • usable for the calculation: 52 (11.8%)
  • stated but not converted to USD/month: 54 (12.2%)
  • not stated: 336 (76%)

One in ten postings offers under $5,373, one in ten over $12,500. Half of the postings offer between $6,062 and $10,250. Sample: 52.

Chart data
Salary distribution — Data Warehouse. Block data table. A missing value is not zero; units and sample are stated in the metric description.
MetricLower boundUpper boundCount
<$1k01,0000
$1–2k1,0002,0000
$2–3k2,0003,0000
$3–4k3,0004,0000
$4–5k4,0005,0005
$5–6k5,0006,0006
$6–7k6,0007,00011
$7–8k7,0008,0005
$8–9k8,0009,0007
$9–10k9,00010,0003
$10–12k10,00012,0009
$12–15k12,00015,0004
$15–20k15,00020,0001
$20k+20,000—1

Which countries have the most open Data Warehouse jobs.

Demand geography

countryjobsshare
Poland11830.8%
United States7920.6%
India4912.8%
United Kingdom256.5%
France195%
Germany184.7%
Canada82.1%
Mexico61.6%
Russia61.6%
South Africa51.3%
Other countries5013.1%

The leader by DWH job count is Poland (118 positions). Russia — ClickHouse dominator. Poland — DWH-friendly EU. Large international remote via Snowflake/dbt Labs.

⚠ job counts only: salary by country is not published

Chart data
Demand geography — Data Warehouse. Block data table. A missing value is not zero; units and sample are stated in the metric description.
CountryJobs
PL118
US79
IN49
GB25
FR19
DE18
CA8
MX6
RU6
ZA5

Which technologies are most often required in the same job as Data Warehouse.

Used together with

snowflake
32473.3%
sql
20345.9%
cloud
20145.5%
python
16236.7%
dbt
14833.5%
aws
11826.7%
azure
10022.6%
airflow
8519.2%
databricks
7316.5%
gcp
6314.3%

Share — how many of the 442 jobs in the Data Warehouse market mention this technology. Ordered by job count, not by “strength of association”. Umbrella terms like cloud are not a specific cloud (AWS, Azure).

Top DWH stack 2026: SQL at mastery (must), one cloud DWH: Snowflake (cloud premium) / BigQuery (GCP) / ClickHouse (CIS OLAP dominator) / Redshift (AWS legacy), dbt (transform layer standard), Apache Airflow (ingestion orchestration), Apache Iceberg / Delta Lake (lakehouse), Kafka + Debezium (CDC), Looker / Mode / Metabase / Superset / Yandex DataLens (BI).

Common pairs: SQL + Snowflake, SQL + ClickHouse, dbt + Snowflake, dbt + BigQuery, dbt + ClickHouse, Airflow + DWH. Learning roadmap: Advanced SQL → one cloud DWH (ClickHouse for CIS or Snowflake for international) → dbt → Kimball modeling → Airflow basics → one BI tool.

Chart data
Used together with — Data Warehouse. Block data table. A missing value is not zero; units and sample are stated in the metric description.
NameCount
snowflake324
sql203
cloud201
python162
dbt148
aws118
azure100
airflow85
databricks73
gcp63
bigquery61
kafka26

How many Data Warehouse jobs there are at each level, from junior to principal.

Demand by grade

gradejobs
senior163
middle40
principal28
lead27
junior10

Juniors are scarce — market expects advanced SQL + one DWH. Career flow: Analyst Senior / Data Engineer Middle → DWH Middle → Senior → DWH Architect / Head of Data.

⚠ demand side only: the grade of the observed pool is unknown for most of it

Chart data
Demand by grade — Data Warehouse. Block data table. A missing value is not zero; units and sample are stated in the metric description.
LevelCount
senior163
middle40
principal28
lead27
junior10

Who hires the most for Data Warehouse and how concentrated demand is among the largest companies.

Employers

Demand is spread across 280 employers. The largest accounts for 3.3%, the top ten for 16.7%; the remaining 83.3% is long tail.

largest 3.3%2nd–3rd 3.8%4th–10th 9.6%the rest 83.3%
sharevalue
top-13.3%
top-37.2%
top-1016.7%
long tail83.3%

⚠ names are not shown: staffing agencies and end employers are not yet told apart by the classifier

Which company sites and job boards Zorky collects Data Warehouse jobs from.

Where Zorky sees this market

Observed across 65 sources; the largest accounts for 15.4% — this market does not rest on a single channel.

Chart data
Where Zorky sees this market — Data Warehouse. Block data table. A missing value is not zero; units and sample are stated in the metric description.
ClassNameEnglish nameCountShare
atsATS и карьерные сайтыATS & career sites2230.5045
boardджоб-борды и агрегаторыjob boards & aggregators2020.457
telegramTelegramTelegram170.0385

The newest Data Warehouse jobs from company career sites.

Recent openings

All jobs →

Latest open DWH Engineer jobs — the most recent 10 positions with adequate description quality. The full list is in our CRM or via the "see all" link below.

How this is measured
Vacancy
an open job that cleared the quality gate and lists at least two technologies
Observed candidate
a candidate whose stack contains this technology; an aggregate — not a single record leaves the perimeter
Matchable candidate
not counted yet
Window
jobs open at the moment the snapshot was built

About the data

  • Some breakdowns are hidden: their data coverage is not yet sufficient.
  • Statistics are shown only where the sample clears a quality gate.
  • A missing block does not mean a value of zero.

Breakdowns currently hidden: 8.

Direction: Data Engineering

Related specializations

Inside Data Warehouse Engineer: Snowflake Engineer (cloud-DWH dominator), BigQuery Engineer (GCP), ClickHouse Engineer, Redshift Engineer (AWS legacy), Data Warehouse Architect (modeling specialist). Comparison with other data specialisations — in the bar below.

Big DataData EngineerDBAStreaming

Frequently asked questions

The most common questions about DWH Engineer: pay, Snowflake vs BigQuery vs ClickHouse vs Redshift, dbt vs Airflow (complements, not competitors), differences from Data Engineer / Analytics Engineer, remote, how to start (6-10 months), Senior skills. Answers recompute automatically.

What does a DWH Junior, Middle, Senior, or Lead earn?

Junior DWH openings are scarce — the market expects advanced SQL + one DWH hands-on (often after Analyst Senior with SQL mastery or Data Engineer Middle). The Junior → Middle jump — mastering one DWH deeply + dbt + ingestion pipelines. Senior owns DWH modelling architecture (star/snowflake/Data Vault). Lead — managing the modeling team + designing enterprise data architecture. Career flow: Analyst Senior / Data Engineer Middle → DWH Middle → Senior → either Data Warehouse Architect or Head of Data.

What stack does a DWH Engineer most often need?

Top 5: snowflake, cloud, sql, python, dbt. SQL at mastery (window functions, recursive CTE, query optimisation, partition pruning). One of cloud DWH: Snowflake (cloud premium — Tasks/Streams/Time Travel/micro-partitions/Snowpipe), BigQuery (GCP — slot pricing/BQML), ClickHouse (CIS OLAP dominator — ReplicatedMergeTree/distributed/materialised views), Redshift (AWS legacy — distkey/sortkey). Greenplum in CIS enterprise (Sber). dbt — must (transform layer standard — models + tests + macros + packages). Apache Airflow for ingestion. Apache Iceberg/Delta Lake — lakehouse table formats (growing). Apache Kafka + Debezium for CDC. BI: Looker/Mode/Metabase/Superset/Yandex DataLens. Knowledge of Kimball modeling (star/snowflake schemas, slowly changing dimensions) or Data Vault — Senior must.

Snowflake vs BigQuery vs ClickHouse vs Redshift — what to pick?

Snowflake — cloud-DWH dominator in international projects. Multi-cloud (AWS/Azure/GCP), separation of storage/compute, Time Travel, Snowpipe for streaming. Premium pricing, but best DX. Senior Snowflake — premium in international remote. BigQuery — Google Cloud-native. Slot-based pricing (or on-demand), BQML for in-DB machine learning. Dominator in GCP shops. ClickHouse — open-source OLAP dominator in CIS. The fastest OLAP on columnar storage. Senior ClickHouse — market necessity at CIS product companies. Redshift — AWS legacy, migrations to Snowflake or BigQuery. Fewer new projects. Strategy: ClickHouse if at a CIS product team, Snowflake for international remote, BigQuery if in the GCP stack, Redshift only for maintenance of legacy AWS projects.

dbt vs Airflow — are they competitors?

Not competitors — complements. Airflow — orchestration (when to run what, dependencies between tasks). dbt — transform layer (SQL models + tests + documentation + lineage). Classic modern data stack pipeline: Airflow triggers ingestion (Python/Spark scripts) → dbt runs in Airflow as a BashOperator or DbtRunOperator (via the astronomer-dbt provider) → dbt executes SQL transformations in the DWH (Snowflake/BigQuery/ClickHouse) → BI layer (Looker/Metabase) reads the final dbt models. A Senior DWH Engineer owns both. Airflow for orchestration + ingestion, dbt for transformations + tests. Knowledge of dbt modules (sources/models/tests/macros/snapshots/seeds) + dbt best-practices — Senior must in 2026.

What share of jobs are remote?

Among jobs with a stated work format, 39% are remote. Jobs without a stated format are excluded from the denominator; hybrid work is not counted as remote.

How is DWH Engineer different from Data Engineer / Analytics Engineer?

DWH Engineer (this page) — focus on cloud DWH (Snowflake/BigQuery/ClickHouse/Redshift) + modelling. SQL mastery + one DWH deeply. Data Engineer (general) — broader scope: pipelines + DWH + streaming + Spark. Analytics Engineer — focus on dbt + transform layer. Sits between Data Engineer and Data Analyst. SQL + dbt + one DWH (often Snowflake/BigQuery), but WITHOUT Spark and streaming. Career switch DWH Engineer → Analytics Engineer — 1-2 months (same stack, focus on dbt). DWH Engineer → Data Engineer (general) — 3-6 months (+ Spark + Airflow deeper).

Where to start in DWH in 2026?

Roadmap (SQL Middle or Data Analyst experience assumed): 1) Advanced SQL — window functions deeply, recursive CTE, query optimisation, EXPLAIN ANALYZE, indexes, partition pruning. PostgreSQL + one OLAP (ClickHouse recommended — most used in CIS). 2) One cloud DWH: ClickHouse (recommended for CIS career — open-source, free) OR Snowflake (for international remote — 30-day free trial) OR BigQuery (GCP free tier). Master engine-specific features (ClickHouse: ReplicatedMergeTree + distributed + materialised views; Snowflake: Tasks + Streams + Time Travel + micro-partitions). 3) dbt — official tutorial getdbt.com + Jaffle Shop pet project. Master models + tests + macros + sources + snapshots. 4) Kimball modeling — star schema, snowflake schema, slowly changing dimensions (SCD). Book "The Data Warehouse Toolkit" Kimball. 5) Airflow basics — ingestion orchestration. 6) Apache Iceberg or Delta Lake — lakehouse basics. 7) One BI tool — Metabase/Superset/Yandex DataLens (free) or Looker (premium). 8) End-to-end pet project: ingestion (Python script + Airflow) → DWH (ClickHouse or BigQuery) → dbt models → BI dashboard on Metabase. Courses: Karpov.Courses "Data Engineer" (includes DWH), OTUS "Data Engineer", Yandex.Practicum "Data Engineer", DataCamp "Data Engineer with dbt", Snowflake University (EN — free, best Snowflake resource), ClickHouse Academy (EN — free). Books: "The Data Warehouse Toolkit" Kimball (must-read), "Analytics Engineering with dbt" (modern data stack guide). Time to Junior DWH — 6-10 months (faster than general Data Engineer thanks to smaller scope).

How many open jobs are in this sample?

The published sample contains 442 open jobs after merging reposts. This is the same count shown in the main indicator. The geography section describes the sample coverage; this is not an estimate of the entire market.

What skills does a Senior DWH Engineer need?

A Senior DWH owns the full cloud-DWH cycle. SQL mastery: window functions deep, recursive CTE, query plans (EXPLAIN ANALYZE), partition pruning, indexes, materialised views, query-optimisation patterns. One cloud DWH deeply: Snowflake (Tasks/Streams/Time Travel/micro-partitions/Snowpipe/cost optimisation via warehouse sizing) or BigQuery (slot management/BQML/partitioned tables) or ClickHouse (ReplicatedMergeTree/distributed engines/materialised views/codecs/dictionaries). Modeling: Kimball mastery (star/snowflake schema, conformed dimensions, SCD types 1-6), Data Vault basics, lakehouse architecture (Iceberg/Delta partition evolution, time-travel, schema evolution). dbt: mastery (models/sources/tests/macros/snapshots/seeds/exposures), best-practices (incremental models, materialisation strategies, dbt-snowflake/dbt-bigquery adapter specifics). Performance: query-optimisation patterns per DWH engine, cost management (Snowflake credit usage / BigQuery slots / ClickHouse cluster sizing). Ingestion: Kafka + Debezium for CDC, Airflow for batch ingestion, Snowpipe / Snowflake Streams / materialised views. Data Quality: dbt tests + Great Expectations + Soda. BI integration: one of Looker/Mode/Metabase/Superset/Yandex DataLens at semantic-layer design level. Soft: code review (SQL + dbt), mentoring Middle, communication with Analyst/Business teams. English for Senior+ must — DWH documentation is predominantly EN.

Leave a request

Describe the task and leave a contact — the request goes to our CRM and we reply at the contact you provide.

By submitting, you agree to the privacy policy.