Data Warehouse Software Engineer

Career Area:

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.

Cat Digital is the digital and technology arm of Caterpillar Inc. leveraging the latest technologies to build industry leading digital solutions for our customers and over 1.5 million connected assets worldwide our teams use data technology advanced analytics telematics and AI capabilities to help our customers build a better more sustainable world.

Job Summary:

This role is responsible for developing and supporting solutions for Cats Digital Intelligence Warehouse (DIW) within Cat Digital Marketing Activation Data & Architecture. The candidate will leverage multiple technologies including cloud data knowledge SQL and GCP BigQuery to enable the use of marketing behavioral data throughout Caterpillar.

What You Will Do:

• Develop and support Cats Digital Intelligence Warehouse

• Leverage SQL and other technologies to help enterprise business users adopt the use of behavioral data to unlock the value of personalization cross-channel attribution journey insights marketing optimization audience reach and reporting

• Participate in the architectural assessment and design for new data warehouse components

• Lead technology evaluations and recommendations

• Assist in the development and alignment of digital roadmaps

What You Will Have:

Decision Making and Critical Thinking: Knowledge of the decision-making process and associated tools and techniques; ability to accurately analyze situations and reach productive decisions based on informed judgment.
Effective Communications: Understanding of effective communication concepts tools and techniques; ability to effectively transmit receive and accurately interpret ideas information and needs through the application of appropriate communication behaviors.
Software Development: Knowledge of software development tools and activities; ability to produce software products or systems in line with product requirements.
Software Development Life Cycle: Knowledge of software development life cycle; ability to use a structured methodology for delivering and managing new or enhanced software products to the marketplace.
Software Integration Engineering: Knowledge of software integration processes and functions; ability to design develop and maintain interfaces and linkage to alternative platforms and software packages.
Software Product Design/Architecture: Knowledge of software product design; ability to convert market requirements into the software product design.
Software Product Technical Knowledge: Knowledge of technical aspects of a software products; ability to design configure and integrate technical aspects of software products.
Software Product Testing: Knowledge of software product testing; ability to design plan and execute testing strategies and tactics to ensure software product quality and adherence to stated requirements.

Considerations For Top Candidates:

• A bachelors degree in computer science information technology analytics data science statistics marketing or other related field. OR equivalent working experience

• Experience with complex SQL

• Cloud data knowledge

• Strong interpersonal problem-solving and decision-making skills

• Experience with a cloud platform such as Google Cloud Platform (GCP) & GCP BigQuery

• Experience working with digital marketing behavioral data (Google Analytics/AdWords/Salesforce)

• Experience with Google Analytics 4 (GA4) data

• GCP Certification(s)

• Experience with data pipelines and data models

• Experience with HighTouch or Snowflake

• Experience with Azure DevOps

• Experience with BI Dashboards or Google Looker Studio

• Experience with an extract transfer and load (ETL) tool such as FiveTran

• Familiarity with data analytics tools

What You Will Get:

Working with a Fortune 100 leader you can build your career on a global scale and take advantage of development opportunities with emerging technologies. Weve created an inclusive environment for you to explore your passions make an impact and do the work that really matters. Join Us.

Additional Information:

#LI

#BI

Visa sponsorship is available for eligible applicants.

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.

This Job Description is intended as a general guide to the job duties for this position and is intended for the purpose of establishing the specific salary grade. It is not designed to contain or be interpreted as an exhaustive summary of all responsibilities duties and effort required of employees assigned to this job. At the discretion of management this description may be changed at any time to address the evolving needs of the organization. It is expressly not intended to be a comprehensive list of essential job functions as that term is defined by the Americans with Disabilities Act.

Summary Pay Range:

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

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.

Not ready to apply Join our Talent Community.