KGS : : MC : : Data Modeler
Roles and Responsibilities :
Model data sourced from Insurance policy and claims administration, financial reporting, investments, expenses and actuarial systems
Work with cross functional teams to analyze source data, data dictionary and develop high level and detailed data, access models, assist in conducting business and technical data assessments and document requirements.
Conduct gap analysis on a variety of data sets - systems of record, other data sources, data preparation, enrichment and transformation requirements
Ability to create and maintain conceptual data models, high complexity logical and physical data models.
Assist the design team in the transformation of these data models to physical database implementation. The physical deployment of logical data models are performed by the client.
The data modeler will need to interact with the client to communicate changes, assist in deployment of the data model
Document target state end-end data flows and representations.
Requirements for this role :
Minimum 4 years leading Data Analysis in a Financial Services Environment preferably Insurance
Knowledge of Insurance data model is highly desirable. Experience working in any of the following insurance products would be highly desirable -
Life, Group Benefits, Annuity, Pension, Property and Casualty products
Experience working in Full Life Cycle Data implementations
Experience developing information models using Data Modeling Tools like ERWIN etc,.
Experience supporting RDBMS platforms like Oracle, SQL Server.
Experience with data analysis for Finance data sourcing, business processes and reporting. Understanding of data requirements in audit and control framework (Sarbanes-Oxley, BCBS 239)
Experience delivering Finance data acquisition and developing various representations of data from Data Landing to Reporting -
Landing, Staging, Aggregations, Subject areas, dimensions
Experience in data warehousing implementation projects will be an added advantage.
Qualifications and Skills
BE / Btech / MCA
Experience and Background :
Total years of experience : 5- 8 years