Marketing Data Analyst

Sotalent; United States; Remote; USD 56,000 - 67,000; Full time

Benefits offered by this job

Remote-friendly hours

Professional development fund

Medical benefits

Company laptop

Internet allowance

Summer Fridays

Paid parental leave

401(k) match

Holiday closure

Job summary

Sotalent is seeking an early-career Marketing Data Analyst to support reporting and analytics for B2B campaigns. The role focuses on collecting and preparing data, maintaining dashboards, and ensuring tracking accuracy across digital marketing, CRM, and campaign platforms.

You will work remotely in the US or Canada with ET working hours, collaborating with internal teams to define KPIs and reporting requirements, while leveraging AI tools to enhance data workflows.

Qualifications

• Advanced Microsoft Excel skills: formulas, XLOOKUP/VLOOKUP, PivotTables, data formatting.
• Recent graduate or early-career with internships/projects welcome.
• Strong attention to detail and data quality understanding.
• Able to work with structured data, identify inconsistencies and document issues.
• Strong written and verbal communication skills.

Responsibilities

• Collect data from web analytics, paid media, CRM and marketing automation platforms.
• Clean, validate and prepare datasets using Excel and approved tools.
• Identify missing data, duplicates, and reporting errors.
• Maintain dashboards by refreshing data and checking calculations.
• Support creation and QA of dashboards, charts, tables and presentations.
• Assist with website tracking QA: tags, conversion events, URLs.
• Coordinate with teams to confirm data sources and KPI definitions.
• Support recurring and ad hoc reporting requests and analytics projects.
• Use AI tools to support data preparation, following privacy requirements.

Skills

Excel mastery

Data analysis

Communication

Time management

Education

Bachelor's degree in Analytics or related field

Tools

SQL

GA4

Looker/Looker Studio

PowerPoint

Google Ads / Campaign tools

Job description

Marketing Data Analyst – B2B Campaign Analytics

Location: Remote, US or Canada

Employment type: Full-time

Salary: $56,000–$67,000 per year

Working hours: Eastern Time (EST)

Overview

An opportunity is available for an early-career Marketing Data Analyst to support reporting, measurement and analytics across B2B marketing campaigns. The role focuses on collecting and preparing data, maintaining dashboards, checking tracking accuracy and supporting reporting across digital marketing, CRM and campaign platforms.

Key Responsibilities

• Collect and organise data from web analytics, paid media, CRM and marketing automation platforms.
• Clean, validate and prepare datasets using Excel and other approved tools.
• Identify missing data, duplicates, inconsistent formatting and reporting errors.
• Maintain dashboards by refreshing data and checking calculations, filters and reporting accuracy.
• Support the creation and quality assurance of dashboards, charts, tables and presentations.
• Assist with website tracking QA, including tags, conversion events and URLs.
• Coordinate with internal teams to confirm data sources, KPI definitions and reporting requirements.
• Support recurring and ad hoc reporting requests, presentations and analytics projects.
• Use AI-enabled tools such as ChatGPT and Claude to support data preparation and workflows, following data privacy requirements.

Requirements

• Degree, diploma or equivalent learning in Analytics, Marketing, Business, Economics, Mathematics, Statistics, Information Systems or a related field.
• Recent graduate or early-career professional; internships, projects and relevant work experience are welcome.
• Advanced Microsoft Excel skills, including formulas, XLOOKUP/VLOOKUP, PivotTables, charts and data formatting.
• Strong attention to detail and understanding of data quality and reporting accuracy.
• Ability to work with structured data, identify inconsistencies and document issues.
• Strong written and verbal communication skills.
• Good organisation, accountability and ability to meet deadlines.
• Interest in B2B marketing, digital analytics and campaign performance.
• Interest in using AI tools to support analytical work.
• Google Analytics 4 (GA4), Google Tag Manager or Adobe Analytics.
• Looker, Looker Studio or other data visualisation tools.
• Google Ads, LinkedIn Campaign Manager or Microsoft/Bing Ads.
• SQL, statistics, PowerPoint or marketing automation platforms.
• Flexible paid time off and summer Fridays.
• Paid parental leave.
• Medical benefits and wellness support.
• 401(k) company contribution (US employees).
• $500 professional development fund and ongoing training.
• Company-provided laptop and accessories.
• Monthly internet and mobile phone allowance.
• Company closure between Christmas and New Year.

Additional Information

• Remote position requiring availability during Eastern Time (EST) working hours.
• Applicants must be eligible to work in the United States or Canada without visa sponsorship.