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

#J-18808-Ljbffr