Can't find what you're looking for?

Join our Talent Network
Join our Talent Network

College Direct Hire - Digital Technical Analyst - Open to December/May Graduates (ETL Experience)

This job posting is no longer active.

Location: Peoria, IL, United States
Date Posted: Jul 1, 2020

Share: mail

Job Description


We at Cat Digital are working to put together the Digital platform for delivering industry-leading digital solutions in support of profitable growth for Caterpillar, dealers & our end customers. Data design and metadata management is a key component of the platform to ensure understanding of the data as well reusability.  The database designer will be accountable to design robust, scalable database and data extraction, transformation and loading (ETL) solutions for the Cat Digital Platform.  Come join us in this exciting journey and be part of the world class organization and play a key role in its digital transformation.

As a database designer you will contribute to design of Caterpillar’s state-of-the-art digital platform. 

  • Understand and evaluate business requirements and translate them into specific database solutions
  • Document data models for domains to be deployed in the digital platform including a logical data model, candidate source lists, and canonical formats.
  • Develop data ingestion store specifications identifying source systems and the tables and fields to ingest.
  • Develop data object specifications including datastore technology factors, data object DDLs, and tests.
  • Develop data object pipeline specifications including detailed field level mapping, business rules, data quality rules, etc.

Minimal travel required (less than 10% of working time)

August 2020 Start Date

Location; Caterpillar LC., Downtown Peoria, Illinois.


Basic Qualifications:

  • Bachelor’s degree in Computer Science or equivalent discipline or equivalent experience
  • 1-3 years of experience in database design and management 
  • Extract, Transformation, Load (ETL) development skills
Top Candidates will also have:
  • Strong ability to effectively and tactfully communicate orally and in writing, integrating non-technical terms with management and end users for information and reporting delivery solutions
  •   Strong understanding of data governance, metadata management, data quality, data modeling, and data architecture concepts
  • Understanding of information management concepts such as controlled vocabularies, authority control, data modeling, and schema design.
  • Good organizational skills and an aptitude for complex analytical and detailed work; ability to prioritize among multiple concurrent projects in order to meet deadlines in a timely manner.
  • Strong communication and interpersonal skills; ability to present and share ideas effectively.
  • Ability to work collaboratively in a complex, rapidly changing, and culturally diverse environment.
  • Experience with data profiling tools such as Alteryx
  • Experience with metadata managers like Erwin’s Mapping Manager
  • Experience with data cataloging tools such as Collibra
  • Strong knowledge of end-to-end data lifecycle across traditional data warehouses, relational databases, operational data stores, business intelligence reporting, and big data analytics.
  • Knowledge of data technology products and components for Big Data and Cloud (AWS, Data Lakes, and similar).

 This position has been evaluated using Hay Standard Process and has taken into consideration the organizational structure and reporting relationship.  Any deviation from the information above may impact the evaluation of this position.

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.

Share: mail

Job Info

Jul 1, 2020


United States