Data Modeler

ABOUT CoorB

We build full-fledged innovative solutions with a focus on process automation, user experience enhancement, and advanced data analytics. With our extensive industry expertise, we help achieve operational excellence, future-proof your IT investments, and ensure a competitive edge in the ever-evolving finance industry.

OUR OPPORTUNITY

The Data Modeler analyzes existing data structures and designs target-state conceptual, logical, physical, dimensional, and semantic models.

YOU WILL

• 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. 
  

• TO BE SUCCESSFUL IN THE ROLE YOU NEED
  

• 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.