Data Modeler

Responsibilities:

•            This role designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases.

•            These solutions support IIG’s Full service and Investments only business with data analytics, reporting, business intelligence, machine learning, data science, and other business interests.

Must have skills:

•            Erwin

•            SQL

•            Experience on working with relational and other databases.

•            Documentation using Confluence and SharePoint

•            Collibra

•            Deep understanding of Data warehouse, Datamart and Data Lake

•            Good Data Profiling skills

•            Hands on experience with AWS databases – such as HIVE, Redshift, and Aurora.

•            Deep understanding of OLTP and OLAP system

•            Deep understanding of Dimensional Modelling, Star schemas, Snowflake schemas

•            Good understanding of ETL VS ELT