Senior Data Designer, Cat Digital
Sorry, this job was removed at 5:53 a.m. (CST) on Tuesday, January 4, 2022
By clicking Apply Now you agree to share your profile information with the hiring company.
Career Area:
Digital
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.
Not ready to apply? Submit your information to our Talent Network here .
See More