This job is no longer available
This job expired on 10/11/2026. It no longer accepts applications.
Data Engineer – Metrics Layer (SQL, Redshift, Power BI)
Start Matter
Job description
About the role
We are looking for a Data Engineer to own the company’s metrics layer – the single source of truth for all business metrics. The role focuses on building and governing metric definitions in SQL on our data warehouse and exposing them to Power BI and other downstream consumers.
Key responsibilities
- Design, build, and maintain the SQL‑based metrics/semantic layer on the warehouse.
- Enforce a single canonical formula per metric across the organization, preventing duplicated or drifting definitions.
- Model conformed dimensions and fact tables to ensure correct filtering and cross‑filtering in Power BI.
- Compose metrics additively in SQL, creating derived metrics (ratios, rates, averages) that re‑aggregate correctly under any grouping.
- Own governance processes: naming standards, ownership, code review, automated tests, lineage, documentation, and deprecation.
- Define the policy for what is computed in SQL versus what is left to Power BI/DAX.
- Optimize query performance and cost through materialization strategies, incremental builds, pre‑aggregation, and partitioning/clustering.
Required profile
- Strong, idiomatic SQL skills, including window functions, complex joins, and a deep understanding of aggregation grain and additivity.
- Hands‑on experience with Amazon Redshift and Databricks.
- Direct experience feeding Power BI, understanding model relationships, grain, and where DAX is appropriate.
- Expertise in dimensional modeling (star schemas, conformed dimensions, SCDs, surrogate keys).
- Deep knowledge of semantic/metrics‑layer design principles (e.g., dbt Semantic Layer, MetricFlow, Cube, LookML).
- Governance mindset for collaborative multi‑team projects.
- Fluent in Russian, Belarusian, or Ukrainian (working proficiency) and fluent English for documentation and code review.
Required skills
- SQL (advanced)
- Amazon Redshift
- Databricks
- Power BI
- Dimensional modeling
- Semantic layer design (dbt, MetricFlow, Cube, LookML)
- Python (preferred)
- TypeScript (preferred)
- DAX (nice to have)
- Airflow or Dagster (nice to have)
- Row‑level security design (nice to have)
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches for Беларусь.
Salaries by job title
Une question sur cette offre ?
Posez-la ici : vous recevrez le récapitulatif de l'offre par e-mail, tout de suite.
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
Start Matter