ABOUT <\/span><\/span><\/span><\/span>CoorB<\/span><\/span><\/span><\/b>
<\/span><\/span><\/p><\/div>We build full\-fledged innovative solutions with a focus on process automation, user experience enhancement, and advanced data analytics. With our extensive industry <\/span>expertise, we help achieve operational excellence, future\-proof your IT investments, and ensure a competitive edge in the ever\-evolving finance industry.<\/span><\/span><\/span>
<\/span><\/span><\/p><\/div>
<\/span><\/span><\/p><\/div>OUR OPPORTUNITY<\/span><\/span><\/span>
<\/span><\/span><\/p><\/div>The Data Modeler analyzes existing data structures and designs target\-state conceptual, logical, physical, dimensional, and semantic models.<\/span><\/span><\/span>
<\/span><\/span><\/p><\/div>YOU WILL<\/span><\/span><\/span>
<\/span><\/span><\/p><\/div>- Analyze existing data models across ODS, DWH, EDM, marts, MDM, cubes, and reporting datasets.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Document current entities, attributes, relationships, keys, hierarchies, and business definitions.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Identify\u202fduplicate entities, inconsistent definitions, and overlapping datasets.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Design conceptual, logical, and physical data models for the target architecture.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Design dimensional models including facts, dimensions, aggregates, and Gold\-layer datasets.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Support semantic model design for reporting and analytics.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Support MDM domain modeling for <\/span>customer, <\/span>account, <\/span>product, reference data, or other domains.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Create source\-to\-target mapping specifications.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Work with Business Analysts to\u202fvalidate\u202fbusiness definitions and rules.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Work with ETL Developers to ensure correct implementation of models.\u202f<\/span><\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Support reconciliation between existing and target data models. <\/span><\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div><\/div><\/span>
Requirements<\/h3>TO BE SUCCESSFUL IN THE ROLE YOU NEED<\/span><\/span><\/span>
<\/span><\/span><\/p><\/li><\/ul>- Strong experience in relational, dimensional, and enterprise data modeling.\u202f<\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div><\/div>- Experience with DWH, ODS, MDM,\u202f<\/span>lakehouse<\/span>, and semantic modeling.\u202f<\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Strong SQL knowledge.\u202f<\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Experience with\u202f<\/span>ERwin<\/span>,\u202f<\/span>PowerDesigner<\/span>, SQL Developer Data Modeler, or similar tools.\u202f<\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Understanding of<\/span>\u202ffacts, dimensions, slowly changing dimensions, keys, hierarchies, and reference data.\u202f<\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div>- Banking or financial services domain knowledge is preferred<\/span>.<\/span><\/span><\/span>
<\/span><\/li><\/ul><\/div><\/div>
<\/span><\/li><\/ul><\/span>
