We are seeking an experienced Enterprise Data Warehouse Designer / Modeler with specialized expertise in Teradata environments. The ideal candidate will design robust data warehouse solutions, possess strong telecommunications domain knowledge, and translate complex business requirements into optimized data models.
Experience Required :
Minimum 5+ years in enterprise data warehousing and data modeling
Core Responsibilities Data Modeling & Architecture
Design conceptual, logical, and physical data models for enterprise data warehouses
Specialize in Teradata modeling including partitioning, indexing (PI, SI, NUSI), join indexes, and statistics optimization
Transform source data into target EDW models; design fact / dimension tables and implement SCD Types 1, 2, 3
Data Profiling & Analysis
Conduct data profiling on source systems to identify quality issues, patterns, and anomalies
Analyze source data structures, relationships, and dependencies; perform data lineage and impact analysis
Business Requirements & Collaboration
Understand and analyze business requirements from business units, analysts, and tribes
Collaborate with business tribes (product, marketing, finance, operations), development teams, ETL developers, and DBAs
Conduct discussions with source system owners and subject matter experts
Data Validation & Documentation
Perform source-to-target data validation and reconciliation; execute data quality checks
Create mapping documents, High-Level Design (HLD), Low-Level Design (LLD), and technical specifications
Maintain data dictionary, metadata repository, and operational documentation
Development & Implementation
implement Teradata-specific optimizations
(PI / SI selection, join indexes, statistics, workload management)
Write complex SQL for data analysis and validation; support ETL teams with technical guidance
Required Skills Technical Expertise
Teradata (Required) : Advanced knowledge of architecture, SQL, utilities (BTEQ, FastLoad, MultiLoad, TPT), optimization, partitioning, and indexing
Oracle : Strong experience with PL / SQL and performance tuning
SQL : Expert-level programming across multiple platforms (Teradata, Oracle, SQL Server)
Data modeling tools (Erwin, PowerDesigner); ETL tools exposure (Ab Initio, Informatica)
Data warehouse concepts : Star / snowflake schema, dimensional modeling (Kimball), normalized modeling (Inmon)
Domain Knowledge - Telecommunications
Strong understanding of telecom business processes and data domains
OSS : Network inventory, provisioning, fault / performance management
BSS : Billing, customer / order management, revenue assurance, product catalog
Telecom KPIs : ARPU, churn rate, network utilization, service quality
Professional Skills
Full SDLC experience (Agile / Scrum, Waterfall methodologies)
Product-oriented mindset with strategic thinking and business value focus
Strong analytical, problem-solving skills with attention to detail
Excellent communication skills; ability to explain technical concepts to non-technical stakeholders
Cross-functional collaboration and stakeholder management
Preferred Qualifications
Bachelor's degree in Computer Science, Information Systems, or related field
Teradata certification (Teradata Certified Professional)
Cloud data platforms experience (AWS Redshift, Azure Synapse, Snowflake)
Big data technologies (Hadoop, Spark); MDM and data governance knowledge
Key Deliverables
Comprehensive data models with Teradata-optimized physical designs
Source-to-target mapping documents, HLD / LLD documents, and technical specifications
Data profiling reports, quality assessments, and performance tuning recommendations
#J-18808-Ljbffr
Designer • Riyadh, Saudi Arabia