Description

Design and maintain conceptual, logical, and physical data models to ensure integrity, performance, and scalability. Own the end-to-end data modeling lifecycle from requirements gathering to documentation.

Responsibilities

• Develop and maintain comprehensive data models using ERWin, ensuring consistency and adherence to naming conventions.
• Partner with business analysts and data architects to translate requirements into effective data model designs.
• Conduct exploratory data analysis (EDA) to identify trends and drive business decisions.
• Create and maintain documentation for data mapping, integration processes, data dictionaries, and data lineage.
• Establish and uphold standards for metadata management and data modeling best practices.

Required Skills

• 10+ years of experience in data modeling and database design.
• Strong proficiency in ERWin for data modeling and database design.
• Expertise in Data Mapping & Integration and SQL/ANSI SQL.
• Proven ability to conduct Exploratory Data Analysis (EDA).
• Experience with column databases and optimizing data structures for performance.
• Strong documentation skills for data dictionaries and lineage.

Preferred Skills

• Experience in building Data Warehouses.
• Familiarity with insurance data structures and processes.

Key Skills

Education

Any Graduate