Data Modeler

Job Description
8+ years of proven work experience in data modelling related projects as a Data Modeler.
Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
Experience in deploying data models in on-prem and cloud platforms Microsoft Azure / Google Cloud Platform (GCP) / Amazon Web Services (AWS).
Experience in implementing various types of data modeling techniques relational, dimensional modeling, building Entity-Relationship diagram with commendable understanding in relationship building, referential integrity, etc.
Well versed in data warehousing with proficiency in designing various kind of fact tables, dimension tables and putting them all together in star schema, snowflake schema, etc. based on business requirements. Experience in defining data loading strategy, SCD types, CDC methodologies.
Good hands-on experience on Enterprise Data Modeling with proven track record to implement relevant KPIs of Retail industry will be a plus.
Ability to understand data relationships and can design data models that reflects these relationships and facilitates efficient ingestion, processing, and consumption of Data.
Experience in implementation of multiple indexing strategies, partitioning techniques (preferable in Azure SQL Data Warehouse (Synapse)) as part of optimization.
Experience in certain industry leading data modeling tools will be an added advantage.
Excellent problem solving and communication skills; experience in interacting with technical and non-technical stakeholders at all levels.