Datamart Designer

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

• 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 (Presto
  
  SQL):
  Hands-on experience for distributed SQL and semantic layer implementation
• Oracle SQL and database knowledge
• Data modeling tools:
  Erwin, Power Designer

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