Datamart Designer

Position OverviewWe 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 developmentCore ResponsibilitiesDimensional Modeling & Datamart DesignDesign and develop star schema and snowflake schema dimensional models on Teradata EDWCreate subject-area datamarts (Customer, Revenue, Network, Product, Finance) optimized for business analyticsDesign fact tables (transaction, snapshot, accumulating) with appropriate grain and measuresDevelop dimension tables, conformed dimensions, bridge tables, and hierarchiesImplement slowly changing dimensions (SCD Types 1, 2, 3) and aggregate tables for performanceStrong expertise in dimensional modeling best practices and design patternsSemantic Layer DevelopmentDesign and implement semantic layers on Teradata using TIBCO and TrinoCreate business-friendly abstractions that hide technical complexity from end usersDefine business entities, relationships, metrics, KPIs, and calculated measures in semantic layerImplement business logic, calculations, and data access policiesDevelop views, materialized views, and virtual tables for semantic consumptionBusiness Requirements & KPI DefinitionCollaborate with business stakeholders to understand analytics, reporting, and decision-making needsDefine and document business KPIs, metrics, and performance indicators with business contextTranslate business requirements into dimensional models and semantic layer specificationsApply product thinking to design analytics solutions that deliver measurable business outcomesCreate business glossary and maintain business metadata aligned with business terminologyTechnical Implementation & OptimizationWork with Teradata (Must Have) for datamart and semantic layer implementationDevelop semantic models using TIBCO Data Virtualization and Trino for distributed queriesOptimize query performance through indexing (PI, SI), partitioning, aggregations, and cachingImplement row-level security and data governance policies in semantic layerCollaborate with EDW designers, ETL teams, BI developers, and business usersRequirementsDimensional Modeling (Required - Strong)Strong expertise in star schema and snowflake schema design and modelingAdvanced dimensional modeling techniques (Kimball methodology)Fact table design (additive, semi-additive, non-additive measures) and grain definitionDimension design: conformed dimensions, role-playing dimensions, junk dimensions, slowly changing dimensionsExperience designing datamarts for multiple business domainsDatabase & Tools (Required)Teradata (Must Have): Advanced SQL, performance tuning, indexing strategies, architecture understandingTIBCO: Experience with TIBCO Data Virtualization or TIBCO suite for semantic layerTrino (PrestoSQL): Hands-on experience for distributed SQL and semantic layer implementationOracle SQL and database knowledgeData modeling tools: Erwin, PowerDesignerBusiness & Domain Knowledge (Required)Strong business acumen and understanding of business processes, KPIs, and decision-makingProduct thinking: ability to design solutions focused on business value and user experienceDeep understanding of business metrics, analytics requirements, and reporting needsAbility to translate business language into technical data modelsTelecommunications Domain (Required - Must Have)Deep telecom business knowledge including processes, operations, and analyticsOSS: Network performance, inventory, fault management, service quality metricsBSS: Billing, customer analytics, revenue assurance, churn analysis, product performanceTelecom KPIs: ARPU, churn rate, CLTV, network utilization, service availability, revenue metrics, subscriber growthProfessional SkillsExcellent communication and stakeholder management skillsStrong analytical and problem-solving abilities with business-oriented thinkingFull SDLC experience (Agile/Scrum preferred)Ability to conduct workshops and present to business audiencesPreferred QualificationsBachelor's degree in Computer Science, Business Analytics, or related fieldExperience with BI tools: Tableau, Power BI, Qlik, MicroStrategyKnowledge of data virtualization, MDM, and data governanceUnderstanding of self-service analytics and data democratizationKey DeliverablesStar/snowflake schema dimensional models for datamarts on TeradataSemantic layer models with business entities, KPIs, and relationships using TIBCO and TrinoBusiness KPI definitions, calculations, and business glossaryTechnical specifications and performance optimization recommendationsDocumentation: dimensional models, semantic layer specs, user guides