We Hire America Jobs

Mobile We Hire America Logo
WeHireAmerica.jobs is a service of HR Policy Foundation and DirectEmployers Association. These two non-profit organizations are providing this free resource to help educators, policy makers and job seekers understand the great employment opportunities available here in the U.S. at some of America's biggest and best companies.

Job Information

Caterpillar, Inc. Senior Data Designer, Cat Digital in Irving, Texas

Career Area:


Job Description:

The Senior Data Designer is a technical resource involved in the data quality and data design of Caterpillar’s digital offerings.

Job Duties:

  • Competent to perform all necessary data related task which could include data design, data quality, metadata management, data governance or data architecture.

  • Work directly on complex problems and provide solutions aligned with overall objectives of Cat Digital.

  • Understand and evaluate business requirements that impact the Caterpillar enterprise, dealership partners, and other internal and external customers.

  • Liaises with data creators to support project planning, training, guidance on standards, and the efficient creation/maintenance of high-quality data

  • Contributes to policies, procedures, and standards as well as technical requirements

  • Create the data management strategy and define continuous improvement goals of data quality, governance and processes.

  • Lead communication across various lines of businesses and technology partners to constantly monitor, collect, review, and roadmap business data requirements, and related technology solutions.

  • Ensure compliance with the latest data standards supported by the company, and brand, legal, information security (data security and privacy compliance).

  • Maintain knowledge of functional technology of the data management systems as they change with upgrades and new releases.

  • Maintain existing data quality scorecard measurements, executing of scorecards, resolving exceptions with data owners and source systems

  • Accountable to design robust, scalable database and data extraction, transformation and loading (ETL) solutions

  • Document data models for domains to be deployed 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 pipeline specifications including detailed field level mapping, business rules, data quality rules, etc.

Employee is also responsible for performing other job duties as assigned by Caterpillar management from time to time.

Basic Requirements:

  • A 4-year degree from an accredited college or university or equivalent experience

  • 5+ years in one of the following or 2+ years in 2 of the following areas of experience in data design, data quality, or data engineering

Top candidates will also have:

  • Understanding of information management concepts such as controlled vocabularies, authority control, data modeling, and schema design.

  • Strong knowledge of end-to-end data lifecycle across traditional data warehouses, relational databases, operational data stores, business intelligence reporting, and big data analytics.

  • Strong understanding of data governance, metadata management, data quality, data modeling, and data architecture concepts

  • Experience in Relational and non-relational data design within a large corporation preferably high tech or technology manufacturing

  • Experience creating conceptual and logical data models

  • Experience with metadata managers like Erwin’s Mapping Manager

  • Experience with data profiling tools

  • Experience with data cataloging tools such as Collibra

  • Extract, Transformation, Load (ETL) development skills

  • Knowledge of data technology products and components for Big Data and Cloud (AWS, Data Lakes, and similar).

  • XML and JSON file format knowledge

  • Strong AWS skills with proficiency in using Sagemaker Notebooks, Athena, and Jupiter Notebook

  • Strong SQL and stored procedure proficiency

  • Software development experience with Python/object-oriented/object function scripting languages

  • Experience with Object Oriented Concepts/Development/Modeling

  • Ability to work collaboratively in a complex, rapidly changing, and culturally diverse environment.

  • Ability to clearly communicate complex technical ideas, regardless of the technical capacity of the audience

  • Comfortable working in a dynamic environment where digital is still evolving as a core offering

Visa sponsorship available for eligible applicants.

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

There’s more to work at Caterpillar than just the work itself. We hire smart, friendly people and it shows in our culture. We hold ourselves to high standards and make sure our values of integrity, excellence, teamwork, commitment and sustainability come to life in the way we work. We make sure our employees feel continuously challenged while also supported. We provide professional growth opportunities, including leadership programs. We celebrate the diversity of our team, while also working together as one Caterpillar.

Our culture, like everything at our company, is made possible by each employee’s contribution. Person by person, we create the environment we work in, and we are proud of the Caterpillar we’ve built.