Datamart Architect: Dimensional Modeling & Semantic Layer

Master-Works; Riyad Al Khabra; On-site; SAR 200,000 - 300,000; Full time

Job summary

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 semantic layers, requiring strong dimensional modeling expertise and a deep understanding of telecommunications. The role involves collaboration with business stakeholders to create analytics solutions that drive business value, with a minimum of 5 years experience required.

Qualifications

• Minimum 5+ years in datamart design and dimensional modeling.
• Strong expertise in dimensional modeling best practices.
• Experience designing datamarts for multiple business domains.

Responsibilities

• Design and develop star/snowflake schema models on Teradata EDW.
• Create business-friendly abstractions for end users.
• Collaborate with stakeholders to define KPIs and metrics.

Skills

Dimensional Modeling

Strong communication

Telecommunications domain knowledge

Problem-solving

Stakeholder management

Education

Bachelor's degree in Computer Science, Business Analytics, or related field

Tools

Teradata

TIBCO

Trino

SQL (Oracle)

Data modeling tools (Erwin, PowerDesigner)

Job description

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 semantic layers, requiring strong dimensional modeling expertise and a deep understanding of telecommunications. The role involves collaboration with business stakeholders to create analytics solutions that drive business value, with a minimum of 5 years experience required.