Data Modeler

Responsibilities

• Participate and lead discussions with business leads, subject matter experts, and stakeholders to understand application project scope and Business Requirements. Translate Business Requirements into Data Requirements
• Understand the data elements and their domains; understand relationships among those elements and inter-dependencies between models.
• Use acquired knowledge and develop Logical Data Models, Physical Data Models, and Data Element Dictionaries
• Develop maintenance processes for data modeling artifacts
• Oversee data mapping for data conversion from legacy data stores and formats to new data structures. Perform architectural alignment with enterprise formats
• Perform impact analysis of changes to existing models
• Determine practicality and technical fit of developed standards and architectures

Skills, Knowledge and Experience:

• Expert knowledge on various Data modeling techniques that are suitable for ODS/EDW/Data Lake/Analytical Stores.
• Five years' hands-on experience with physical and relational data modeling experience with ER Studio/ERwin
• Expert knowledge of metadata management and related tools
• Experience with SQL Server/Hive/HBASE/SnowFlake/AWS Redshift Database
• Working knowledge in the creation of data infrastructure - such as views, stored procedures, ETL usage, real-time/streaming data integration
• Experience in system/business / data analysis related to data migration and data integration projects
• Knowledge of the development of data models compliant with non-functional enterprise requirements, such as security and performance guidelines
• Deep understanding of data flow diagrams, system architecture diagrams, functional and system analysis
• Prior experience with insurance or financial services industry highly desirable and knowledge of industry standard data models