Datamart Designer

Job description / Role

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

Requirements

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