EDW Designer

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.
• Specialized 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 profiling on source systems to identify quality issues, patterns, anomalies, and perform data lineage and impact analysis.
• Business Requirements & Collaboration : understand and analyze business requirements from business units, analysts, and tribes; collaborate with product, marketing, finance, operations, ETL developers, DBAs; conduct discussions with source system owners and SMEs.
• Data Validation & Documentation : perform source-to-target data validation and reconciliation; execute data quality checks; create mapping documents; produce HLD, LLD, and technical specifications.
• Development & Implementation Design : design and optimize database objects; 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

Teradata (Required) : advanced knowledge of architecture, SQL, utilities (BTEQ, FastLoad, MultiLoad, TPT), optimization, partitioning, and indexing.

Telecommunications : strong understanding of telecom business processes and data domains.

Full SDLC experience (Agile / Scrum, Waterfall methodologies).

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

#J-18808-Ljbffr