Connect

Can't find what you're looking for?

Join our Talent Network
Join our Talent Network

Database Administrator

This job posting is no longer active.

Location: Peoria, IL, United States
Date Posted: Sep 30, 2019

Share: mail

Job Description

Description

JOB PURPOSE:

 

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.

 

JOB DUTIES:

 

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)


Qualifications

 

BACKGROUND/EXPERIENCE:


Basic Qualifications: 

  • Bachelor’s degree from an accredited college or university 
  • 1+ years of experience in database design and management

Top Candidates will also have:

  • Extract, Transformation, Load (ETL) development skills
  • 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).
  • Bachelor’s degree in Computer Science or equivalent discipline or equivalent experience
Caterpillar is not currently hiring individuals for this position who now or in the future require sponsorship for employment visa status; however, as a global company, Caterpillar offers many job opportunities outside of the U.S. which can be found through our employment website at www.caterpillar.com/careers. 

Share: mail
 

Job Info

Sep 30, 2019

190007NE

United States