Junior Analytics Analyst

Substance Global; Greater London; Hybrid; GBP 30,000 - 40,000; Full time

Job summary

A leading digital marketing agency is seeking a Junior Analytics Analyst to support data-driven decision-making. The role involves designing data pipelines, ensuring data integrity, and collaborating on diverse projects with cutting-edge tools. Ideal candidates should have experience in data analytics and familiarity with cloud technologies.

Benefits

Competitive salary

23 days holiday

Flexible working options

Health care

Discounts

Co-working spaces

Training resources

Qualifications

• Experience in data engineering, business intelligence, or analytics roles.

Responsibilities

• Design and implement scalable data models for our data warehouse.
• Create visualization tools for self-serve analytics.
• Collaborate with stakeholders for data analysis.

Skills

Data Quality

Problem Solving

Tools

Python

SQL

dbt

GCP

Snowflake

AWS

Azure

Job description

JOB DESCRIPTION

Title: Junior Analytics Analyst

Department: Data, Insights & Strategy

Reports to: Head of Insights & Strategy

Company Overview:
Substance Global is a digital marketing agency specializing in a range of services across different media and industries. Founded in 2003, with over 60 employees across London, Los Angeles, Singapore, and Buenos Aires, we pride ourselves on our insights-driven and innovation-led work, blending creativity and collaboration tailored to each client's brand.

Role Summary:
As a Junior Analytics Analyst, you will support designing and developing data pipelines, ensuring data integrity, and enabling data-driven decision-making. The ideal candidate will have a background in data analytics with familiarity in social listening tools, data modeling, and cloud technologies. You will engage in diverse projects including real-time data processing and emerging AI technologies, working with cutting-edge tools and methodologies.

Responsibilities:

• Design and implement scalable data models for our data warehouse using GCP/BigQuery or similar platforms.
• Create visualization tools to enable self-serve analytics across the organization.
• Collaborate with stakeholders to understand requirements and prepare data for analysis and reporting.
• Manage data sources including social listening and third-party data, ensuring quality and consistency.
• Document data sources, models, and workflows, and promote data governance best practices.
• Optimize analytics workflows and platforms for efficiency.

Qualifications:

• Experience in data engineering, business intelligence, or analytics roles.
• Proficiency in Python, SQL, and data transformation tools like dbt.
• Knowledge of cloud platforms such as GCP, Snowflake, AWS, or Azure.
• Strong attention to data quality and problem-solving skills.

Benefits:

• Competitive salary and 23 days holiday.
• Flexible working options: in-office, hybrid, or remote.
• Health care, discounts, co-working spaces, and training resources.

Application Process: Send your CV and portfolio link to: [e-mail]

Our Commitment: We encourage diverse applicants and are committed to an inclusive environment. Experience can come from many backgrounds, and we welcome your application even if you don't meet every requirement.