Strategic Data Modeler – DWH, MDM & Analytics

CoorB; As Sudiyah; On-site; OMR 45,000 - 70,000; Full time

Job summary

CoorB is seeking a Data Modeler in Al Buraymi Governorate, Oman, to analyze and design data models across various domains. The ideal candidate will have strong experience in relational and dimensional data modeling, along with knowledge of data warehousing and semantic modeling.

This role requires an understanding of banking or financial services, and familiarity with tools like ERwin and PowerDesigner. Join us to help shape the future of digital finance through innovative solutions.

Qualifications

• Strong experience in relational, dimensional, and enterprise data modeling.
• Experience with DWH, ODS, MDM, lakehouse, and semantic modeling.
• Strong SQL knowledge.
• Experience with ERwin, PowerDesigner, SQL Developer Data Modeler, or similar tools.
• Understanding of facts, dimensions, slowly changing dimensions, keys, hierarchies, and reference data.
• Banking or financial services domain knowledge is preferred.

Responsibilities

• Analyze existing data models across ODS, DWH, EDM, marts, MDM, cubes, and reporting datasets.
• Document current entities, attributes, relationships, keys, hierarchies, and business definitions.
• Identify duplicate entities, inconsistent definitions, and overlapping datasets.
• Design conceptual, logical, and physical data models for the target architecture.
• Design dimensional models including facts, dimensions, aggregates, and Gold-layer datasets.
• Support semantic model design for reporting and analytics.
• Support MDM domain modeling for customer, account, product, reference data, or other domains.
• Create source-to-target mapping specifications.
• Work with Business Analysts to validate business definitions and rules.
• Work with ETL Developers to ensure correct implementation of models.
• Support reconciliation between existing and target data models.

Job description

CoorB is seeking a Data Modeler in Al Buraymi Governorate, Oman, to analyze and design data models across various domains. The ideal candidate will have strong experience in relational and dimensional data modeling, along with knowledge of data warehousing and semantic modeling.

This role requires an understanding of banking or financial services, and familiarity with tools like ERwin and PowerDesigner. Join us to help shape the future of digital finance through innovative solutions.