Data Modeller

Role : Data Modeller

Experience: 5-12 Years

Location: Gurugram/Bangalore

Notice Period: Immediate to 45 Days

Your scope of work / key responsibilities:

• Build and maintain out of standards data models to report disparate data sets in a reliable, consistent and interpretable manner.
• Gather, distil, and harmonize data requirements and to design coherent Conceptual, logical and physical data models and associated physical feed formats to support these data flows.
• Articulate business requirements and build source-to-target mappings having complex ETL transformation.
• Write complex SQL statements and profile source data to validate data transformations.
• Contribute to requirement analysis and database design - Transactional and Dimensional data modelling. Normalize/ De-normalize data structures, introduce hierarchies and inheritance wherever required in existing/ new data models.
• Develop and implement data warehouse projects independently.
• Work with data consumers and data suppliers to understand detailed requirements, and to propose standardized data models.
• Contribute to improving the Data Management data models.
• Be an influencer to present and facilitate discussions to understand business requirements and develop dimension data models based on these capabilities and industry best practices.
• Understanding of Insurance Domain
• Basic understanding of AWS cloud
• Good understanding of Master Data Management, Data Quality and Data Governance.
• Basic understanding of data visualization tools like SAS VA, Tableau
• Good understanding of implementing & architecting data solutions using the informatica, SQL server/Oracle

Key Qualifications and experience:

• Extensive practical experience in Information Technology and software development projects of with at least 8+ years of experience in designing Operational data store & data warehouse.
• Extensive experience in any of Data Modelling tools Erwin/ SAP power designer etc.
• Strong understanding of ETL and data warehouse concepts processes and best practices.
• Proficient in Data Modelling including conceptual, logical, and physical data modelling for both OLTP and OLAP.
• Ability to write complex SQL for data transformations and data profiling in source and target systems
• Basic understanding of SQL vs NoSQL databases.
• Possess a combination of solid business knowledge and technical expertise with strong communication skills. Demonstrate excellent analytical and logical thinking.
• Good verbal & written communication skills and Ability to work independently as well as in a team environment providing structure in ambiguous situation.

Interested candidates can share their resume at divya@beanhr.com