Senior Data Specialist

Career Area:

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.

Your Impact 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.

We are seeking a skilled Senior Data Specialist to join our FOM Data Analytics and AI -CAT IT Division

The preference for this role is to be based out of Chennai - Brigade World Trade Centre

What you will do

The incumbent would employ data analytics to assess an organization's technical performance and makes system enhancement recommendations.

Responsibilities

• Ensure data onboarding activities in 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.
• Analyzing customer requirements based on the understanding of conformed models and catering solutions that are implementable and maintainable.
• Discerning data accuracies in large sets of data of diverse formats
• Researching, designing, and documenting data specifications at all points in the production life cycle.
• Understanding software development and web technologies and having proficiency in SQL and other data programming languages.

What you will have

• Strong SQL proficiency and experience with data querying
• Knowledge of ETL/ELT tools and data pipeline frameworks
• Understanding of cloud platforms (AWS 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.
• This position requires candidate to work a 5-day -a -week schedule in the office

Skills desired:

Value Realization: Knowledge of value realization methods; ability to plan, execute, monitor and manage business activities and resources to determine and achieve the actual value from a business initiative as estimated in an associated business case.

Level Basic Understanding:

• Describes the importance of Value Realization milestones for long-term projects.
• Assists in measuring and attaining post-project implementation value.
• Identifies process changes or business value integration in change initiative plans and activities.
• Contributes to project team communication regarding the linkage of a change initiative to its associated business goals and case. Communicating Complex Concepts: Knowledge of effective presentation tools and techniques to ensure clear understanding; ability to use summarization and simplification techniques to explain complex technical concepts in simple, clear language appropriate to the audience. Level Working Knowledge:
• Uses comparisons to familiar ideas when introducing a technical or novel feature.
• Separates fundamental concepts from supporting details in explaining a product or service.
• Explains products and services with little or no use of technical jargon or advanced vocabulary.
• Emphasizes the most important facts or features of a product or service.
• Perceives lack of audience comprehension; further simplifies explanation when needed. Agile Development: Knowledge of agile methodologies and the agile development lifecycle; ability to utilize formal agile methodologies, disciplines, practices and techniques for the delivery of new and enhanced applications. Level Working Knowledge:
• Explains a specific agile process and its associated checkpoints and deliverables.
• Works with a specific agile development methodology.
• Interprets metrics used to measure progress and effectiveness.
• Defines key selection and qualifying criteria for projects suitable for agile development.
• Applies major tools and techniques associated with the specific methodology. Cloud Computing: Knowledge of cloud-based solutions and their applications; ability to design, implement, and manage cloud-based solutions to meet business needs and improve operational efficiency. Level Working Knowledge:
• Designs and implements a cloud-based solution to meet a specific business need or requirement.
• Configures and deploys cloud-based infrastructure, such as virtual machines, storage, and networks.
• Migrates applications and data to a cloud-based environment, including data migration and integration.
• Implements cloud-based security measures, such as access controls, encryption, and firewalls.
• Troubleshoots and resolves common cloud-based issues, such as connectivity problems and performance degradation. Database Design (Physical): Knowledge of database systems; ability to establish a data model for designing an organization's database that runs effectively and efficiently for better business outcome. Level Working Knowledge:
• Researches relationships between different business data sets.
• Participates in the establishment of data structures based on their relationships.
• Adheres to an organization's database design policies.
• Utilizes database design tools and techniques.
• Tests the effectiveness of the database before its release for business use. ETL Process: Knowledge of the extraction, transformation and loading (ETL) process; ability to develop a database through the ETL process. Level Working Knowledge:
• Ensures the accuracy and effectiveness of data provided for the warehouse.
• Loads selected data into the warehouse on a regular basis.
• Derives necessary business or technical information from original data.
• Acquires a large amount of data from different sources/systems.
• Solves technical and administrative problems during the ETL process. Information Management: Knowledge of an organization's existing and planned Information Architecture and Information Management (IM) methodology; ability to collect and manage information from different sources, and distribute this information to enhance operational efficiency. Level Extensive Experience:
• Directs the implementation of information processing and operation standards to protect and manage information assets.
• Develops capabilities, features and uses for major IM platforms.
• Coaches others on issues and considerations for managing structured vs. unstructured data.
• Advises on improvement plans for existing and forecasted information architecture.
• Consults on all major information management platforms and practices.
• Consults on information architecture concepts, disciplines and practices. Modeling: Data, Process, Events, Objects: Knowledge of data, process and events; ability to use tools and techniques for analyzing and documenting logical relationships among data, processes or events. Level Working Knowledge:
• Defines common types of data, processes or event models.
• Participates in model reviews and walkthroughs.
• Explains existing models to clients and describes their associated business processes.
• Focuses on modifying Data Structure, Access and Entity Relationship Diagrams.
• Prepares reports to recap current findings and issues in data, processes or event models.

What you will get:

• Work Life Harmony
• Earned and medical leave.
• Relocation assistance

Holistic Development

• Personal and professional development through Caterpillar ‘s employee resource groups across the globe
• Career developments opportunities with global prospects

Health and Wellness

• Medical coverage -Medical, life and personal accident coverage
• Employee mental wellness assistance program

Financial Wellness

• Employee investment plan
• Pay for performance -Annual incentive Bonus plan.

Additional Information:

Caterpillar is not currently hiring individuals for this position who now or in the future require sponsorship for employment visa status; however, as a global company, Caterpillar offers many job opportunities outside of the U.S. which can be found through our employment website at www.caterpillar.com/careers

Caterpillar is an Equal Opportunity Employer (EEO)

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

Posting Dates:

Caterpillar is an Equal Opportunity Employer. Qualified applicants of any age are encouraged to apply

Not ready to apply? Join our Talent Community.