Data Warehouse Consultant

Penta Consulting; Saudi Arabia; On-site; SAR 240,000 - 360,000; Full time

Job summary

Penta Consulting is seeking an experienced Teradata Data Mart & Semantic Layer Developer to join a large-scale banking and financial services programme in Saudi Arabia. You will design, develop, and optimize semantic layers and data marts within Teradata, translating business requirements into scalable data models and robust reporting structures.

You will collaborate with Data Engineering, BI, Analytics and Business teams to ensure data quality, governance, and timely delivery of critical

Qualifications

• Experience in designing semantic layers and data marts in Teradata environments.
• Strong ability to translate business requirements into technical data models.
• Excellent communication with stakeholders and cross-functional teams.

Responsibilities

• Design, develop, and maintain semantic layer and data mart solutions in Teradata.
• Translate business requirements into scalable data models and reporting structures.
• Develop and optimize SQL queries and Teradata BTEQ scripts.
• Collaborate with stakeholders to understand data needs and deliver data solutions.
• Support data models for core banking and financial reporting.

Skills

Semantic Layer Dev

Data Mart Development

Banking Domain Knowledge

Stakeholder Management

Tools

Teradata

BTEQ

SQL

Job description

Contract Type: Contract

Overview

We are seeking an experienced Teradata Data Mart & Semantic Layer Developer to join a large-scale banking and financial services programme. The successful candidate will play a key role in designing, developing, and enhancing semantic layer and data mart solutions within a Teradata environment, supporting critical reporting, analytics, and business intelligence initiatives.

Key Responsibilities

• Design, develop, and maintain Semantic Layer and Data Mart solutions within Teradata environments.
• Translate business and functional requirements into scalable data models and reporting structures.
• Develop, optimise, and troubleshoot complex SQL queries and Teradata BTEQ scripts.
• Collaborate with business stakeholders to understand data requirements and deliver effective data solutions.
• Support the development and enhancement of core banking and financial reporting data models.
• Ensure data quality, consistency, and adherence to enterprise data governance standards.
• Work closely with cross-functional teams including Data Engineering, BI, Analytics, and Business teams.

Required Skills & Experience

• Minimum 4+ years' experience in Semantic Layer and Data Mart development within Teradata projects.
• Strong understanding of Core Banking Data Models and Financial Services Data Models (FSDM).
• Advanced expertise in SQL development and Teradata/BTEQ scripting.
• Proven ability to analyse, interpret, and translate complex business requirements into technical solutions.
• Strong understanding of business processes and data requirements within the financial services and banking sector.
• Experience working in enterprise-scale data warehouse and analytics environments.
• Excellent communication and stakeholder management skills.

Preferred Experience

• Previous experience delivering data solutions for banking or financial institutions.
• Exposure to enterprise data warehousing, reporting, and business intelligence platforms.
• Experience working in Agile delivery environments.

If you are an experienced Teradata professional with strong banking domain knowledge and a passion for delivering high-quality data solutions, we would love to hear from you.