Register Login

  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role.
Get Resume Score
Saudi Arabia Jobs Expertini

Datamart Developer Job Opening In Riyadh – Now Hiring Master-Works

Datamart Developer

    Saudi Arabia Jobs Expertini Expertini › Saudi Arabia › Jobs › Riyadh › Computer Occupations › Datamart Developer

Job description

We are seeking an experienced Datamart / Semantic Layer Developer to develop and implement business-oriented datamarts and semantic layers on Teradata EDW, CDP Hive, and Trino platforms.

The candidate must possess strong SQL development skills, dimensional modeling knowledge, telecommunications domain expertise, and ability to translate technical specifications into optimized analytics solutions.

Experience Required: Minimum 5+ years in datamart development and semantic layer implementation

Core Responsibilities

Datamart Development

  • Develop and implement star schema and snowflake schema dimensional models on Teradata EDW
  • Build subject-area datamarts (Customer, Revenue, Network, Product, Finance) based on design specifications
  • Create and optimize fact tables, dimension tables, bridge tables, and aggregate tables
  • Implement slowly changing dimensions (SCD Types 1, 2, 3) logic and dimensional hierarchies
  • Develop complex SQL queries, stored procedures, and views for datamart population
  • Implement data transformation and aggregation logic for business metrics and KPIs

Semantic Layer Development

  • Develop semantic layers using TIBCO Data Virtualization on Teradata and CDP platforms
  • Build semantic models using Trino for distributed query processing and data access
  • Create virtual views, materialized views, and business-friendly data abstractions
  • Implement business logic, calculated measures, KPIs, and derived metrics in semantic layer
  • Develop data access policies, row-level security, and governance rules
  • Optimize semantic layer performance through caching, indexing, and query optimization

Multi-Platform Development

  • Work across Teradata, CDP Hive, and Trino platforms for datamart and semantic layer implementation
  • Develop HiveQL queries and tables in CDP (Cloudera Data Platform) environment
  • Integrate data from Teradata EDW and CDP Hive through Trino for unified semantic access
  • Create cross-platform queries and federated views using Trino connectors
  • Implement partitioning, bucketing, and optimization strategies in Hive tables

Implementation & Optimization

  • Translate design documents (HLD, LLD) and mapping specifications into SQL code
  • Develop ETL/ELT processes to populate datamarts from EDW sources
  • Optimize query performance using indexing (PI, SI, NUSI), statistics, partitioning, and aggregations
  • Conduct unit testing, data validation, and reconciliation between source and target
  • Debug and troubleshoot performance issues in datamarts and semantic layers

Collaboration & Documentation

  • Work closely with datamart designers, EDW developers, BI teams, and business analysts
  • Implement business requirements and KPI calculations as per specifications
  • Create technical documentation: SQL scripts, deployment guides, data lineage
  • Support UAT activities and assist business users in validating data accuracy
  • Provide production support and resolve data or performance issues

Requirements

Required Skills

SQL & Development (Required - Strong)

  • Teradata (Must Have): Advanced SQL development, stored procedures, performance tuning, utilities (BTEQ, TPT)
  • Strong understanding of Teradata architecture, indexing (PI, SI, NUSI), partitioning, and statistics
  • CDP Hive: HiveQL development, table creation, partitioning, bucketing, optimization in Cloudera environment
  • Trino (PrestoSQL): SQL development using Trino, federated queries, connector configuration
  • Expert-level SQL across multiple platforms for complex queries and transformations
  • Oracle SQL and PL/SQL development experience

Semantic Layer & Tools (Required)

  • TIBCO: Hands-on development experience with TIBCO Data Virtualization for semantic layer implementation
  • Experience creating virtual views, business views, and semantic models in TIBCO
  • Understanding of data virtualization concepts and query federation
  • Knowledge of BI tool integration with semantic layers

Dimensional Modeling Knowledge

  • Strong understanding of star schema and snowflake schema dimensional models
  • Knowledge of fact table design, dimension design, and SCD implementations
  • Ability to translate dimensional models into physical database objects
  • Understanding of dimensional modeling best practices (Kimball methodology)

Telecommunications Domain (Required)

  • Understanding of telecom business processes, KPIs, and data flows
  • OSS: Network performance, inventory, fault management metrics
  • BSS: Billing, customer analytics, revenue, churn, product performance
  • Telecom KPIs: ARPU, churn rate, CLTV, network utilization, revenue metrics

Professional Skills

  • Full SDLC experience (Agile/Scrum, Waterfall)
  • Strong analytical and debugging skills for performance troubleshooting
  • Good communication skills for technical collaboration
  • Unix/Linux scripting for automation (plus)
  • Version control: Git, SVN

Preferred Qualifications

  • Bachelor's degree in Computer Science, Information Technology, or related field
  • Experience with data profiling and data quality tools
  • Knowledge of ETL tools (Ab Initio, Informatica)
  • Understanding of data governance and metadata management
  • Experience with BI tools: Tableau, Power BI, Qlik

 

Key Deliverables

  • Developed and deployed datamarts (star/snowflake schema) on Teradata
  • Semantic layer implementations using TIBCO and Trino with business views and virtual tables
  • Optimized SQL code, stored procedures, and views for datamarts
  • HiveQL scripts and tables in CDP environment
  • Technical documentation: SQL scripts, deployment guides, data lineage
  • Unit tested code with data validation and reconciliation reports

Performance tuning recommendations and optimization implementations

Required Skill Profession

Computer Occupations


  • Job Details

Related Jobs

Master-Works hiring Datamart Designer Job in Riyadh, Riyadh Province, Saudi Arabia
Master-Works
Riyadh, Riyadh Province, Saudi Arabia
Thales hiring Software Developer Job in Jeddah, Makkah Province, Saudi Arabia
Thales
Jeddah, Makkah Province, Saudi Arabia
Master-Works hiring WebMethods Developer Job in Riyadh, Riyadh Province, Saudi Arabia
Master-Works
Riyadh, Riyadh Province, Saudi Arabia
SBM hiring SharePoint Developer Job in Al-Zahra'a, Makkah Province, Saudi Arabia
SBM
Al-Zahra'a, Makkah Province, Saudi Arabia
BOL hiring Mobile Developer Job in Riyadh, Riyadh Province, Saudi Arabia
BOL
Riyadh, Riyadh Province, Saudi Arabia
Master-Works hiring BI Developer. Job in Riyadh, Riyadh Province, Saudi Arabia
Master-Works
Riyadh, Riyadh Province, Saudi Arabia
Master-Works hiring EDW Developer Job in Riyadh, Riyadh Province, Saudi Arabia
Master-Works
Riyadh, Riyadh Province, Saudi Arabia
Arthur Lawrence hiring Java Developer Job in Riyadh, Riyadh Province, Saudi Arabia
Arthur Lawrence
Riyadh, Riyadh Province, Saudi Arabia
Xperts4 hiring OPF Developer Job in Saudi Arabia
Xperts4
Saudi Arabia
Master-Works hiring P360 Developer Job in Riyadh, Riyadh Province, Saudi Arabia
Master-Works
Riyadh, Riyadh Province, Saudi Arabia
Arthur Lawrence hiring Sharepoint Developer Job in Al Jubail, Eastern Province, Saudi Arabia
Arthur Lawrence
Al Jubail, Eastern Province, Saudi Arabia
Müller`s Solutions hiring PEGA Developer Job in Riyadh, Riyadh Province, Saudi Arabia
Müller`s Solutions
Riyadh, Riyadh Province, Saudi Arabia
BOL hiring .Net Developer Job in Riyadh, Riyadh Province, Saudi Arabia
BOL
Riyadh, Riyadh Province, Saudi Arabia
Master-Works hiring BI developer Job in Al Khobar, Eastern Province, Saudi Arabia
Master-Works
Al Khobar, Eastern Province, Saudi Arabia
BOL hiring Backend Developer Job in Riyadh, Riyadh Province, Saudi Arabia
BOL
Riyadh, Riyadh Province, Saudi Arabia
Master-Works hiring BI developer.. Job in Riyadh, Riyadh Province, Saudi Arabia
Master-Works
Riyadh, Riyadh Province, Saudi Arabia
Tamkeen Technologies hiring Odoo Developer Job in Riyadh, Riyadh Province, Saudi Arabia
Tamkeen Technologies
Riyadh, Riyadh Province, Saudi Arabia
Tap Payments hiring Developer Experience Lead Job in Riyadh, Riyadh Province, Saudi Arabia
Tap Payments
Riyadh, Riyadh Province, Saudi Arabia
Master-Works hiring Data Governance Developer Job in Riyadh, Riyadh Province, Saudi Arabia
Master-Works
Riyadh, Riyadh Province, Saudi Arabia
Squadio hiring SharePoint developer - SAUDI Job in Riyadh, Riyadh Province, Saudi Arabia
Squadio
Riyadh, Riyadh Province, Saudi Arabia
Squadio hiring odoo FrontEnd Developer Job in Riyadh, Riyadh Province, Saudi Arabia
Squadio
Riyadh, Riyadh Province, Saudi Arabia
700Apps hiring Oracle APEX Developer Job in Riyadh, Riyadh Province, Saudi Arabia
700Apps
Riyadh, Riyadh Province, Saudi Arabia
CONNECTING 2 WORK hiring Sr. IOS developer Job in Riyadh, Riyadh Province, Saudi Arabia
CONNECTING 2 WORK
Riyadh, Riyadh Province, Saudi Arabia
Mace hiring Power BI Developer Job in Riyadh, Riyadh Province, Saudi Arabia
Mace
Riyadh, Riyadh Province, Saudi Arabia
SBM hiring Sr. Drupal Developer Job in Al-Zahra'a, Makkah Province, Saudi Arabia
SBM
Al-Zahra'a, Makkah Province, Saudi Arabia
Master-Works hiring Senior Java Developer Job in Riyadh, Riyadh Province, Saudi Arabia
Master-Works
Riyadh, Riyadh Province, Saudi Arabia
Client Of Digifocal It Solutions Private Limited hiring Sailpoint iiq developer Job in Riyadh, Riyadh Province, Saudi Arabia
Client Of Digifocal It Solutions Private Limited
Riyadh, Riyadh Province, Saudi Arabia
Master-Works hiring Back-end Developer Job in Riyadh, Riyadh Province, Saudi Arabia
Master-Works
Riyadh, Riyadh Province, Saudi Arabia

Unlock Your Datamart Developer Potential: Insight & Career Growth Guide


Real-time Datamart Developer Jobs Trends (Graphical Representation)

Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph here. Uncover the dynamic job market trends for Datamart Developer in Riyadh, Saudi Arabia, highlighting market share and opportunities for professionals in Datamart Developer roles.

83 Jobs in Saudi Arabia
83
61 Jobs in Riyadh
61
Download Datamart Developer Jobs Trends in Riyadh and Saudi Arabia

Are You Looking for Datamart Developer Job?

Great news! is currently hiring and seeking a Datamart Developer to join their team. Feel free to download the job details.

Wait no longer! Are you also interested in exploring similar jobs? Search now: .

The Work Culture

An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at Master-Works adheres to the cultural norms as outlined by Expertini.

The fundamental ethical values are:

1. Independence

2. Loyalty

3. Impartiapty

4. Integrity

5. Accountabipty

6. Respect for human rights

7. Obeying Saudi Arabia laws and regulations

What Is the Average Salary Range for Datamart Developer Positions?

The average salary range for a varies, but the pay scale is rated "Standard" in Riyadh. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.

What Are the Key Qualifications for Datamart Developer?

Key qualifications for Datamart Developer typically include Computer Occupations and a list of qualifications and expertise as mentioned in the job specification. The generic skills are mostly outlined by the . Be sure to check the specific job listing for detailed requirements and qualifications.

How Can I Improve My Chances of Getting Hired for Datamart Developer?

To improve your chances of getting hired for Datamart Developer, consider enhancing your skills. Check your CV/Résumé Score with our free Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.

Interview Tips for Datamart Developer Job Success

Master-Works interview tips for Datamart Developer

Here are some tips to help you prepare for and ace your Datamart Developer job interview:

Before the Interview:

Research: Learn about the Master-Works's mission, values, products, and the specific job requirements and get further information about

Other Openings

Practice: Prepare answers to common interview questions and rehearse using the STAR method (Situation, Task, Action, Result) to showcase your skills and experiences.

Dress Professionally: Choose attire appropriate for the company culture.

Prepare Questions: Show your interest by having thoughtful questions for the interviewer.

Plan Your Commute: Allow ample time to arrive on time and avoid feeling rushed.

During the Interview:

Be Punctual: Arrive on time to demonstrate professionalism and respect.

Make a Great First Impression: Greet the interviewer with a handshake, smile, and eye contact.

Confidence and Enthusiasm: Project a positive attitude and show your genuine interest in the opportunity.

Answer Thoughtfully: Listen carefully, take a moment to formulate clear and concise responses. Highlight relevant skills and experiences using the STAR method.

Ask Prepared Questions: Demonstrate curiosity and engagement with the role and company.

Follow Up: Send a thank-you email to the interviewer within 24 hours.

Additional Tips:

Be Yourself: Let your personality shine through while maintaining professionalism.

Be Honest: Don't exaggerate your skills or experience.

Be Positive: Focus on your strengths and accomplishments.

Body Language: Maintain good posture, avoid fidgeting, and make eye contact.

Turn Off Phone: Avoid distractions during the interview.

Final Thought:

To prepare for your Datamart Developer interview at Master-Works, research the company, understand the job requirements, and practice common interview questions.

Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the Master-Works's products or services and be prepared to discuss how you can contribute to their success.

By following these tips, you can increase your chances of making a positive impression and landing the job!

How to Set Up Job Alerts for Datamart Developer Positions

Setting up job alerts for Datamart Developer is easy with Saudi Arabia Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!