IS Specialist - Senior Data Modeler

Descrição

Career Area:

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.

Your Impact 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.

Job Summary

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 reserving, loss ratios, and actuarial reserving concepts. Directly engage insurance business leadership — including CFIS product managers, actuarial, claims, underwriting, and Insurance Services executives — to understand data requirements, translate business questions into modeling decisions, and validate that certified data sources reflect real-world business intent.
• Snowflake-Native Modeling & Semantic Layer Design: Design models that leverage Snowflake's architecture — clustering keys, micro-partitioning, materialized views, dynamic tables, transient/temporary tables, zero-copy cloning, and secure data sharing — for query performance, storage efficiency, and cost-aware scalability. Own the certified semantic layer on top of the warehouse that powers Power BI dashboards, Snowflake Semantic Views, Snowflake Intelligence, and Streamlit apps.
  
• Metric, Grain & Business Glossary Stewardship: Define and document business metrics, measures, and grain at each layer of the model (raw → conformed → presentation → semantic). Own CFIS business glossary alignment, ensuring metrics like "written premium," "earned premium," "incurred loss," "loss ratio," and "policy count" have single, certified definitions that hold across Power BI, Snowflake Intelligence, and AI agent consumption.
• Governance, Standards & Documentation: Establish and enforce modeling standards — naming conventions, surrogate/natural key strategies, reference data management, data classification (PII/PHI-sensitive claims data), and end-to-end lineage documentation. Champion data contracts between source systems and the warehouse to reduce silent breakage.
  
• Data Quality, Integrity & Reconciliation: Embed validation rules, referential integrity checks, and completeness/consistency expectations into model designs. Partner with ETL developers and data stewards to identify and resolve upstream data quality issues rather than masking them at the reporting layer.
  
• Matillion ETL/ELT Alignment: Collaborate closely with the ETL team to ensure modeling decisions align with pipeline implementation. Advise on tradeoffs between normalization, denormalization, and performance — balancing model integrity with practical load, refresh, and incremental-merge patterns.
  
• Offshore Delivery & Cross-Team Collaboration: Operate effectively in an offshore delivery model, partnering daily with onshore architecture, ETL developers, team leads, BI developers, BAs, PMs, and insurance business leadership in Nashville, TN. Coordinate with other data modelers to share reusable modeling patterns and ensure consistent definitions across domains — policy administration, claims, premium, dealer solutions, pricing, and reinsurance.
  
• Scalability & Forward-Looking Architecture: Proactively evaluate model designs for scalability as new data sources, business domains, and AI/self-service use cases emerge. Recommend refactoring or extension strategies that preserve backward compatibility while enabling growth (e.g., preparing for Snowflake Semantic Views, Cortex Analyst, AI integrations).
  
• Mentorship & Knowledge Sharing: Mentor junior modelers, ETL developers, and BI developers on dimensional modeling craft and insurance domain knowledge. Participate in CAB reviews, contribute to weekly release notes, maintain model documentation, and support onboarding of new team members.

What you will have

• 7+ years of experience in data engineering, data warehousing, or data modeling, with at least 4 years in a dedicated data modeler or data architect role
  
• Expert-level proficiency in dimensional modeling (Kimball methodology), entity-relationship modeling, and hybrid approaches (Data Vault familiarity a plus)
• 3+ years hands-on with Snowflake — schema design, clustering strategies, performance tuning, secure data sharing, and Snowflake-native features
• Advanced SQL skills — ability to profile, validate, and troubleshoot data at scale across complex joins and business logic
• Demonstrated ability to engage business leaders — translating ambiguous business questions into concrete modeling decisions and communicating tradeoffs in business-friendly language
  
• Strong investigative mindset — comfort digging into source systems, tracing data lineage, and asking "why does the data look this way?" before designing solutions
• Excellent written and verbal communication — able to produce clear model documentation, business glossary entries, and executive-facing decision briefs
• Proven ability to work effectively in an offshore delivery model, collaborating daily with onshore architecture, ETL, and business teams across time zones
• Bachelor's degree in Computer Science, Information Systems, Mathematics, Statistics, Actuarial Science, or related field (or equivalent experience)
  Preferred
  
• Insurance or financial services data background — particularly with policy administration, claims, premium, actuarial, or financial reporting data
  
• Familiarity with Matillion ETL/ELT and understanding of how modeling decisions impact pipeline design and orchestration
  
• Experience with Power BI semantic models, DAX, and how modeling decisions flow through to dashboard consumption
  
• Exposure to Snowflake Cortex AI, Snowflake Intelligence / Polaris AI, or AI-ready semantic view design — including experience preparing data for natural language query and AI agent consumption
• Familiarity with data governance frameworks (data classification, masking policies, row access policies), metadata management, and Snowflake lineage tools
  
• Experience with Git version control, CI/CD for data warehouse artifacts, and environment management (dev/test/prod)
• Snowflake certifications (SnowPro Core, SnowPro Advanced: Data Engineer or Architect)
• Familiarity with insurance-specific concepts: written vs. earned premium, IBNR, loss development, subrogation, reinsurance, physical damage vs. extended protection product lines
  ted
• This position requires candidate to work a 5-day -a -week schedule in the office.

Skills desired:

Problem Solving: Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational or process problems; ability to apply knowledge of problem solving appropriately to diverse situations.
Level Expert:
• Gains agreement on the problem-solving process, risk assessment, decision points, and criteria.
• Trains others in the process of eliciting alternatives and assessing their impact.
• Orchestrates the resolution of high-impact and cross-functional problems.
• Successfully organizes problem solvers and stakeholders for high-impact problems.
• Predicts and explains long-term trends and implications for alternatives.
• Monitors industry for best practices and new techniques in problem-solving.

Technology Advising: Knowledge of effective advisory methods and ability to provide valued information and advice to clients regarding products, technologies, services and solutions for a specific technology domain.
Level Extensive Experience:
• Collaborates with an extended professional technology network to help clients effectively identify, plan for and accomplish technology objectives.
• Supervises others in advising a range of clients across a myriad of products, technologies, services and solutions in a relevant technology domain.
• Identifies and evaluates emerging technologies and advises clients regarding their potential business impacts.
• Effectively consults with and conveys technology concepts, business impacts and other advice to senior client levels.
• Trains others in developing technology business, channel management and client coaching.
• Leverages formal certifications in mastery of multiple areas of technology in demonstrating credibility for client consulting.

Application Design, Architecture: Knowledge of application design and architecture principles and practices; ability to utilize application design methodologies, tools, and techniques to convert business requirements and logical models into a technical application design.
Level Expert:
• Advises others on the technical design of high-impact, multi-technology complex applications.
• Contributes to the establishment and implementation of best practices for application design.
• Leads in evaluating and selecting emerging application design tools and techniques.
• Designs cutting-edge application architectures that push the boundaries of current technology standards.
• Directs the development of technical standards for application design.
• Fosters a culture that promotes innovative approaches to application design and architecture.
Requirements Analysis: Knowledge of tools, methods, and techniques of requirement analysis; ability to elicit, analyze and record required business functionality and non-functionality requirements to ensure the success of a system or software development project.
Level Expert:
• Creates leadership positions in identifying and implementing new tools and techniques.
• Shares expertise and his/her broad experience in using modeling tools for multiple requirements.
• Implements best practices for functional and information analysis and maintains the requirements definition.
• Provides insight into developing diverse and multiple requirements analyses.
• Monitors industry and vendor products in terms of improvements and enhancements.
• Establishes and communicates on advance technical standards for each stage of requirements analysis.

System and Technology Integration: Knowledge of the features and facilities of systems; ability to integrate and communicate among applications, databases and technology platforms.
Level Expert:
• Consults with others on system and/or technology integration efforts.
• Monitors system and technology integration trends and directions.
• Plays a leadership role in defining systems integration processes and practices.
• Designs complex interfaces, integration strategies and plans.
• Holds an industry wide conference on system integration and migration issues, problems and considerations.
• Demonstrates extensive experience with system and technology integration.

System Testing: Knowledge of system and software testing; ability to design, plan and execute system testing strategies and tactics to ensure the quality of software at all stages of the system life cycle.
Level Expert:
• Champions the employment of technology to maximize system test throughput and coverage.
• Builds testing and software QA methodologies and practices for the organization.
• Advocates appropriate levels of quality by resolution of important defects.
• Leads the team in testing activities and provides technical guidance on multiple testing projects.
• Directs the identification, investigation, reporting and follow-up with design teams for all issues raised during the testing process.
• Solicits and evaluates feedback from business process owners during pilot and parallel testing.

Systems Software Infrastructure: Knowledge of computer architecture and system software interaction; ability to design and build a fundamental architecture of operating systems, database management systems, communications protocols, compilers and other development tools.
Level Extensive Experience:
• Designs and implements software infrastructure and core technologies.
• Develops software architecture and data management policies and procedures.
• Resolves issues regarding the implementation of heterogeneous open systems.
• Evaluates the management of software configuration facilities and practices.
• Coaches on the essential elements of software architecture, platforms and products.
• Facilitates internal and external cooperative and distributed alignment and processing of systems software infrastructure.

Technical Troubleshooting: Knowledge of technical troubleshooting approaches, tools and techniques; ability to anticipate, recognize, and resolve technical issues on hardware, software, application or operation.
Level Extensive Experience:
• Emphasizes the business impact of failure and the criticality and timing of needed resolution so that problems can be avoided in the future.
• Creates trouble reports for all issues found and reviews solutions for completeness and correctness.
• Directs the resolution of communications problems in multi-vendor environments.
• Resolves a variety of hardware, software, and communications malfunctions.
• Coaches others on advanced diagnostic techniques and tools for unusual or performance-related problems.
• Facilitates the distribution of releases reports and correction packages to departments or clients.

What you will get:

• Work Life Harmony
• Earned and medical leave.
• Relocation assistance

Holistic Development

• Personal and professional development through Caterpillar ‘s employee resource groups across the globe
• Career developments opportunities with global prospects

Health and Wellness

• Medical coverage -Medical, life and personal accident coverage
• Employee mental wellness assistance program

Financial Wellness

• Employee investment plan
• Pay for performance -Annual incentive Bonus plan.

Additional Information:

Caterpillar is not currently hiring individuals for this position who now or in the future require sponsorship for employment visa status; however, as a global company, Caterpillar offers many job opportunities outside of the U.S. which can be found through our employment website at www.caterpillar.com/careers

Posting Dates:

Caterpillar is an Equal Opportunity Employer. Qualified applicants of any age are encouraged to apply

Not ready to apply? Join our Talent Community.