Data Modeller

Job Overview

Job Description

5+ years of experience in data model creation, Good exposure to T-SQL, Comfortable in Writing complex queries
Experience on Azure, understanding of ADLS, Azure blob storage, Azure SQL database
Decent knowledge of databrickspyspark
Experience extracting data from various databases and analyzing large data sets for conversion into useful business information
The business data modeler must have 3-5 years of experience working on data modeling complex data relationships and good functional understanding of Consumer Product terminologies
End-to-end data model development and entity-relationship design from data preparation to the build, validation and calibration of BI data models
Experience using data modeling tools such as PowerDesigner or Erwin
Create Conceptual/Logical/Physical Models for EDW staging, data integration, analytics, and reporting
Lead creation of Enterprise view (integration) of data
Lead model management and version control of data models
Reverse-engineer source system structures for EDW sourcing/landing
Establish Standards, Guidelines, and Best Practices around data modeling initiatives
Publish and communicate models to IT and User Teams
Develop data movement requirements/technical specifications across EDW layers
Create and optimize data structures for reporting and data integration

LEVEL OF EXPERTISE

SQL - 2 years
Azure - 2 years
Data Modeling - 4 years
T SQL - 2 years
Erwin - 2 years