Datamart Designer

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