IT Analyst Applications (Junior Data Analyst)

Job description

**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. **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. **Job Summary** We are seeking a skilled **IT Analyst Applications (Junior Data Analyst)** to join our Infrastructure Services **-CAT IT Division.** The Junior Data Analyst supports data-driven decision-making by collecting, cleaning, analysing, and reporting on data from multiple sources. This entry-level role works closely with senior analysts, business stakeholders, and technical teams to turn raw data into accurate reports, clear dashboards, and actionable insights. The preference for this role is to be based out of **Whitefield PSN Office, Bangalore, India** **What you will do** - Collect, organize, and validate data from internal and external sources. - Clean and prepare datasets by identifying errors, inconsistencies, duplicates, and missing values. - Perform basic analysis to identify trends, patterns, anomalies, and opportunities for improvement. - Create recurring and ad hoc reports that summarize key metrics and business performance. - Write and run SQL queries to retrieve, join, and analyze data from databases. - Document data sources, definitions, assumptions, methods, and reporting logic to support consistency and transparency. - Partner with business teams to understand reporting needs and translate questions into data requirements. - Support senior analysts with research, data modeling, quality checks, and presentation preparation. - Identify opportunities to improve reporting processes, data quality, and operational efficiency. **What you will have** - 2–4 years of experience in data analysis, reporting, business intelligence, data management, or a related internship/project-based role. - Working knowledge of Microsoft Excel, including formulas, pivot tables, lookups, and basic data manipulation. - Moderate experience with SQL for querying and analyzing data. - Familiarity with data visualization or business intelligence tools such as Power BI, Tableau, or similar platforms. - Basic understanding of statistics, data quality concepts, and analytical problem-solving. - **The position requires the candidate to work a 5-a day -week schedule in the office** **Preferred Qualification:** - Exposure to Python, R, or other scripting languages for data analysis or automation. - Experience working with relational databases, data warehouses, or cloud-based data platforms. - Familiarity with data governance, data documentation, metadata, or data quality practices. - Experience building dashboards, scorecards, or operational reports for business stakeholders. **Core Skills and Competencies** - **Analytical thinking:** Able to interpret data, recognize patterns, and connect findings to business questions. - **Attention to detail:** Maintains accuracy when working with large datasets, formulas, reports, and dashboards. - **Technical curiosity:** Willing to learn new tools, methods, and data platforms. - **Communication:** Explains findings clearly to both technical and non-technical audiences. - **Problem-solving:** Breaks down ambiguous questions and uses data to support practical recommendations. - **Collaboration:** Works effectively with analysts, business partners, and technical teams. **Success in This Role Looks Like** - Data issues are identified, documented, and escalated appropriately. - Business questions are translated into clear analysis, metrics, or reporting outputs. - Recurring manual reporting tasks are improved, standardized, or automated where possible. - Stakeholders trust the analyst’s work because methods, assumptions, and data sources are well documented. **Skills desired:** **Core Application Systems:** Knowledge of major production application systems used for delivery of services to internal and external clients; ability to leverage major production application systems in diverse situations. Level Basic Understanding: - Describes basic elements and benefits of core applications supported by own area. - Names the organization's core application systems. - Names major business functions and services supported by core applications. - Locates and uses relevant documentation for core applications. **Problem Solving:** Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational or process problems; ability to apply knowledge of problem solving appropriately to diverse situations. Level Basic Understanding: - Explains the value of a disciplined approach to problem solving. - Describes problem reporting and escalation practices. - Utilizes accepted procedures for problem analysis and resolution. - Identifies key aspects of problem-solving techniques used in own area. **Application Design, Architecture:** Knowledge of application design and architecture principles and practices; ability to utilize application design methodologies, tools, and techniques to convert business requirements and logical models into a technical application design. Level B