Data Modeler

The Expertise Required

Bachelor’s Degree (or equivalent experience) in Computer Science, Engineering, Information Systems, or a related field.

8+ years of experience in data modeling, database design, or data architecture.

• Strong hands-on experience with:Relational databases (Oracle, PostgreSQL, MySQL)
• SQL development and performance tuning
• Data modeling methodologies (Normalization, Kimball, Inmon)
• Proven experience working with:
• Policy Administration Systems (OIPA preferred, or Guidewire/Duck Creek)
• Highly transactional (OLTP) environments
• Expertise in designing:Dimensional models (Star/Snowflake schemas)
• Normalized operational models
• Canonical / enterprise data models
• Experience with data modeling tools such as Erwin, SAP Power Designer, Hackolade, or equivalent.
• Strong understanding of:Data lifecycle (creation to consumption)
• Data integration patterns (ETL/ELT)
• Data warehousing and operational data stores (ODS)
• Nice-to-Have Qualifications
• Experience with Insurance Domain Modeling.
• Experience with cloud-native data platforms such as Snowflake, Azure Synapse, or AWS Redshift.
• Exposure data lakes and lakehouse architectures.
• Familiarity with data governance frameworks, data lineage, and metadata tools.
• Experience supporting Data Science / ML teams, including feature engineering concepts.
• Knowledge of insurance regulatory and reporting requirements.
• Experience working with large-scale enterprise data ecosystems.