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