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