- Company Name
- Saransh Inc
- Job Title
- Data Modeler
- Job Description
-
**Job Title:** Data Modeler – Insurance Domain
**Role Summary:**
Design, develop, and govern conceptual, logical, and physical data models across relational, dimensional, and NoSQL platforms (SQL, AWS Redshift, data lakes, ODS). Translate business and IT requirements into scalable data architectures, ensuring performance, security, and compliance within the life and annuity insurance sector.
**Expectations:**
- Independently deliver high‑quality data models and architecture improvements.
- Collaborate with business, solution, and analytics teams to align data strategy with business goals.
- Proactively identify risks, propose solutions, and maintain modeling standards.
**Key Responsibilities:**
- Create and maintain conceptual, logical, and physical data models for RDBMS, Redshift, ODS, data marts, and data lakes.
- Define and enforce data modeling standards, naming conventions, and best practices.
- Optimize query performance and data architecture scalability.
- Work with stakeholders to gather requirements, map entities, attributes, relationships, and integrity rules.
- Design data flows, integration interfaces, and automated load processes.
- Conduct hands‑on configuration, installation, performance tuning, and proof‑of‑concept sandbox testing.
- Provide guidance to business analysts and developers on model usage and data access.
- Ensure data security, governance, and compliance across all platforms.
**Required Skills:**
- Strong expertise in data modeling (conceptual, logical, physical) for relational and NoSQL databases.
- Proficiency with SQL, AWS Redshift, data warehousing, ODS, data marts, and data lake technologies.
- Experience in performance tuning and query optimization.
- Knowledge of insurance (life & annuity) data domains.
- Ability to define data standards, governance frameworks, and best practices.
- Excellent communication and collaboration skills; ability to work independently.
- Familiarity with data integration, ETL/ELT processes, and data visualization/analytics tools.
**Required Education & Certifications:**
- Bachelor’s degree in Computer Science, Information Systems, Data Management, or related field (or equivalent experience).
- Relevant certifications (e.g., CDMP, AWS Certified Data Analytics, TOGAF) are preferred but not mandatory.