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.
Job Title: Experienced Data Modeler
Employment Type: Full-Time
Role Summary
We are seeking an experienced data modeler to join our team supporting the Dealer ERP Template initiative. This role will lead efforts to define, review, and document data models for the Global Dealer Common Data Model and ensure alignment across platforms including Dynamics 365 (D365), CAT Integration Service (CIS), and Helios. The data modeler will collaborate with ERP and CRM teams, domain steward delegates, and governance stakeholders to ensure data requirements, mappings, and quality rules are clearly understood, documented, and integrated to support Caterpillar and dealer needs.
Primary Responsibilities
- Collaborate with ERP and CRM project teams to identify, document, and address data requirements and gaps for the Dealer ERP Template initiative.
- Define, review, and document data models for domains within the Global Dealer Common Data Model.
- Partner with D365, CAT Integration Service (CIS), and Helios teams to ensure clear understanding of how data models across platforms relate and integrate with one another.
- Review and validate data mappings between Helios, CAT Integration Service, and Dynamics 365 to ensure seamless integration and data integrity.
- Align data modeling efforts with enterprise data governance standards and ensure consistent understanding of data across Caterpillar teams, consultants, and dealers.
- Collaborate with domain steward delegates to ensure data quality rules relevant to the Dealer ERP and CRM are clearly defined, documented, and communicated to Dynamics 365 teams to support better data quality.
Required Qualifications
- Proven experience in data modeling for enterprise systems and working with ERD (Entity Relationship Diagram) modeling tools. Minimum 5 years.
- Strong SQL query skills. Minimum 5 years.
- Experience with data quality frameworks and working with enterprise data governance programs. Minimum 5 years.
- Strong understanding and experience with data integration across platforms such as Dynamics 365, CAT Integration Service, and Helios.
- Innovative mindset with a focus on continuously improving data processes, data quality, and outcomes.
- Ability to learn and leverage tools, including AI and automation, to enhance data modeling practices and efficiency.
- Excellent communication and documentation skills.
- Detail-oriented mindset with a focus on data reliability, quality, and documentation.
- Ability to translate business requirements into clear, scalable data models.
Preferred Qualifications
- Experience working in large-scale ERP and/or CRM implementations, particularly in the manufacturing or dealer network domain.
- Knowledge of Caterpillar systems and dealer operations is a plus.
- Experience with Snowflake or similar cloud-based data platforms.
- Familiarity with Microsoft Fabric is a plus.
- Experience using reporting tools such as Power BI.
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.