EDW Designer
Master WorksRiyadh, Riyadh Region, Saudi Arabia3 days ago
Job descriptionConduct 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 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 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 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 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) 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 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 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 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
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
Business Requirements & Collaboration
Data Validation & Documentation
Development & Implementation
Required Skills
Technical Expertise
Domain Knowledge - Telecommunications
Professional Skills
Preferred Qualifications
Key Deliverables
#J-18808-Ljbffr
Create a job alert for this search
Designer • Riyadh, Riyadh Region, Saudi Arabia
Related jobs
Support the sales team in KSA with technical information and assistance.Prepare technical proposals, quotations, and tender documents.
Analyze customer requirements and provide appropriate product r...Show moreLast updated: 4 days ago
Rentokil Boecker® Landscape Designer is held accountable for the below job responsibilities : .Effectively uncovering client needs and providing compelling solutions.
Meet with client to understand ob...Show moreLast updated: 18 days ago
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...Show moreLast updated: 6 days ago
- Promoted
Designer Engineer
SscegyptRiyadh, Saudi Arabia Save time by importing your resume in one of the following formats : .The hiring team may use this number to contact you about this job.
Include your city, region, and country, so that employers can e...Show moreLast updated: 4 days ago
- Promoted
Instructional Designer
TabbyRiyadh, Saudi Arabia Role Overview We’re on the lookout for an Instructional Designer who can turn complex product changes into crystal-clear, agent-friendly training.
You’ll work closely with Product, CX Ops, and Train...Show moreLast updated: 30+ days ago
- Promoted
Textiles Product Designer and Developer
WhitecollarsRiyadh, Saudi Arabia Company Description Our client is a Saudi retail and E‑commerce company working in the field of home textiles and accessories since 1997, they specialize in premium bedding and bath linens in the S...Show moreLast updated: 14 days ago
Lighting Designer Engineer "Technical Support"
SSC HR SolutionsRiyadh, Riyadh Province, SAQuick Apply
- Promoted
Saudi Senior Designer
VerainteriorRiyadh, Riyadh Region, Saudi Arabia Stable & professional work environment in VERA design & build company since 2011.Work-life balance with two days off per week.
Comprehensive medical insurance to keep you covered.Annual vacation & a...Show moreLast updated: 30+ days ago
- Promoted
EDW Developer
Master WorksRiyadh, Riyadh Region, Saudi Arabia Enterprise Data Warehouse ETL Developer (Ab Initio Specialist).We are seeking an experienced ETL Developer with specialized expertise in Ab Initio for developing complex data integration solutions ...Show moreLast updated: 1 day ago
- Promoted
Designer
Abroad WorkRiyadh, Saudi Arabia Field Service Engineer Low Current System GRAD JOB SUMMARY.When you join Honeywell, you come to be a member of our international team of thinkers, innovators, dreamers and also doers who make the i...Show moreLast updated: 30+ days ago
- Promoted
Designer Engineer
SSC HR SolutionsRiyadh, Riyadh Region, Saudi Arabia Provide scaffolding and temporary works design schemes for various projects.Develop detailed engineering drawings and calculations.
Ensure all designs adhere to the latest codes of practice, UAE reg...Show moreLast updated: 7 days ago
Landscape Designer
Rentokil InitialRiyadh, Riyadh Province, SAQuick Apply
- Promoted
EDW Designer
Master WorksRiyadh, Saudi Arabia 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...Show moreLast updated: 3 days ago
- Promoted
EDW Developer
Master-WorksRiyadh, Saudi Arabia Enterprise Data Warehouse ETL Developer (Ab Initio Specialist) Position Overview We are seeking an experienced ETL Developer with specialized expertise in Ab Initio for developing complex data inte...Show moreLast updated: 3 days ago
- Promoted
Sr Piping Designer
NRLRiyadh, Saudi Arabia NRL’s client, a leading joint venture formed to deliver world-class EPC services within Saudi Arabia’s energy sector, is currently seeking candidates to join their business on long term contracts.T...Show moreLast updated: 30+ days ago
- Promoted
ED IV l / Senior Structural Designer (Offshore)
Wood PLCRiyadh, Saudi Arabia JOB DESCRIPTION Wood is currently recruiting for Senior Structural Designer to work on the engineering and project management services in Al Khobar office, Saudi Arabia.
At Wood, we play our part by...Show moreLast updated: 29 days ago
EDW Designer
Master-WorksRiyadh, Riyadh Province, SAQuick Apply
- Promoted
DESIGN DIRECTOR
Jobs for HumanityRiyadh, Riyadh Region, Saudi Arabia Be among the first 25 applicants.Jobs for Humanity is collaborating with Atkins to build an inclusive and just employment ecosystem.
We support individuals coming from all walks of life.Created by t...Show moreLast updated: 30+ days ago
- Promoted
ED IV l / Senior Structural Designer (Offshore)
WoodRiyadh, Saudi Arabia ED IV l / Senior Structural Designer (Offshore).ED IV l / Senior Structural Designer (Offshore).Wood is currently recruiting for a Senior Structural Designer to work on engineering and project manage...Show moreLast updated: 30+ days ago
- Promoted
Economy Designer
Steer StudiosRiyadh, Riyadh Region, Saudi Arabia Steer Studios' mission is to create a world-leading game studio in Saudi Arabia, producing high-quality games for international audiences.
The studio also aims to develop homegrown IP within Saudi's...Show moreLast updated: 30+ days ago
- Promoted
Datamart Designer
Master-WorksRiyadh, Saudi Arabia 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-fo...Show moreLast updated: 4 days ago