Datamart Designer

Master-Works

📍 Riyadh, Riyadh Province, Saudi Arabia

Full time Computer Occupations Posted March 01, 2026

Job Description

Position Overview

We are seeking an experienced Datamart / Semantic Layer Designer & Modeler to design business-oriented data models and semantic layers on top of Teradata EDW. This is a business-focused role requiring strong dimensional modeling expertise, business acumen, deep understanding of KPIs, telecommunications domain knowledge, and product thinking to deliver analytics solutions that drive business value.

Experience Required: Minimum 5+ years in datamart design, dimensional modeling, and semantic layer development

Core Responsibilities

Dimensional Modeling & Datamart Design

  • Design and develop star schema and snowflake schema dimensional models on Teradata EDW
  • Create subject-area datamarts (Customer, Revenue, Network, Product, Finance) optimized for business analytics
  • Design fact tables (transaction, snapshot, accumulating) with appropriate grain and measures