[Remote] Junior Data Analyst
Note: The job is a remote job and is open to candidates in USA. Caterpillar Inc. is seeking a data-driven Marketing Data Analyst to support their marketing team by transforming data into actionable insights that improve campaign performance and business growth. The role involves analyzing marketing data across multiple channels, building dashboards, and providing recommendations to optimize ROI and customer acquisition strategies.
Responsibilities
- Collect, clean, and analyze marketing data from digital and traditional marketing channels
- Monitor and evaluate campaign performance using key marketing metrics and KPIs
- Develop interactive dashboards and reports using business intelligence tools
- Analyze customer acquisition, retention, engagement, and conversion trends
- Track website, email, social media, SEO, SEM, and paid advertising performance
- Conduct customer segmentation and audience analysis to improve targeting strategies
- Measure Return on Investment (ROI), Return on Ad Spend (ROAS), Customer Acquisition Cost (CAC), Customer Lifetime Value (CLV), and conversion rates
- Perform A/B testing analysis and provide optimization recommendations
- Identify trends, opportunities, and risks through statistical analysis
- Collaborate with Marketing, Sales, Product, and Business teams to support strategic initiatives
- Automate recurring reports and improve reporting efficiency
- Ensure data accuracy, consistency, and governance across marketing platforms
Skills
- Bachelor's degree in Marketing, Business Analytics, Statistics, Economics, Mathematics, Computer Science, Information Systems, or a related field
- 2–5 years of experience in Marketing Analytics, Business Intelligence, or Data Analysis
- Strong analytical and problem-solving skills
- Excellent communication and presentation abilities
- Ability to interpret complex datasets and translate findings into business recommendations
- Advanced SQL
- Microsoft Excel (Pivot Tables, Power Query, Advanced Formulas)
- Power BI or Tableau
- Google Analytics 4 (GA4)
- Data Visualization
- Marketing Performance Reporting
- Python (Pandas, NumPy, Matplotlib)
- R Programming
- Google Tag Manager (GTM)
- Looker Studio
- CRM Analytics (Salesforce, HubSpot, Microsoft Dynamics)
- Basic ETL Concepts
- Google Analytics Certification
- Google Ads Certification
- Microsoft Power BI Data Analyst Associate
- Tableau Desktop Specialist
- HubSpot Marketing Software Certification
- Meta Certified Digital Marketing Associate
Company Overview
Company H1B Sponsorship