Remote Data Analyst - Media Campaign Insights

Sotalent; California; Remote; USD 50,000 - 62,000; Full time

Benefits offered by this job

Medical, dental and vision insurance

Life insurance options

Paid vacation, sick leave and company

Employee Assistance Programme

Financial wellness programmes

Job summary

Sotalent, a remote US-based role with California alignment, is seeking a Marketing Data Analyst to support the measurement and reporting of multi‑platform media campaigns. You will prepare and analyse campaign data, build notebooks and visualisations, and connect advertising metrics with KPIs, sales and consumer insights.

You will work with data and sales teams to deliver accurate, actionable reporting that drives client performance and revenue growth.

Qualifications

• 4+ years of experience in media analytics or data preparation.
• Strong Python skills with Pandas for data manipulation.
• Proficiency in SQL and Excel.
• Experience with AWS and Linux environments.
• Experience with data visualisation tools; Looker Studio preferred.
• Bachelor's degree or equivalent.
• Strong analytical and communication skills.
• Ability to manage competing priorities in a fast-paced environment.

Responsibilities

• Develop, maintain and troubleshoot data notebooks.
• Extract, transform, validate and prepare campaign datasets.
• Run queries across AWS and BigQuery environments.
• Analyse relationships between media campaigns, sales performance and consumer data.
• Match media assets with tracking mechanisms and campaign KPIs.
• Create standardised and customised datasets, reports and data visualisations.
• Analyse campaign performance and provide observations and actionable insights.
• Manage multiple client accounts, projects and reporting deadlines.
• Collaborate with sales and data teams on media analytics.

Skills

Python (Pandas)

SQL

Excel

Looker Studio

Education

Bachelor's degree

Tools

AWS

Linux

Job description

Sotalent, a remote US-based role with California alignment, is seeking a Marketing Data Analyst to support the measurement and reporting of multi‑platform media campaigns. You will prepare and analyse campaign data, build notebooks and visualisations, and connect advertising metrics with KPIs, sales and consumer insights.

You will work with data and sales teams to deliver accurate, actionable reporting that drives client performance and revenue growth.