Description
Data Modeller(ErWin, SQLDBM, Snowflake)
Total Experience: 10+ years
- Significant proven experience (10+ years) in applying rigorous data management principles and industry standard development approach to model complex and high-volume data assets to build, maintain conceptual, logical, and physical data models
- Demonstrable experience using data modelling tools - eg, ErWin, SQLDBM, Snowflake
- Evaluate existing data models and physical databases for variances and discrepancies
- Experience with managing meta data for data models
- Create entity-relationship diagrams for relational systems and dimensional diagrams for the existing and proposed Data Warehouse, Data Marts, and data cubes
- Define ownership, obtain approvals, and communicate data models to Technology teams. Ensure consistent enterprise view and usage of data assets across the global functions and standards
- Provide architectural expertise in Data warehouse construction and engineering, data source identification, engineering, and migration on latest DB technologies - Snowflake
- Provide feedback to Business Intelligence project and management team to improve data acquisition (structured and unstructured), warehousing methodologies and tools
- Cross industry experience is preferred, Quick service restaurant/Retail will be preferred
- Datamodelling experience across large volume based (Tb/Petabytes) environments
- Experience with the technologies in the Hadoop ecosystem like Hadoop, HDFS, Spark, and Hive is a plus
- Experience in working with modern cloud data platforms in AWS (preferred)
- Strong skills in Entity Relationship Modeling (ERWin modelling software preferred)
- Good knowledge about Database Designing/Administration, Advanced Data Modeling for Star Schema design
- SQL query development for investigation and analysis
- Experience with Data Profiling Tools and BI tools like MicroStrategy will be plus