Greetings from Doodleblue Innovations!
We are hiring for a Data Modeler – Insurance Lakehouse | Freelance Opportunity
Work Mode: Remote
Experience: 12 Years (6+ years in Data Modelling)
Are you an experienced Data Modeler with expertise in Insurance, Data Warehousing, and Lakehouse Architecture? We're looking for a skilled professional to join our team and help modernize a global insurance lakehouse platform.
Primary Skills:
- Data Modelling (Conceptual, Logical & Physical)
- Kimball Dimensional Modelling & 3NF
- Data Vault 2.0
- Databricks & Delta Lake
- Medallion
- Canonical model, SCD
- SQL
- Data Warehousing & Lakehouse Architecture
- Data Modelling Tools – erwin, ER/Studio, SqlDBM, PowerDesigner
- Insurance Domain Modelling (P&C Preferred)
- Metadata Management & Version Control
Secondary Skills:
- Unity Catalog, Microsoft Purview, Collibra
- ACORD or Insurance Data Models
- Graph/Semantic Modelling
- dbt Model Governance
- CDMP Certification
Key Responsibilities:
- Design and maintain conceptual, logical, and physical data models for insurance domains including Policy, Claims, Premium, Reinsurance, Party, and Finance
- Develop scalable dimensional models, star schemas, conformed dimensions, and SCD strategies for Databricks/Delta Lake.
- Define business keys, surrogate keys, historization strategies, and master data structures.
- Create build-ready modelling artefacts including DDLs, data models, and mapping documents.
- Lead model governance, version control, impact analysis, and change management processes.
- Collaborate with architects, business analysts, data engineers, and business SMEs to deliver high-quality data models.
- Align enterprise data models with insurance industry standards and modern lakehouse architecture.
- Support BI and reporting teams by enabling optimized semantic models and analytical structures.
- Review engineering implementations to ensure model accuracy, performance, and scalability.
- Act as the primary modelling expert and collaborate closely with offshore development teams.
Qualification: Bachelor's or Master's degree in Computer Science, Information Systems, Mathematics, or a related discipline.
Interested candidates can share their resumes to [email protected]
Job Types: Full-time, Permanent
Pay: Up to ₹220,000.00 per month
Application Question(s):
- Are you interested in a freelance opportunity?
- How many years of experience do you have as a Data modeller?
- How many years of experience do you have in the P&C Insurance domain?
Experience:
- Data modelling: 6 years (Required)
Work Location: Remote
