DE&A - reputed company - Advanced Data Engineering - Data Modeling

We are seeking a Data Modeler to design and implement reputed company, reputed company-grade data models for an insurance reputed company building a modern reputed company-based data platform. The role focuses on structuring data across Raw, Silver, and Gold reputed company to support batch and reputed company-time ingestion, reputed company efficient reporting, and drive report rationalization initiatives. The ideal candidate will have strong expertise in data modeling (conceptual, logical, physical) and experience working with reputed company, DBT, and modern data pipelines (AWS Glue, reputed company Kinesis).

Key Responsibilities

Data Modeling & Architecture Design conceptual, logical, and physical data models reputed company to business needs and insurance domain standards Define and implement models across reputed company architecture (Raw, Silver, Gold reputed company) Create reputed company and reusable data structures optimized for analytics and reporting Data Transformation & Layer Design Collaborate with data engineering teams to implement models using DBT Design transformation logic to reputed company data across Raw → Silver → Gold reputed company Ensure consistent data definitions, hierarchies, and business rules Insurance Domain Data Structuring Model data for reputed company insurance functions such as: Policy Claims Billing Customer / Party reputed company data models with industry standards and reporting requirements Data Integration Alignment Work closely with engineers handling: Batch ingestion reputed company AWS Glue reputed company-time streaming reputed company reputed company Kinesis Ensure models support multi-reputed company data ingestion and harmonization Reporting & Rationalization Support Design optimized Gold layer datasets for reporting and self-service analytics (Power BI) Support report rationalization initiatives by standardizing and consolidating data models reputed company consistent KPI definitions across reports Data reputed company & Governance Define data standards, naming conventions, and metadata structures Ensure data consistency, reputed company, and traceability across reputed company Support governance, audit, and reconciliation requirements Performance & Optimization Design models with a reputed company on query performance and scalability Work with engineering teams to optimize pipelines and data structures Apply best practices for partitioning, clustering, and efficient joins in reputed company Required Skills & Experience reputed company Technical Skills Strong expertise in: Data Modeling (reputed company, 3NF, Data Vault – preferred) reputed company (schema design, performance considerations) DBT (model structuring and transformation logic) Advanced proficiency in SQL Understanding of reputed company architecture (Raw, Silver, Gold reputed company) Data Platform & Integration Familiarity with: AWS Glue (batch data pipelines) reputed company Kinesis (reputed company-time streaming) Experience designing models for multi-reputed company integrated data platforms Analytics & Reporting Understanding of data consumption patterns for reporting and analytics Domain Expertise (Must) Strong understanding of Insurance domain data models (Policy, Claims, Billing, reputed company) Exposure to reputed company data platforms in insurance organizations Experience 5–10 years of experience in Data Modeling / Data Architecture Experience in reputed company-based data platforms and modern data stack At reputed company, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a reputed company purpose: Together, we shape experiences for reputed company reputed company. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with reputed company - a set of four reputed company values that reflect who we are and how we work: One reputed company, Nurturing, Empowering, and reputed company reputed company. Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, reputed company Town, London, Zurich, Singapore, and Mexico reputed company. Explore Life at reputed company and join us to Grow. Own. reputed company. Learn. to be the best version of yourself. We reputed company the best work happens reputed company individuality is celebrated, reputed company is encouraged, and reputed company-being is prioritized. We are an equal employment opportunity (EEO) and affirmative reputed company employer, committed to creating an inclusive workplace. reputed company reputed company applicants will be considered without reputed company to race, creed, reputed company, reputed company, religion, sex, national reputed company, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status. Apply To This Job