Talent.com
Datamart Designer

Datamart Designer

Master-WorksSaudi Arabia
3 منذ أيام
الوصف الوظيفي

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; maintain 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; 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 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 using the 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.

    • #J-18808-Ljbffr

    إنشاء تنبيه وظيفي لهذا البحث

    Designer • Saudi Arabia