Data Modeler Engineer

Career Area :

Technology Digital and Data

Job Description :

Your Work Shapes the World at Caterpillar Inc.

When you join Caterpillar yourejoining 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 dontjust 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 Modeler / Engineer

Role Definition :

Design and implement data models for relational dimensional and NoSQL databases. Collaborate with business and IT teams to deliver scalable data solutions and ensure best practices in data architecture.

What You Will Do :

Build conceptual logical and physical data models for various platforms (RDBMS ODS data marts data lakes).

Translate business requirements into technical data solutions.

Define and enforce data modeling standards and best practices.

Create reusable schemas for Snowflake data marts ensuring alignment with business processes.

Maintain data dictionaries and metadata to support governance and auditability.

What You Have :

Data modeling (ER dimensional normalization)

SQL Oracle SQL Server PostgreSQL NoSQL

Data modeling tools : ERwin ER / Studio Power Designer etc

ETL Informatica cloud platforms (AWS Azure)

Data governance analytics problem-solving

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.

Skill Descriptors : Value Realization :

Knowledge of value realization methods; ability to plan execute watch and manage business activities and resources to find and achieve the actual value from a business initiative as estimated in an associated business case

Communicating Complex Concepts :

Knowledge of effective presentation tools and techniques to ensure clear understanding; ability to use summarization and simplification techniques to explain complex technical concepts in simple clear language right to the audience.

Agile Development :

Knowledge of agile methodologies and the agile development lifecycle; ability to use formal agile methodologies disciplines practices and techniques for the delivery of new and enhanced applications.

Cloud Computing :

Knowledge of the concepts technologies and services of cloud computing; ability to design deploy and implement cloud computing solutions in various business environments.

Database Design (Physical) :

Knowledge of database systems; ability to set up a data model for designing an organizations database that runs effectively and efficiently for better business outcome.

ETL Process :

Knowledge of the extraction transformation and loading (ETL) process; ability to develop a database through the ETL process.

Information Management :

Knowledge of an organizations existing and planned Information Architecture and Information Management (IM) method; ability to collect and manage information from different sources and distribute this information to enhance operational efficiency.

Modeling :

Data Process Events Objects : Knowledge of data process and events; ability to use tools and techniques for analyzing and documenting logical relationships among data processes or events.

Additional Info :

The primary locations for this position are Dallas TX or Mossville IL.

Sponsorship is NOT available.

Relocation is available for qualified candidates.

This role requires 5 DAYS IN OFFICE.

About Caterpillar -

Caterpillar Inc. is the worlds 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 weve been helping customers build a better more sustainable world and are committed 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.

Summary Pay Range :

$97530.00 - $146290.00

Compensation and benefits offered may vary depending on multiple individualized factors job level market locationjob-related knowledge skills individual performance and experience. Please note that salary is only one component of total compensation at Caterpillar.

Benefits :

Subject to plan eligibility terms and guidelines. This is a summary list of benefits.

Medical dental and vision benefits

Paid time off plan (Vacation Holidays Volunteer etc.)

401(k) savings plans

Health Savings Account (HSA)

Flexible Spending Accounts (FSAs)

Health Lifestyle Programs

Employee Assistance Program

Voluntary Benefits and Employee Discounts

Career Development

Incentive bonus

Disability benefits

Life Insurance

Parental leave

Adoption benefits

Tuition Reimbursement

• These benefits also apply to part-time employees

This position requires working onsite five days a week.

Relocation is available for this position.

Visa Sponsorship is not available for this position. This employer is not currently hiring foreign national applicants that require or will require sponsorship tied to a specific employer such as H L TN F J E O. As a global company Caterpillar offers many job opportunities outside of the U.S which can be found through our employment website at Dates :

January 14 2026 - January 24 2026

Any offer of employment is conditioned upon the successful completion of a drug screen.

Caterpillar is an Equal Opportunity Employer Including Veterans and Individuals with Disabilities. Qualified applicants of any age are encouraged to apply.

Not ready to apply Join our Talent Community.

Required Experience :

IC

Key Skills

Atl,CMMS,ABAP,Community Support,CRM,Fleet

Employment Type : Full-Time

Experience : years

Vacancy : 1

Monthly Salary Salary : 97530 - 146290