C

Caterpillar

Makes heavy machinery, engines and gas turbines

Senior Data Specialist - FOM Data Analytics and AI -CAT IT Division

Data ManagementUpdated on Nov 15
Full-time

About the Job

Requirements

  • Strong SQL proficiency and experience with data querying.
  • Knowledge of ETL/ELT tools and data pipeline frameworks.
  • Understanding of cloud platforms; AWS is preferred.
  • Experience in data modeling and schema design.
  • Familiarity with data cataloging and governance tools.
  • Familiarity with manufacturing data sources, including ERP, MES, IoT/machine data, and quality systems.
  • Ability to interpret and analyze operational KPIs such as OEE, cycle time, lead time, and inventory turns.
  • Understanding of software development and web technologies, and proficiency in SQL and other data programming languages.
  • Ability to work onsite in the office five days a week.

Responsibilities

  • Ensure data onboarding activities in the data platform comply with data governance, security, and privacy policies.
  • Perform data profiling to assess structure, completeness, and anomalies.
  • Collaborate with Data Architects and Data Engineers to align on data models, ingestion pipelines, and storage strategies.
  • Document onboarding workflows, dependencies, and known data quality issues.
  • Identify and log data quality issues, ensuring proper tracking, triage, and resolution.
  • Work with business teams to validate data correctness and usability.
  • Analyze customer requirements based on understanding of conformed models and provide solutions that are implementable and maintainable.
  • Discern data accuracies in large data sets of diverse formats.
  • Research, design, and document data specifications throughout the production life cycle.
  • Employ data analytics to assess an organization's technical performance and make system enhancement recommendations.

Desired Qualifications

  • Understanding of cloud platforms, with AWS preferred.
  • Knowledge of value realization methods, including planning, executing, and monitoring business activities and resources to determine and achieve initiative value.
  • Ability to communicate complex technical concepts clearly using presentation, summarization, and simplification techniques appropriate to the audience.
  • Knowledge of agile methodologies and the agile development lifecycle, including use of agile practices and techniques to deliver new and enhanced applications.
  • Knowledge of cloud-based solutions and their applications, including designing, implementing, and managing solutions to meet business needs and improve operational efficiency.
  • Knowledge of physical database design and database systems, including establishing effective data models and structures.
  • Knowledge of the extraction, transformation, and loading (ETL) process, including developing databases through ETL.
  • Knowledge of information architecture and information management methodologies, including collecting, managing, and distributing information from different sources.
  • Knowledge of data, process, event, and object modeling, including analyzing and documenting logical relationships.

About the Company

Caterpillar

Makes heavy machinery, engines and gas turbines

Caterpillar makes construction and mining machines, diesel and natural gas engines, industrial gas turbines and locomotives for contractors, mines, energy companies and data center builders. It is the world's largest maker of construction and mining equipment, and its yellow Cat bulldozers and excavators work in nearly every country. Customers buy or rent machines through independent Cat dealers, while its engines and turbines generate electricity and push natural gas through pipelines. Caterpillar earns money from equipment sales and from the parts and repairs that dealers supply over a machine's working life. It was formed in 1925 when California's Holt and Best tractor companies merged, and it is based in Irving, Texas.

Company size
10,001+
Company stage
IPO
Headquarters
Irving, TX
Founded
1925

Recently Posted Jobs

Explore more opportunities at Caterpillar

See more jobs