Senior Data Modeller
About The Position
The IT Data Modeler is responsible for designing, developing, and maintaining enterprise data models that support insurance operations, reporting, analytics, underwriting, claims, policy administration, risk management, and regulatory reporting. The role requires strong expertise in insurance data concepts, relational database design, data modeling methodologies, and data governance practices. A strong candidate will have 5+ years of Data Modeling experience, deep knowledge of relational databases and table design, and practical experience in the Property & Casualty Insurance industry including Policy, Claims, Underwriting, Risk, and Premium data structures.
Requirements
- 5+ years Data Modeling and Database Design experience.
- 3+ years Property & Casualty Insurance experience.
- Strong knowledge of insurance business processes and enterprise data structures.
- Conceptual, Logical & Physical Data Modeling
- ER Modeling and Dimensional Modeling (Star/Snowflake)
- Snowflake, Database Design, Normalization, Denormalization
- Data Governance, Metadata Management, Data Quality
- ER/Studio, PowerDesigner, Visio
- Policy Administration, Claims Management, Underwriting, Risk & Exposure, Premium & Billing, Coverage & Endorsements, Broker & Customer Data, Regulatory Reporting.
- Strong analytical thinking, stakeholder management, communication, problem solving, collaboration, documentation, and Agile delivery experience.
Nice To Haves
- Azure Data Services knowledge
- Data Warehousing/Data Lake experience
- Familiarity with MDM and Data Governance frameworks.
Responsibilities
- Design conceptual, logical, and physical data models.
- Create models for Policy, Claims, Billing, Customer, Broker, Risk, Coverage, and Reinsurance domains.
- Develop dimensional models for reporting and analytics.
- Maintain source-to-target mappings, metadata, and data dictionaries.
- Support database optimization, data quality, governance, audit, and compliance initiatives.
- Collaborate with Business, Architecture, Engineering, and Analytics teams.
Benefits
- Vacation: 12-25 days, depending on grade
- Company paid holidays
- Personal Days
- Sick Leave
- Medical, dental, and vision coverage
- Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
- Life and disability insurance
- Employee assistance programs
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
