Data Modeler

Job Description

Senior Data Modeler who has good expertise in multiple Databases coming from Specialty Insurance background with London Lloyds Market exposure
Technical Skills:

Very Strong knowledge in Oracle and PostgreSQL Databases and its architecture is required.
Very Strong Knowledge in Azure is required.
· Very strong in OLTP and OLAP/dimensional/Star Schema data modelling is required.
Data Modeling and one time as well as continuous Azure Data Migration experience is required.
Very strong in analyzing and documenting the existing Database Architecture and reverse engineering. 
Very strong in communication to carried out discussion/interaction/Interview with all the stack holders to Capturing and modeling data requirements, data definitions, business rules, data quality requirements and logical/physical data models to ensure data solutions to best fit for the customer needs.
Creating and refining the database designs to fulfill the requirements including regulatory, privacy, quality, governance, data volume, frequency need, and long-term data growth.
Document the data model by clearly defining metadata, data definitions, data relationships/dependencies, data values, data lineage, data restrictions, data retention policies, data usage policies.
Very strong skills to leverage with performance tuning and delivering efficient SQL queries for data management and data extraction.
Knowledge in Oracle to PostgreSQL migration is required.
Exposure in Unix/Python shell scripting