Data Modeler - Lead

Career Area:

Business Technologies, Digital and Data

Job Description:

Your Work Shapes the World at Caterpillar Inc.

When you join Caterpillar, you're joining a global team who cares not just about the work we do – but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here – we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it.

Caterpillar Inc. seeks a Data Modeler - Lead at its facility located at 540 W Madison St, Chicago, Illinois 60661. This technical resource will lead teams and perform all necessary data-related tasks in data quality, data design, metadata management, and data governance of Caterpillar’s digital offerings. Responsibilities include:

1. Working directly on complex problems and providing solutions aligned with overall objectives of Cat Digital.
2. Understanding and evaluating business requirements impacting the Caterpillar enterprise, dealership partners, and other internal and external customers.
3. Liaising with data creators to support project planning, training, and guidance on standards for high-quality data creation and maintenance.
4. Contributing to policies, procedures, and standards as well as technical requirements.
5. Creating the data management strategy and defining continuous improvement goals for data quality, governance, and processes.
6. Leading communication across various lines of businesses and technology partners to monitor, collect, review, and roadmap business data requirements and related technology solutions.
7. Ensuring compliance with the latest data standards supported by the company, and brand, legal, information security (data security and privacy compliance).
8. Maintaining knowledge of functional technology of the data management systems as they change with upgrades and new releases.
9. Maintaining existing data quality scorecard measurements, executing scorecards, and resolving exceptions with data owners and source systems.
10. Designing robust, scalable databases and data extraction, transformation, and loading (ETL) solutions.
11. Documenting data models for domains to be deployed, including logical data models and candidate source lists.
12. Developing data ingestion store specifications identifying source systems and the tables and fields to ingest.
13. Creating, updating, and enhancing metadata policies, processes, and catalogs.
14. Driving alignment and coordination of data governance efforts.

Minimum Requirements:

This position requires a Bachelor’s degree, or foreign equivalent, in Electrical Engineering, Electronics Engineering, Analytics, or a closely related field, plus 5 years of experience as a Data Modeler, Database Administrator, Data Engineer, or related occupation. Alternatively, a Master’s degree, or foreign equivalent, in the same fields, plus 2 years of experience will be accepted. Additionally, the applicant must have employment experience with:

1. Data engineering using SQL, Java, and Python;
2. Database Administration for Relational databases and Snowflake;
3. Data warehouse experience using Snowflake;
4. Machine Learning experience using AWS technology stack;
5. Knowledge of AWS components like Dynamo DB, Kinesis, Fargate, Lambda;
6. Data Science – Data Cleansing, Data Exploration, Statistical Analysis, Predictive Modeling;
7. Data Modeling using Erwin data modeling tool.

Telecommuting: 3 days per week.

Applicants who are interested in this position should apply , search (Data Modeler - Lead / Reference # - R0000268955) .

Posting Dates:

August 5, 2024 - December 12, 2024

Any offer of employment is conditioned upon the successful completion of a drug screen.

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

Not ready to apply? Join our Talent Community .