Data Modeller

Job Description

Role & responsibilities 8+ years experiences with data analytics, data modeling or data architecture and database design. Experience in data modeling or data architecture in transactional and operational reporting and analytical (EDW, Data Lake, NoSQL) solutions. Experience with Dimensional Modeling / Data Warehouse Modeling Data modeling, data warehousing, dimensional modeling, data modeling for big data and metadata management. Experience using (Erwin, TOAD, or any other data modeling tool) for data modeling. Understanding of enterprise and reporting modeling concepts, including dimensional modeling, snowflakes, slowly changing dimensions, schema on read, irregular dimensions, and surrogate, compound and intelligent keys. Experience with capacity planning, database scripting and package deployment Good knowledge of data replication methodology. Good knowledge of data warehouse, data mart and Data Lake Experience with AWS and cloud-based databases and data warehouses. Strong Knowledge of Structured Query Language (SQL) and use in data access and analysis. Excellent communication, problem solving, organizational and analytical skills Strong communication and interpersonal skills.