Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Click Global Talent

New

Senior Data Warehouse Modeling Architect

Posted Updated

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.

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. 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. Banking/Financial industry experience FSDM/TD-FSDM data model familiarity

Skills

What Senior Architecture jobs ask for — and how much of it you have →
Apply

See also

Architecture jobs by country — openings, pay and top skills →