Datamart Designer

Master-Works; Riyad Al Khabra; On-site; SAR 200,000 - 300,000; Full time

Job summary

A leading data solutions company located in Riyad Al Khabra is seeking an experienced Datamart / Semantic Layer Designer & Modeler. The successful candidate will design and develop data models and semantic layers, requiring strong dimensional modeling expertise and a deep understanding of telecommunications. The role involves collaboration with business stakeholders to create analytics solutions that drive business value, with a minimum of 5 years experience required.

Qualifications

• Minimum 5+ years in datamart design and dimensional modeling.
• Strong expertise in dimensional modeling best practices.
• Experience designing datamarts for multiple business domains.

Responsibilities

• Design and develop star/snowflake schema models on Teradata EDW.
• Create business-friendly abstractions for end users.
• Collaborate with stakeholders to define KPIs and metrics.

Skills

Dimensional Modeling

Strong communication

Telecommunications domain knowledge

Problem-solving

Stakeholder management

Education

Bachelor's degree in Computer Science, Business Analytics, or related field

Tools

Teradata

TIBCO

Trino

SQL (Oracle)

Data modeling tools (Erwin, PowerDesigner)

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
• Develop dimension tables, conformed dimensions, bridge tables, and hierarchies
• Implement slowly changing dimensions (SCD Types 1, 2, 3) and aggregate tables for performance
• Strong expertise in dimensional modeling best practices and design patterns

Semantic Layer Development

• Design and implement semantic layers on Teradata using TIBCO and Trino
• Create business-friendly abstractions that hide technical complexity from end users
• Define business entities, relationships, metrics, KPIs, and calculated measures in semantic layer
• Implement business logic, calculations, and data access policies
• Develop views, materialized views, and virtual tables for semantic consumption

Business Requirements & KPI Definition

• Collaborate with business stakeholders to understand analytics, reporting, and decision-making needs
• Define and document business KPIs, metrics, and performance indicators with business context
• Translate business requirements into dimensional models and semantic layer specifications
• Apply product thinking to design analytics solutions that deliver measurable business outcomes
• Create business glossary and maintain business metadata aligned with business terminology

Technical Implementation & Optimization

• Work with Teradata (Must Have) for datamart and semantic layer implementation
• Develop semantic models using TIBCO Data Virtualization and Trino for distributed queries
• Optimize query performance through indexing (PI, SI), partitioning, aggregations, and caching
• Implement row-level security and data governance policies in semantic layer
• Collaborate with EDW designers, ETL teams, BI developers, and business users

Requirements

Dimensional Modeling (Required - Strong)

• Strong expertise in star schema and snowflake schema design and modeling
• Advanced dimensional modeling techniques (Kimball methodology)
• Fact table design (additive, semi-additive, non-additive measures) and grain definition
• Dimension design : conformed dimensions, role-playing dimensions, junk dimensions, slowly changing dimensions
• Experience designing datamarts for multiple business domains

Database & Tools (Required)

• Teradata (Must Have) : Advanced SQL, performance tuning, indexing strategies, architecture understanding
• TIBCO : Experience with TIBCO Data Virtualization or TIBCO suite for semantic layer
• Trino (PrestoSQL) : Hands‑on experience for distributed SQL and semantic layer implementation
• Oracle SQL and database knowledge
• Data modeling tools : Erwin, PowerDesigner

Business & Domain Knowledge (Required)

• Strong business acumen and understanding of business processes, KPIs, and decision-making
• Product thinking : ability to design solutions focused on business value and user experience
• Deep understanding of business metrics, analytics requirements, and reporting needs
• Ability to translate business language into technical data models

Telecommunications Domain (Required - Must Have)

• Deep telecom business knowledge including processes, operations, and analytics
• OSS : Network performance, inventory, fault management, service quality metrics
• BSS : Billing, customer analytics, revenue assurance, churn analysis, product performance
• Telecom KPIs : ARPU, churn rate, CLTV, network utilization, service availability, revenue metrics, subscriber growth

Professional Skills

• Excellent communication and stakeholder management skills
• Strong analytical and problem-solving abilities with business-oriented thinking
• Full SDLC experience (Agile / Scrum preferred)
• Ability to conduct workshops and present to business audiences

Preferred Qualifications

• Bachelor's degree in Computer Science, Business Analytics, or related field
• Experience with BI tools : Tableau, Power BI, Qlick, MicroStrategy
• Knowledge of data virtualization, MDM, and data governance
• Understanding of self-service analytics and data democratization

Key Deliverables

• Star / snowflake schema dimensional models for datamarts on Teradata
• Semantic layer models with business entities, KPIs, and relationships using TIBCO and Trino
• Business KPI definitions, calculations, and business glossary
• Technical specifications and performance optimization recommendations
• Documentation : dimensional models, semantic layer specs, user guides