Senior Data Warehouse Modeling Architect

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

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.