Data Specialist

Posted:
8/27/2024, 2:51:33 AM

Location(s):
Peoria, Illinois, United States ⋅ Illinois, United States

Experience Level(s):
Mid Level

Field(s):
Business & Strategy

Workplace Type:
Hybrid

Career Area:

Business Technologies, 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.

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 dealers. With 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:

As a part of the Commercial Connectivity team, you will provide support and guidance through data for critical business programs driving our Connectivity Strategy.  You will model data using ETL processes, made visible through our BI tools, which are used by our dealer network to drive their daily connectivity work. You will work with cross-functional global teams to drive strategy and execution.


What You Will Do:

  • Work together with team members to accomplish business objectives.
  • Develop and maintain large complex ETL Models combining multiple sources together.
  • Develop ad-hoc queries, analyzing and sending reports to internal business partners and team members.
  • Develop and maintain complex Tableau dashboards.


What You Will Have:
Value Realization:

  • Contributes and communicates with the business regarding change initiatives associated to project goals.
  • Identifies and adapts to process changes in plans and activities.


Communicating Complex Concepts:

  • Ability to summarize and simplify complex technical concepts in simple, clear language appropriate to the audience.
  • Explains products and services with little or no use of technical jargon.
  • Emphasizes the most important facts or features of a product or service.

Cloud Computing:

  • Knowledge of the concepts, technologies and services of cloud computing with preference working with Snowflake or Azure.

ETL Process:

  • Knowledge of the extraction, transformation and loading (ETL) process; ability to develop a database through the ETL process.
  • Derives necessary business or technical information from original data.
  • Acquires a large amount of data from different sources/systems.

Information Management:

  • Ability to collect and manage information from different sources, and distribute this information to enhance operational efficiency.
     

Modeling:

  • Participates in reviews and walkthroughs of data platforms and BI tool features and capabilities.
  • Prepares reports to recap current findings and issues in data, processes or event models.

Considerations For Top Candidates:

  • Knowledge of database systems; ability to establish a data model for designing an organization's database that runs effectively and efficiently for better business outcome.
  • Experience creating SQL queries
  • Experience working with BI tools such as Tableau
  • Experience working with Alteryx
    .

Additional Details:

  • This position is based out of our Peoria, IL office with a flexible hybrid work environment. 
  • #LI-Hybrid
  • #BI (used to post on Built In)

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

Visa sponsorship available for eligible applicants.

Posting Dates:

August 27, 2024 - September 2, 2024

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

EEO/AA Employer.  All qualified individuals - Including minorities, females, veterans and individuals with disabilities - are encouraged to apply.

Not ready to apply? Join our Talent Community.