Data Engineer

Caterpillar Inc.•Mossville, IL

36d•Onsite

About The Position

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. Data Engineer Role Definition: Employs data analytics to assess an organization's technical performance and makes system enhancement recommendations.

Requirements

Expertise in ER modeling and tools like ERwin or Power Designer.
Strong SQL and database design concepts such as data vault, star schemas, etc.
Experience with big data platforms for performance and cost like Snowflake and Cloudera.
Ability to translate business requirements into technical specifications.
Understanding of data governance and metadata standards.

Responsibilities

Design conceptual, logical, and physical data models to support data marts and business data objects.
Name relevant data sources and define relationships, dependencies, and mappings.
Create reusable schemas for Snowflake data marts, ensuring alignment with business processes.
Maintain data dictionaries and metadata to support governance and auditability.