Data Modeler

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, and reference data
• Create source-to-target mapping specifications
• Collaborate 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

• Strong experience in relational, dimensional, and enterprise data modeling
• Experience with DWH, ODS, MDM, lakehouse, and semantic modeling
• Strong SQL knowledge
• Proficiency with ERwin, PowerDesigner, SQL Developer Data Modeler, or similar tools
• Deep understanding of facts, dimensions, slowly changing dimensions, keys, hierarchies, and reference data

Preferred Qualifications

• Banking or financial services domain knowledge

About the Company

CoorB is all about digital finance. 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.