Junior Data Analyst
Caterpillar Inc.

Job Title: Junior Data Analyst

Location: Remote / Onsite (as applicable)

Employment Type: Full-Time

Job Summary

We are seeking a detail-oriented and analytical Junior Data Analyst to join our team. The ideal candidate will assist in collecting, analyzing, and interpreting data to help drive business decisions. This role is an excellent opportunity for individuals looking to build a career in data analytics and business intelligence.

Key Responsibilities

• Collect, clean, validate, and organize data from multiple sources.
• Analyze datasets to identify trends, patterns, and actionable insights.
• Create and maintain dashboards, reports, and visualizations.
• Prepare regular and ad-hoc reports for management and stakeholders.
• Assist in developing KPIs and performance metrics.
• Perform data quality checks and troubleshoot data discrepancies.
• Support business teams with data-driven recommendations.
• Document data processes, methodologies, and findings.
• Collaborate with cross-functional teams including Operations, Sales, Marketing, and IT.

Required Qualifications

• Bachelor's degree in Data Analytics, Statistics, Mathematics, Computer Science, Information Systems, Economics, or a related field.
• 0â2 years of experience in data analysis, reporting, or related roles.
• Strong analytical and problem-solving skills.
• Excellent attention to detail and accuracy.
• Good written and verbal communication skills.

Required Technical Skills

Must Have:

• SQL (Joins, Aggregations, Subqueries, Window Functions)
• Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, Power Query)
• Data Cleaning and Validation
• Data Visualization

Preferred:

• Power BI or Tableau
• Python (Pandas, NumPy)
• Basic Statistics and Data Interpretation
• Experience with databases such as MySQL, PostgreSQL, or SQL Server

Preferred Qualifications

• Knowledge of ETL concepts and data warehousing.
• Familiarity with business intelligence tools.
• Understanding of reporting automation.
• Exposure to cloud platforms such as AWS, Azure, or Google Cloud is a plus.

Key Competencies

• Analytical Thinking
• Attention to Detail
• Time Management
• Communication Skills
• Problem Solving
• Team Collaboration
• Adaptability

What You'll Gain

• Hands-on experience working with real business data.
• Exposure to modern analytics and reporting tools.
• Mentorship from experienced data professionals.
• Opportunities for career growth into Data Analyst, Business Analyst, or Data Engineer roles.