Datamart Designer
Master WorksRiyadh, Riyadh Region, Saudi Arabia5 days 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, Qlik, 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
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 • Riyadh, Riyadh Region, Saudi Arabia
Related jobs
- Promoted
GenAI Learning Designer Riyadh •
Noon Academy corporationRiyadh, Riyadh Region, Saudi Arabia Noon Academy is the leading edtech platform in the Middle East, with over 12 million students and teachers using our app to learn, teach, and collaborate.
We have recently raised $41 million in Seri...Show moreLast updated: 30+ days ago
- Promoted
Graphic Designer - Riyadh
EdelmanRiyadh, Riyadh Region, Saudi Arabia As a Designer, you will manage, concept and execute high quality creative on multiple accounts and projects.You will lead the conceptual and stylistic direction on several marquis brands.We want yo...Show moreLast updated: 4 days ago
- Promoted
Pharmacist- "المزاحمية"
Nahdi Medical Co.Al Muzahimiyah, Riyadh Region, Saudi Arabia Provides general healthcare advice and dispenses prescription and non-prescription medication along with non-pharma products to customers.
Supervises the retail store team and operations in order to...Show moreLast updated: 30+ days ago
- Promoted
Interaction Designer
Supertech Innovation LabsRiyadh, Saudi Arabia Be among the first 25 applicants.Do you want to love what you do at work? Do you want to make a difference, an impact, and transform people's lives? Do you want to work with a team that believes in...Show moreLast updated: 30+ days ago
- Promoted
Design Manager
Jones Lang LaSalle IncorporatedRiyadh, Riyadh Region, Saudi Arabia Design Manager page is loaded## Design Managerremote type : On-sitelocations : Riyadh, SAUtime type : Full timeposted on : Opublikowano dzisiajjob requisition id : REQ • •JLL empowers you to sh...Show moreLast updated: 29 days ago
- Promoted
Design Director
SAS Global ConsultantsRiyadh, Riyadh Region, Saudi Arabia Leading international consultancy.Our client are seeking a highly skilled and experienced Design Director who comes from an architectural background who should have at least 20+ years of experience...Show moreLast updated: 30+ days ago
- Promoted
Graphic Designer (Saudi Only)
LucidyaRiyadh, Riyadh Region, 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 moreLast updated: 30+ days ago
- Promoted
Senior Interrior Designer
Jones Lang LaSalle IncorporatedRiyadh, Riyadh Region, Saudi Arabia Senior Interrior Designer page is loaded## Senior Interrior Designerremote type : On-sitelocations : Riyadh, SAUtime type : Full timeposted on : Posted Todayjob requisition id : REQ • •JLL empo...Show moreLast updated: 30+ days ago
- Promoted
Design Manager Dry Utilities
Bechtel Oil, Gas & Chemicals IncorporatedRiyadh, Riyadh Region, Saudi Arabia Press Tab to Move to Skip to Content Link.Select how often (in days) to receive an alert : .National / International - Single.
Since 1898, we have helped customers complete more than 25,000 projects in ...Show moreLast updated: 5 days ago
- Promoted
Senior Dry Utilities Design Manager
Jasara Program Management CompanyRiyadh, Riyadh Region, Saudi Arabia Demonstrates leadership behaviors, in line with the values, at all times.Leads the team, with a focus on delivering innovative solutions that provide superior outcomes.
Provide consistent leadership...Show moreLast updated: 30+ days ago
- Promoted
Training Supervisor
Hilton Worldwide, Inc.Municipality of Al Shamal, Riyadh Region, Saudi Arabia Job Description - Training Supervisor (HOT0C03D).Position : Training Officer (Training Supervisor) at Double Tree by Hilton Riyadh Financial District, Northern Ring Road Riyadh 3325.A Training Offic...Show moreLast updated: 24 days ago
- Promoted
Architectural Draftsman
ConfidentialMunicipality of Al Shamal, Riyadh Region, Saudi Arabia We are an architecture firm, looking for a draftsman to join our team at IDP.Developing detailed 2D and 3D CAD drawings, designs, and models for various engineering design and architectural draftin...Show moreLast updated: 30+ days ago
- Promoted
Datamart Designer
Master-WorksRiyadh, Riyadh Region, Saudi Arabia 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 requiri...Show moreLast updated: 8 days ago
- Promoted
Senior Digital Designer
Creative PersonnelRiyadh, Saudi Arabia The successful candidate will work on a variety of software products (iPad / mobile / web apps) within an IT team, as well as some print design (exhibition / print ads / marketing collateral).You will be w...Show moreLast updated: 30+ days ago
- Promoted
Senior Design Manager (Stadiums)
Mace GroupRiyadh, Saudi Arabia This opportunity is for a secured role that is due to commence in October, subject to approval.If you would like to be considered as we progress with this position, please click to apply.Mace combi...Show moreLast updated: 30+ days ago
- Promoted
Product Designer (Saudi National)
Infinite plRiyadh, Saudi Arabia Infinite pl, is a digital led tech firm driven to become a digital logistics pioneer by harnessing the power of people, data, and platforms.
We are enabled through inhouse, external, network, & othe...Show moreLast updated: 30+ days ago
- Promoted
Graphic Designer for Digital Print Shop in Riyadh 4,000 to 7,000 SAR per month
GevevRiyadh, Riyadh Region, Saudi Arabia Are you a skilled graphic designer looking to work in a fast-paced, creative environment? We are currently seeking a talented Graphic Designer to join our digital print shop in Riyadh.If you have e...Show moreLast updated: 30+ days ago
- Promoted
Design Director
WSP Global Inc.Riyadh, Riyadh Region, Saudi Arabia WSP in the Middle East is seeking a highly experienced and visionary Design Director to join our team in Riyadh, KSA.This strategic leadership role is critical to the success of high-profile, multi...Show moreLast updated: 30+ days ago