Job Title : Data Modeler – Insurance Domain

Location: Mississauga, ON – Onsite

Type: Contract

Experience: 5+ Years

We are looking for an experienced Data Modeler to design, develop, and maintain enterprise data models supporting insurance operations, reporting, analytics, underwriting, claims, policy administration, risk management, and regulatory reporting.

Key Responsibilities

- Design and maintain Conceptual, Logical, and Physical Data Models.
- Develop ER models and dimensional models, including Star and Snowflake schemas.
- Create data models covering Policy, Claims, Billing, Customer, Broker, Risk, Coverage, and Reinsurance domains.
- Design and optimize databases using MS SQL Server and Snowflake.
- Apply normalization and denormalization techniques based on business and performance requirements.
- Maintain Source-to-Target mappings, metadata, and data dictionaries.
- Support data governance, data quality, audit, and compliance initiatives.
- Collaborate with Business Architecture, Data Engineering, Analytics, and other stakeholders.
- Prepare technical documentation and support Agile delivery.

Must-Have Skills





- 5+ years of hands-on Data Modeling experience.
- Strong experience with Conceptual, Logical, and Physical Data Modeling.
- Robust MS SQL Server experience.
- ER Modeling and Dimensional Modeling.
- Star Schema and Snowflake Schema.
- Snowflake database design.
- Normalization and Denormalization.
- Data Governance, Metadata Management, and Data Quality.
- Experience with ERStudio, PowerDesigner, or Visio.
- Strong analytical, communication, documentation, and stakeholder-management skills.

Nice to Have

Insurance domain experience in

- Policy Administration
- Claims Management
- Billing and Premium
- Underwriting
- Customer and Broker
- Risk and Coverage
- Reinsurance
- Regulatory Reporting

We are committed to fostering an inclusive workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by applicable law.

📌 Data Modeler – Insurance Domain (Mississauga)
🏢 Enterprise Solutions
📍 Mississauga