Data Engineer
Caterpillar Inc.
full-time
Posted on:
Location Type: Office
Location: Irving • Illinois • Texas • United States
Visit company websiteExplore more
Salary
💰 $97,530 - $146,290 per year
About the role
- 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.
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.
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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
ER modelingSQLdatabase designdata vaultstar schemasdata modelingdata martsmetadata managementdata governancedata mapping
Soft skills
translating business requirementscommunication