Senior Data Warehouse Architect & Modeler

Chefra Solutions Inc.; Dubai; On-site; AED 300,000 - 520,000; Full time

Job summary

Chefra Solutions Inc. invites applications for a Lead Data Warehouse (DWH) Modeler who will transform complex business information into robust data models across conceptual, logical, and physical layers to support enterprise BI, ML, and data science initiatives.

You will govern standards, optimize performance, and collaborate with cross-functional teams to implement data strategies. The ideal candidate has 10+ years in data warehousing and data modeling, strong SQL, hands-on experience with

Qualifications

• 10+ years of hands-on experience in data warehousing and data modeling.
• Experience with dimensionally modeled data, Enterprise Data Warehouses, and Big Data platforms.
• Deep understanding of conceptual, logical, and physical data design.
• Advanced SQL and OLAP/OLTP concepts (3NF/OLTP, OLAP).
• Knowledge of metadata management and data governance standards.
• Experience with data loading methods, data lakes, and data marts.

Responsibilities

• Design, develop, and maintain data models for the data warehouse, data marts, staging areas, ODS, and big data platforms.
• Translate business requirements into conceptual, logical, and physical data models.
• Assist DBA team with physical data models and implementing ODS, data marts, and data lakes.
• Oversee expansion of data architecture and optimize query performance.
• Define and govern data modeling standards and related development methodologies.
• Collaborate with SMEs and cross-functional teams to implement data strategies.

Skills

Data modeling

Data warehousing

SQL

Communication skills

Independent work

Problem-solving

Leadership

Agile development

Cross-functional collaboration

Education

Bachelor's or master's degree in Computer Science/Data Science

Tools

Erwin

ER/Studio

Power BI

Job description

Chefra Solutions Inc. invites applications for a Lead Data Warehouse (DWH) Modeler who will transform complex business information into robust data models across conceptual, logical, and physical layers to support enterprise BI, ML, and data science initiatives.

You will govern standards, optimize performance, and collaborate with cross-functional teams to implement data strategies. The ideal candidate has 10+ years in data warehousing and data modeling, strong SQL, hands-on experience with