Data Warehouse Modeling Engineer (Senior)
Click Global Talent
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