Datamart Designer
Master WorksRiyadh, Riyadh Region, Saudi Arabia5 منذ أيام
الوصف الوظيفي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 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
إنشاء تنبيه وظيفي لهذا البحث
Designer • Riyadh, Riyadh Region, Saudi Arabia
وظائف ذات صلة
- عَرْضٌ مُرَوَّجٌ له
Senior Product Designer New Riyadh, Riyadh, Saudi Arabia
Hala groupRiyadh, Saudi Arabia HALA is a leading fintech player in the MENAP region that aims to redefine financial services and build the future bank of SMEs.
HALA aims at empowering SMEs to start, run, and grow their businesses...أظهر المزيدآخر تحديث: 4 منذ أيام
- عَرْضٌ مُرَوَّجٌ له
Graphic Designer - Riyadh
DJE HoldingsRiyadh, Riyadh Region, Saudi Arabia Edelman is a new kind of agency, at the intersection of PR, Advertising, Social, Digital, Earned Media and Experiential.We blur the lines between each medium to create smart, innovative, and powerf...أظهر المزيدآخر تحديث: 4 منذ أيام
- عَرْضٌ مُرَوَّجٌ له
Senior Director - Digital Delivery (CDU4) - 20005187
Qiddiya Investment CompanyRiyadh, Riyadh Region, Saudi Arabia Join us at Qiddiya, the future capital of entertainment, sports, and culture in Saudi Arabia.As one of the Kingdom’s most ambitious Vision 2030 giga-projects, Qiddiya is reimagining what’s possible...أظهر المزيدآخر تحديث: منذ أكثر من 30 يومًا
- عَرْضٌ مُرَوَّجٌ له
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...أظهر المزيدآخر تحديث: منذ أكثر من 30 يومًا
- عَرْضٌ مُرَوَّجٌ له
UX Designer
Supertech Innovation LabsRiyadh, Riyadh Region, Saudi Arabia We are looking for a highly creative and detail-oriented UX Designer to join our growing team.In this role, you will craft intuitive and engaging user experiences, ensure smooth user journeys, and ...أظهر المزيدآخر تحديث: منذ أكثر من 30 يومًا
- عَرْضٌ مُرَوَّجٌ له
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...أظهر المزيدآخر تحديث: 4 منذ أيام
- عَرْضٌ مُرَوَّجٌ له
Digital Media Designer Jobs in Riyadh
AlmajdouieRiyadh, Riyadh Region, Saudi Arabia Summary : Lead user-centered design as a Senior UX / UI Designer in Riyadh, creating impactful web and mobile experiences.
Develop user journeys, high-fidelity mockups, and interactive prototypes while...أظهر المزيدآخر تحديث: 2 منذ أيام
- عَرْضٌ مُرَوَّجٌ له
Senior Design Manager
Mace GroupRiyadh, Riyadh Region, Saudi Arabia At Mace, our purpose is to redefine the boundaries of ambition.We believe in creating places that are responsible, bringing transformative impact to our people, communities, and societies across th...أظهر المزيدآخر تحديث: منذ أكثر من 30 يومًا
- عَرْضٌ مُرَوَّجٌ له
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...أظهر المزيدآخر تحديث: 28 منذ أيام
- عَرْضٌ مُرَوَّجٌ له
UX Designer
Work corpRiyadh, Riyadh Region, Saudi Arabia UX Designer vacancy in Riyadh Saudi Arabia.UX Designer (English speaking).We are seeking a talented and innovative UX Designer to join our team in Riyadh, Saudi Arabia.
As our ideal candidate, you s...أظهر المزيدآخر تحديث: 12 منذ أيام
- عَرْضٌ مُرَوَّجٌ له
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...أظهر المزيدآخر تحديث: منذ أكثر من 30 يومًا
- عَرْضٌ مُرَوَّجٌ له
Product Designer
AlmosaferRiyadh, Riyadh Region, Saudi Arabia At Almosafer (part of Seera Group), we’re not just part of the travel industry, we’re helping shape its future.As Saudi Arabia’s leading travel company, we serve millions across every segment of th...أظهر المزيدآخر تحديث: 16 منذ أيام
- عَرْضٌ مُرَوَّجٌ له
Senior Digital Designer
Creative PersonnelRiyadh, Riyadh Region, 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...أظهر المزيدآخر تحديث: منذ أكثر من 30 يومًا
- عَرْضٌ مُرَوَّجٌ له
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...أظهر المزيدآخر تحديث: 8 منذ أيام
- عَرْضٌ مُرَوَّجٌ له
Design Manager - Retail
WSP USARiyadh, Riyadh Region, Saudi Arabia What if you could do the kind of work the world needs?.At WSP, you can access our global scale, contribute to landmark projects and connect with the brightest minds in your field to do the best wor...أظهر المزيدآخر تحديث: 2 منذ أيام
- عَرْضٌ مُرَوَّجٌ له
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...أظهر المزيدآخر تحديث: منذ أكثر من 30 يومًا
- عَرْضٌ مُرَوَّجٌ له
Senior Design Manager (Stadiums)
Mace GroupRiyadh, Riyadh Region, 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...أظهر المزيدآخر تحديث: منذ أكثر من 30 يومًا
- عَرْضٌ مُرَوَّجٌ له
Senior Director - Digital Delivery (SDU4) - 20005187
Qiddiya Investment CompanyRiyadh, Riyadh Region, Saudi Arabia Join us at Qiddiya, the future capital of entertainment, sports, and culture in Saudi Arabia.As one of the Kingdom’s most ambitious Vision 2030 giga-projects, Qiddiya is reimagining what’s possible...أظهر المزيدآخر تحديث: منذ أكثر من 30 يومًا