Junior Analytics Analyst

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

Job summary

A leading digital marketing agency is seeking a Junior Analytics Analyst to design and develop data pipelines, ensuring data integrity and enabling data-driven decisions. The ideal candidate will have a strong background in data engineering and analytics, particularly in Google Cloud Platform. This role offers opportunities to work on innovative projects and utilize cutting-edge tools in the rapidly evolving field of data analytics.

Benefits

Vitality Healthy care package

Perkbox discount and points program

Access to Co-working spaces

LinkedIn Courses and time for training

Qualifications

• Proven experience as a data, business intelligence, or analytics engineer.
• Hands-on data modeling and warehousing skills.
• Excellent Python and SQL skills.

Responsibilities

• Design and implement scalable data pipelines on GCP.
• Develop data models for analytics and reporting.
• Monitor and improve data stack performance.

Skills

Python

SQL

Data Modeling

Data Warehousing

Analytical Thinking

Education

Bachelor's Degree

Tools

Google Cloud Platform

BigQuery

Snowflake

Job description

Get AI-powered advice on this job and more exclusive features.

This range is provided by Substance Global. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

JOB DESCRIPTION

Title Junior Analytics Analyst

Department Data, Insights & Strategy

Reports to Head of Insights & Strategy

SUBSTANCE GLOBAL

Substance Global is a digital marketing agency specialising in a range of services across different media and industries. We are proud of our work and our people in equal measure and our passion for what we do and the culture we have developed is what drives us in everything we do. Founded in 2003, we have grown to over 60 people in London, Los Angeles, Singapore and Buenos Aires. Our work is insights-driven and innovation-led and our strategies are made up of a blend of creativity and collaboration, tailor-made for each of our client’s brands.

GENERAL SUMMARY

As an Analytics Engineer, you will play a critical role in designing and developing data pipelines, ensuring data integrity, and enabling data-driven decision-making. The ideal candidate will have a strong background in data engineering and analytics, with expertise in Google Cloud Platform (GCP) services. This role requires a blend of technical proficiency, analytical thinking, effective project & time management, and communication skills. You will have the opportunity to engage in diverse, innovative projects spanning multiple platforms, including real-time data processing and emerging AI technologies, offering opportunities to work with cutting-edge tools and methodologies in the rapidly evolving field of data analytics.

Substance Global is a digital marketing agency; as such a proficiency in sentiment and social analysis via social listening tools like Brandwatch/Talkwater/ etc, working knowledge and of 3rd party tools such as Sprinklr, Sprout Social and GWI. As well as experience working with platform scraping tools like Fivetran/Adverity/Apify etc (working knowledge of JSON files and API calls).

How You’ll Make An Impact

• Design and implement high-performance, reusable, and scalable data models for our data warehouse using scheduling tools and GCP/BigQuery.
• Design and implement visualisation tools (explores, views, etc) which will enable users across the organization to self-serve analytics
• Work closely with key stakeholders to understand business requirements and provide data ready for analysis and reporting.
• Blended data approaches include owned, earned, and paid data sources. Plus, the inclusion of social listening and 3rd party data sources.
• Continuously discover, transform, test, deploy and document data sources and data models
• Apply, help define, and champion data warehouse governance: data quality, testing, documentation, coding best practices.
• Take initiative to improve and optimise analytics engineering workflows and platforms

Key Responsibilities

• Design, develop, and maintain scalable data pipelines on GCP (Or other cloud services ie. Snowflake) using services such as BigQuery and Cloud Functions.
• Designing and building data models for analytics, reporting, and data science applications in Looker/Metabase(Visualisation solutions) using (explores, views, etc) which will enable users across the organization to self-serve analytics.
• Strong Python (Pandas/SQL Alchemy) & SQL(BigQuery/Snowflake) skills for maintaining ETL/ELT pipelines.
• Developing tools and processes to ensure the quality and observability of data
• Monitoring and improving the performance and efficiency of the data stack
• Producing excellent documentation on all of the above
• Working in a small, agile team to build excellent data product
• Continuously discovering, transforming, testing, deploying, and documenting data sources and data models
• Building great relationships with stakeholders and understanding their needs and challenges. Being curious, adaptable, and willing to pitch in to help with data problems of all shapes and sizes

Qualifications

• Proven delivery experience as a data, business intelligence or analytics engineer
• Hands-on proven data modeling and data warehousing skills demonstrated in data environments
• Excellent Python & SQL and data transformation skills (e.g. ideally proficient in dbt or similar)
• Familiarity with at least one of these Cloud technologies: Snowflake, AWS, Google Cloud, Microsoft Azure
• Good attention to detail to highlight and address data quality issues
• Excellent time management and proactive problem-solving skills

What’s in it for you:

In-office/Hybrid or Fully remote.

️Vitality Healthy care package

️Perkbox discount and points program.

️Access to Co-working spaces.

LinkedIn Courses and time for training.

How to apply:

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

This role is perfect for a creative designer with the ability to push creative ideas to new heights.

EDI statement and our people pledge

Don’t meet every single requirement? Research shows that women and people of colour are less likely that other to apply if they don’t match 100% of the job requirements. Don’t let the confidence gap stand in your way, we’d love to hear from you! We understand that experience comes in many difference forms and are dedicated to adding new perspectives to the team.

Substance Global is committed to providing and fair, inclusive, and diverse work-environment. We believe that different perspectives lead to better ideas, and better ideas allow us to better understand the needs and interests of our diverse, global community with who we work. We welcome people of different backgrounds, experiences, abilities, and perspectives and are an equal opportunities employer.

Seniority level

• Seniority level

  Associate

Employment type

• Employment type

  Full-time

Job function

• Job function

  Analyst, Marketing, and Advertising

• Industries

  Marketing Services

Referrals increase your chances of interviewing at Substance Global by 2x

Get notified about new Analytics Analyst jobs in London Area, United Kingdom.

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 6 days ago

London, England, United Kingdom 1 month ago

Business Intelligence & Visualisation Analyst - Retail Media

London, England, United Kingdom 1 month ago

London, England, United Kingdom 4 months ago

London, England, United Kingdom 1 month ago

London, England, United Kingdom 5 days ago

London, England, United Kingdom 3 days ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 5 days ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.