Data Warehouse Modeling Engineer (Senior)

Click Global Talent

📍 Kuala Lumpur, Malaysia On-Site ⏳ 1d ago
AI assistant

Job Description

Salary: RM 15,000 – RM 20,000 per month

Key Responsibilities

1. Take charge of data warehouse model design, including table structure planning,

field definition and processing logic mapping for the foundational model layer and

common summary layer, to ensure the rationality and scalability of the model

architecture.

2. Sort out business logic and data lineage of various business systems, and

conduct foundational-layer subject domain modeling based on 3NF to support

cross-domain data integration and unified centralized management across the

bank.

3. Design fact tables and dimension tables following the Kimball dimensional

modeling methodology (star schema / snowflake schema). Settle common

requirements for reports, dashboards, BI and special analysis into reusable

common summary models, unify metric calibers and processing logic, eliminate

caliber conflicts across teams and applications, and