Data Analyst
Role details
Job location
Tech stack
Job description
As a Data Analyst, you'll be diving into projects ranging from transforming data using BigQuery SQL, creating and interpreting web analytics dashboards in Looker Studio and session replay analysis. This is a fantastic opportunity to showcase your skills in a broad range of activities within the digital marketing realm., + Own the flow of web analytics data from ingestion through transformation, modeling, validation, and delivery
- Ingest and integrate data from external sources, APIs, platforms, and internal systems
- Build robust SQL models from scratch to support reporting, analysis, and business decision-making
- Create and maintain closed-funnel logic in SQL for conversion, journey, and performance analysis
- Transform raw event-level and source data into clean, documented, business-ready datasets
- Manage and troubleshoot data flows across multiple systems and data dependencies
- Ensure data quality through reconciliation, validation, and issue detection
- Partner with analytics, product, marketing, and business stakeholders to translate questions into scalable data models
- Support reporting on traffic, engagement, funnel progression, and conversion performance
- Improve the reliability, maintainability, and structure of the analytics data layer
- Assist with Google Tag Manager - tag management and maintenance.
- Assisting in various tasks to support the smooth operation of the business.
- Building and maintaining analytics dashboards
- Client management and being responsive to client requests.
- Documenting processes for efficient planning and application of key services. A Typical Day in the Job:
-
Project management and client communication o Chasing updates and agreeing deadlines with third-party suppliers. o Providing clear and timely updates to clients on project progress, including highlighting blockers and proposed solutions. o Updating Trello cards for project management and reporting. o Messaging clients and suppliers on Slack for updates and client communications.
-
Data analysis and tracking o Testing tracking using Google Tag Manager and Google Analytics. o Documenting user journeys and creating Trello cards for tracking and resolving new tasks. o Reviewing data for accuracy, identifying missing or inconsistent information, and interrogating results.
-
Reporting and dashboards o Producing performance dashboards and reports in Looker Studio to support data visualisation for stakeholders. o Creating reports in Excel and PowerPoint presentations where required. o Using Looker Studio and BigQuery for KPI analysis and dashboard building. o Extracting and analysing data with SQL, BigQuery, GA4, and Looker Studio. o Reviewing website analytics on user behaviours, website performance, page loads and conversions.
Requirements
Strong verbal and written communication skills.
- Familiarity with data visualization tools like Looker Studio or Power Bi.
- Advanced skills in Excel and PowerPoint.
- Advanced SQL skills, including complex joins, window functions, CTEs, aggregations, and performance optimization Strong experience working with web analytics data Experience building data models from scratch in SQL Experience defining and creating closed funnels in SQL Hands-on experience managing end-to-end data flows and ingesting data from external sources Strong understanding of data validation, reconciliation, and troubleshooting Proficiency with Google Cloud Platform Working knowledge of Python for lightweight scripting, utilities, or support tasks Ability to work independently and take ownership of business-critical datasets, Degree - preferable (Not essential) GCSE Maths and English BigQuery SQL for Google Analytics or BigQuery MySQL
Benefits & conditions
Salary From £25k to £28.5k - depending upon experience plus profit share of around 15% per annum and an opportunity to develop a long career.
