Overview
Skills
Job Details
Role: Data Modeler
Location: Indianapolis IN and Bay Area CA (onsite)
Duration: Contract
Job Overview:
We are seeking an experienced Data Modeler with strong expertise in star schema modeling and ERwin to join our team. The ideal candidate will have deep domain knowledge of the insurance industry and excel at analyzing requirements, building source-to-target mappings, and collaborating closely with data engineers to implement high-quality data solutions.
Key Responsibilities:
Analyze business requirements and translate them into logical and physical data models using ERwin or similar tools.
Design and implement star schema models optimized for data warehousing and reporting.
Develop comprehensive source-to-target mappings to support ETL processes.
Work closely with data engineers to ensure seamless integration of data models into the broader architecture.
Validate and optimize data models for performance, scalability, and reliability.
Collaborate with stakeholders to understand business needs and ensure alignment with data models.
Provide documentation and maintain version control for all data modeling deliverables.
Required Qualifications:
Proven experience in data modeling, specifically in star schema and dimensional modeling.
Hands-on expertise with ERwin or similar data modeling tools.
Strong domain knowledge of the insurance industry, including familiarity with policy, claims, and underwriting data.
Proficiency in SQL and understanding of relational database management systems.
Ability to create clear and detailed source-to-target mapping documents.
Excellent problem-solving and communication skills, with the ability to interact effectively with technical and non-technical stakeholders.
Preferred Qualifications:
Experience with cloud-based data platforms (e.g., Snowflake, AWS, Azure).
Familiarity with ETL tools like Matilion or similar.