IS Specialist - Senior Data Modeler

Career Area: Technology, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do – but also about each other.  We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here – we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it.   About Caterpillar Caterpillar Inc. is the world’s leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives. For nearly 100 years, we’ve been helping customers build a better, more sustainable world and are committed to and contributing to a reduced-carbon future. Our innovative products and services, backed by our global dealer network, provide exceptional value that helps customers succeed.

Shapes the World at Caterpillar Inc When you join Caterpillar, you're joining a global team who cares not just about the work we do – but also about each other. We are the makers, problem solvers and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here – we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it.

We are seeking a skilled IS Specialist -Senior Data Modeler to join India CoE-Integration & Engg -CAT IT Division We are seeking a Senior Data Modeler to serve as the architectural steward of the Caterpillar Financial Insurance Services (CFIS) Snowflake data warehouse. This role is the connective tissue between insurance business leaders, source-system SMEs, ETL engineers, BI developers, and AI/analytics platforms — translating complex insurance business processes into governed, scalable, business-friendly data models that power certified reporting, self-service analytics, Snowflake Intelligence, and downstream AI agents. The ideal candidate combines deep technical modeling craft with relentless curiosity about how insurance data is actually created, moved, and consumed — someone who won't stop at "what the source system sends" but instead digs in with policy administration, claims, actuarial, and underwriting to understand why the data looks the way it does, and how it should be shaped to answer the business's most important questions. The preference for this role is to be based out of Bangalore – Caterpillar PSN What you will do End-to-End Data Modeling & Data Product Ownership: Lead the full data modeling lifecycle for the CFIS Snowflake warehouse — from business requirements discovery, conceptual → logical → physical design, entity-relationship mapping, dimensional modeling (Kimball star/snowflake schemas, conformed dimensions, slowly changing dimensions), through iterative validation. Own the models as data products with clear consumers, SLAs, and lifecycle governance in collaboration with onshore data modelers.   Investigative Source-System Analysis (Curiosity in Action): Serve as the team's most curious mind when it comes to bringing in data from source systems. This role requires actively digging into CFIS-specific insurance, broader Caterpillar systems, and external sources. You'll partner with source-system owners and business SMEs to understand data lineage, business rules, edge cases, and historical anomalies before proposing how the data should be modeled — not just consuming feeds as-is.   Insurance Business Fluency & Stakeholder Engagement: Build and continuously deepen your knowledge of insurance business processes — policy lifecycle, premium calculation and earning patterns, physical damage vs. extended protection product lines, claims adjudication and