Senior Data Specialist (Lead Data Engineer)

Career Area: Technology, 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.

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 (Lead Data Engineer) join our Financial Systems Tech Support -CAT IT Division who can operate as a strong hands-on individual contributor while providing technical leadership and guidance across enterprise data initiatives. This role is responsible for designing, developing, implementing, and supporting scalable data solutions, analytics platforms, and automation capabilities that enable data-driven decision making across the organisation. The ideal candidate will possess deep expertise in Data Engineering, Power BI, Microsoft Power Platform, Database Technologies, Cloud Platforms, System Design, and Modern Data Architectures . This individual should be capable of independently solving complex technical challenges, driving solution design, evaluating emerging technologies, mentoring team members, and ensuring the successful delivery of high-quality data products. The role requires a balance of strong technical execution, architectural thinking, debugging expertise, stakeholder collaboration, and continuous innovation. The preference for this role is to be based out of Bangalore – Caterpillar PSN What you will do Data Engineering & Platform Development Hands-on Data Engineering Design, develop, and maintain scalable, reliable batch, near real-time or streaming data pipelines. Build and optimise ETL/ELT solutions that process large volumes of structured and unstructured data. Develop reusable data integration frameworks, ingestion components, and orchestration workflows. Design and implement enterprise-grade data warehouses, data lakes, and modern data platforms. Integrate data from databases, APIs, enterprise applications, SaaS platforms, files, and external systems. Ensure data accuracy, consistency, reliability, and traceability across all data assets. Develop scalable data models that support reporting, analytics, operational workloads, and future AI/ML initiatives. Data Quality & Governance Implement data quality controls, validation frameworks, and reconciliation processes. Establish monitoring, observability, lineage, metadata management, and auditing capabilities. Ensure compliance with data governance, privacy, security, and retention requirements. Partner with governance and business teams to improve trust and usability of enterprise data. Visualization Solutions (Good to have) Power BI Development Design and develop enterprise-grade dashboards, reports, scorecards, and executive visualisations using Power BI. Create intuitive, interactive, and business-focused visualisations that provide meaningful insights. Develop and maintain semantic models, datasets, KPIs, metrics, and reporting frameworks. Design star schemas and dimensional models to support reporting and analytics requirements. Implement advanced DAX calculations, measures, and performance optimisation techniques. Business Intelligence & Reporting Collaborate closely with