Data Warehouse Modeling Engineer (Senior)

Click Global Talent; Kuala Lumpur; On-site; MYR 180,000 - 280,000; Full time

Benefits offered by this job

Banking/Financial industry experience

FSDM/TD-FSDM data model familiarity

Job summary

Click Global Talent is seeking a Senior Data Warehouse Modeling Engineer to lead the design of data warehouse models, including table structures, field definitions, and processing logic for foundational and common summary layers, ensuring scalability and consistency.

You will define 3NF foundational models, establish star/snowflake schemas, document metadata and ETL mappings, and optimize for performance and cost while collaborating with cross‑functional teams in a banking context.

Qualifications

• Bachelor’s degree or above in Computer Science, Software Engineering, Data Science, Mathematics or related disciplines; at least 3 years of data warehouse modeling experience.
• Proficient in data warehouse layering theory, 3NF modeling, dimensional modeling, and SCD handling.
• Hands-on experience in metric system design and defining metric calibers and relationships.
• Familiar with master data, data quality and governance frameworks; strong data quality awareness.
• Able to translate business logic into standardized models and metrics; strong communication.

Responsibilities

• Lead data warehouse model design including table structure, field definitions and processing logic for foundational and common summary layers.
• Define business logic and data lineage across multiple systems to support cross‑domain integration.
• Design fact and dimension tables using Kimball methodologies (star/snowflake) and unify metrics.
• Formulate modeling specifications: naming, partitioning, constraints and metadata standards.
• Create and maintain model design docs, data dictionaries and ETL mappings to improve collaboration and O&M efficiency.
• Iterate daily to optimize models, address redundancy, performance bottlenecks and storage/cost issues.

Skills

Data warehouse modeling

3NF modeling

Dimensional modeling

Star schema

Snowflake schema

Metrics design

SQL proficiency

Problem solving

Team collaboration

Communication

Education

Bachelor’s degree or above in Computer Science or related field

Tools

SQL

Job description

Data Warehouse Modeling Engineer (Senior)

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

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 significantly reduce

4. Formulate and implement modeling specifications, covering table and field

naming, coding rules, partitioning strategies, primary and foreign key constraints,

and metadata standards, to guarantee the consistency, standardization and

maintainability of models in the entire warehouse.

5. Compile and maintain model design documents, data dictionaries and ETL

mapping logic documents, accumulate model assets, and improve team

collaboration and subsequent O&M efficiency.

6. Be responsible for daily iteration and optimization of models, and targetedly

resolve core issues such as model redundancy, query performance bottlenecks,

excessive storage and computing costs, and slow response.

Requirements

1. Bachelor’s degree or above, majoring in Computer Science, Software

Engineering, Data Science, Mathematics or related disciplines; at least 3 years of

data warehouse modeling experience. Prior experience in banking, finance,

telecommunications or other relevant industries is preferred.

2. Proficient in data warehouse layering theory, 3NF modeling, dimensional

modeling, and handling strategies for slowly changing dimensions.

3. Hands-on experience in metric system design, capable of clearly defining metric

calibers and the relationship between atomic metrics and derived metrics;

experience in implementing metric platforms or metric management is preferred.

4. Familiar with master data, data standardization, data quality and other data

governance frameworks, with strong awareness of data quality, and capable of

independently identifying and troubleshooting data issues.

5. Proficient in SQL for data exploration and validation, able to independently

conduct data research on source systems, and accurately identify data

characteristics and business rules.

6. Possess sound logical thinking and communication skills. Able to translate

business logic of source systems into standardized models and business analysis

demands into metric systems, with emphasis on caliber unification and accuracy,

and experience in team collaboration.

Nice to Have

1. Practical experience in data warehouse / data platform model design within

banking or financial industries.

2. Familiar with the theories and implementation practices of IBM FSDM or TD

FSDM industry data models.