Datamart Designer at Master-Works

Riyadh, Riyadh Region, Saudi Arabia -

Full Time

Start Date

Immediate

Expiry Date

24 Jan, 26

Salary

0.0

Posted On

26 Oct, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Dimensional Modeling, Datamart Design, Semantic Layer Development, Teradata, TIBCO, Trino, SQL, Business Acumen, Telecommunications Domain Knowledge, KPI Definition, Data Governance, Performance Optimization, Agile, Communication Skills, Analytical Skills, Problem-Solving

Industry

IT Services and IT Consulting

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 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, Qlik, 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

Responsibilities

Design and develop dimensional models and datamarts optimized for business analytics. Collaborate with stakeholders to define business requirements and implement semantic layers for data consumption.