Datamart DesignerMaster-Works • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
Datamart Designer
Master-Works • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
4 hours ago
Job descriptionDesign 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 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 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 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 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 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 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 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 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 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
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
Business Requirements & KPI Definition
Technical Implementation & Optimization
Requirements
Dimensional Modeling (Required - Strong)
Database & Tools (Required)
Business & Domain Knowledge (Required)
Telecommunications Domain (Required - Must Have)
Professional Skills
Preferred Qualifications
Key Deliverables
#J-18808-Ljbffr
Create a job alert for this search
Designer • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
Related jobs
EDW Designer
Master-Works • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
We are seeking an experienced Enterprise Data Warehouse Designer / Modeler with specialized expertise in Teradata environments.
The ideal candidate will design robust data warehouse solutions, posse...Show more
Last updated: 20 days ago • Promoted
UI / UX Designer
Manzil • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
At Mnzil, design is more than how things look — it’s how they feel.We’re looking for a thoughtful and user-obsessed UI / UX Designer to craft intuitive, beautiful, and impactful digital experiences...Show more
Last updated: 4 hours ago • Promoted • New!
Enterprise Data Architect - Remote - Octopus - Immediate hire - Hybrid - Riyadh
Robusta Studio • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
Octopus by RTG is the tech hiring and outsourcing arm of Robusta Technology Group, dedicated to connecting exceptional tech talent with top-tier organizations across the MENA, GCC, Europe, the US, ...Show more
Last updated: 4 hours ago • Promoted • New!
Datamart Architect : Dimensional Modeling & Semantic Layer
Master-Works • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
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 s...Show more
Last updated: 4 hours ago • Promoted • New!
Graphic Designer (Saudi Only)
Lucidya • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
Lucidya is a leading customer experience platform powered by AI, enabling brands to understand and serve their customers better through social media analytics, customer feedback, and CRM integratio...Show more
Last updated: 30+ days ago • Promoted
Global Solutions Designer
Müller`s Solutions • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
A leading Tech consulting firm in Al-Qassim Province is seeking a skilled Solutions Designer to design and develop technical solutions for clients.
You will collaborate with clients, analyze systems...Show more
Last updated: 4 hours ago • Promoted • New!
Senior UI UX Designer
Squadio • WorkFromHome, Al-Qassim Province, Saudi Arabia
Squadio is a Global Remote-first IT service provider headquartered in Riyadh KSA with Delivery Centers in Egypt and KSA.Our distributed teams are located in Tunisia, Egypt, KSA, Palestine, Nigeria ...Show more
Last updated: 30+ days ago • Promoted
Senior UI / UX Designer — Mobile Games, On-Site Relocation
Datascope Recruitment • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
A leading recruitment agency is seeking a Senior UX / UI Designer for a studio in Saudi Arabia.This role requires over 5 years of experience in UX / UI design, particularly in mobile games.Candidates s...Show more
Last updated: 1 day ago • Promoted
UI / UX Design Intern — Create Impactful Apps
Horizontal Digital • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
A digital design agency in Saudi Arabia is seeking a passionate UI / Experience Design Intern.This role involves collaborating with a design team to create intuitive interfaces and gaining hands-on...Show more
Last updated: 4 hours ago • Promoted • New!
KSA National Graduate Designer (6-Month Program)
Horizontal Digital • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
We’re looking for a passionate and curious UI / Experience Design Intern to join our growing design team.If you’re fresh out of school or just starting your career and excited to learn how to craft...Show more
Last updated: 30+ days ago • Promoted
Remote Fashion Designer & Branding Creative
Saudi Petroleum Services Polytechnic • Buraydah, Al-Qassim Province, Saudi Arabia
Create a job alert for similar positions.Summary : A Graphic & Branding Designer position is available in Riyadh, Saudi Arabia for creative individuals looking to make an impact.Responsibilities inc...Show more
Last updated: 2 days ago • Promoted
Senior Graphic Designer - Internal Brand & Campaigns
Qiddiya Investment Company • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
A leading investment firm in Saudi Arabia seeks a creative Senior Specialist - Internal Graphic Designer to develop visually appealing content.
You will work closely with marketing teams to create g...Show more
Last updated: 4 hours ago • Promoted • New!
Remote Graphic Designer – Photoshop & Illustrator Pro
Saudi Petroleum Services Polytechnic • WorkFromHome, Al-Qassim Province, Saudi Arabia
Sales Professionals Jobs in Saudi Arabia.Create a job alert for similar positions.Summary : We are seeking a Graphic Designer to work remotely, focused on creating high-quality visual content for ad...Show more
Last updated: 2 days ago • Promoted
Brand Designer for AI SaaS — Elevate Customer Experience
Lucidya • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
A leading customer experience platform in Saudi Arabia is seeking a passionate Graphic Designer to bring their visual identity to life.
You will craft compelling visuals for social media, campaigns,...Show more
Last updated: 4 hours ago • Promoted • New!
Solutions Designer
Müller`s Solutions • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
Müller's Solutions, a leading Tech consulting firm specializing in Tech Outsourcing, Managed Services, SAP implementation & Support, and Global Tech Recruitment, is seeking a skilled Solutions Desi...Show more
Last updated: 30+ days ago • Promoted
Enterprise Data Architect - Remote - Octopus - Immediate hire - Onsite - Riyadh
robusta • WorkFromHome, Al-Qassim Province, Saudi Arabia
Octopus by RTG is the tech hiring and outsourcing arm of Robusta Technology Group, dedicated to connecting exceptional tech talent with top-tier organizations across the MENA, GCC, Europe, the US, ...Show more
Last updated: 1 day ago • Promoted
User-Centric UI / UX Designer for Digital Experiences
Manzil • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
A dynamic technology company in Al-Qassim Province seeks a UI / UX Designer to craft intuitive and beautiful digital experiences.
The ideal candidate will have over 2 years of experience in UI / UX desi...Show more
Last updated: 4 hours ago • Promoted • New!
Creative Graphic & Brand Designer – Flexible, Remote Options
Almajdouie • Riyad Al Khabra, Al-Qassim Province, Saudi Arabia
Create a job alert for similar positions.Summary : A Graphic & Branding Designer position is available in Riyadh, Saudi Arabia for creative individuals looking to make an impact.Responsibilities inc...Show more
Last updated: 4 hours ago • Promoted • New!