Senior Data Modeler / Data Analyst

Job Description :

• 7 + years of experience in Data Modeling & Data Analysis, and should have excellent communication and leadership skills.
• Financial Domain knowledge is a plus.
• Should have a strong understanding of cloud data warehouses, such as Snowflake, and data modeling skills using Data Vault 2.0.
• Should have an in-depth understanding of new concepts like Data Lakehouse and should have worked on Big Data sources / tools such as Hive, S3, Trino, HUE, etc.
• Should have done complex (100+ entities / tables) Data Modeling programs in both on-prem and cloud environments .
• Experience in designing normalized, denormalized, relational, dimensional, star, and snowflake schemas for cloud, big data, and on-prem databases using any one of these data modeling tools (Erwin, ER / Studio, Toad Data Modeler, etc.)
• Extensive Data Modeling experience in the same or similar big data and cloud databases, such as Hive, Redshift, Snowflake, and on-prem databases such as Oracle, SQL Server, and DB2
• Should have experience in working with product managers, project managers, business users, applications development team members, DBA teams, and the Data Governance team daily to analyze requirements, design, development, and deployment technical solutions.
• Should have implemented Bill Inmon and Ralph Kimball methodologies to design data warehouses
• Should have an in-depth understanding of Data Warehousing, Data Analysis, Data Profiling, Master Data Management (MDM), Data Quality, Data Lineage, Data Dictionary, Data Mapping, Data Policy, and Data Governance.