Caterpillar, Inc. Senior Data Designer, Cat Digital in Irving, Texas
The Senior Data Designer is a technical resource involved in the data quality and data design of Caterpillar’s digital offerings.
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.
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.
- Caterpillar, Inc. Jobs