IS Specialist - Senior Data Modeler

Lead end-to-end data modeling lifecycle for Caterpillar Financial Insurance Services Snowflake data warehouse, including conceptual to physical design and governance.

Engage directly with insurance business leaders and source-system SMEs to translate complex insurance processes into scalable, governed data models powering reporting, analytics, and AI use cases.

Own semantic layer design, business glossary, data quality standards, and cross-team collaboration across onshore and offshore teams for consistent definitions and model scalability.

7+ years in data engineering, data warehousing, or data modeling; minimum 4 years as dedicated data modeler or data architect.

Expert-level proficiency in dimensional modeling (Kimball), entity-relationship modeling, and 3+ years hands-on with Snowflake including performance tuning and Snowflake-native features.

Advanced SQL skills with experience profiling and validating complex data sets.

Bachelor’s degree in Computer Science, Information Systems, Mathematics, Statistics, Actuarial Science, or related field (or equivalent experience).

Strong insurance domain knowledge covering policy administration, claims, premium, actuarial, and financial reporting data for accurate modeling and stakeholder engagement.

Operates effectively in offshore delivery models involving daily collaboration with onshore architecture, ETL, BI teams, and business leadership across time zones.

Demonstrated investigative mindset digging into source systems and data lineage, with ability to translate ambiguous business questions into clear data modeling solutions.