Data Analyst (Remote)
4 days ago
Chester
This is a great opportunity to join a long established and growing business where you will have the opportunity to develop a worthwhile career and be rewarded with good benefits and profit share. 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. You may have some or all of the skills/requirements below, but training can be provided in areas and you will have the chance to learn skills you are not currently familiar with. Location:(Fully Remote) About Us Data has the power to transform businesses, and we thrive on unlocking its full potential. We're looking for a data analyst who wants to take the next step up and join our growing team, offering a £25,000-£28,500 salary and the flexibility of a fully remote role. Specialising in a variety of sectors we offer a stimulating and diverse working environment. The Role 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. Key Skills and Experience • 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, • 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, • Chasing updates and agreeing deadlines with third-party suppliers., • Providing clear and timely updates to clients on project progress, including highlighting blockers and proposed solutions., • Updating Trello cards for project management and reporting., • Messaging clients and suppliers on Slack for updates and client communications., • Data analysis and tracking, • Testing tracking using Google Tag Manager and Google Analytics., • Documenting user journeys and creating Trello cards for tracking and resolving new tasks., • Reviewing data for accuracy, identifying missing or inconsistent information, and interrogating results., • Reporting and dashboards, • Producing performance dashboards and reports in Looker Studio to support data visualisation for stakeholders., • Creating reports in Excel and PowerPoint presentations where required., • Using Looker Studio and BigQuery for KPI analysis and dashboard building., • Extracting and analysing data with SQL, BigQuery, GA4, and Looker Studio. Degree – preferable (Not essential) GCSE Maths and English BigQuery SQL for Google Analytics or BigQuery MySQL Benefits: • Workplace pension enrolment., • Quarterly profit share (could be worth around 15% extra a year), • 20 days annual holiday rising each year of service, • Provision of a laptop, screen and headphones, • Company mobile phone., • Comprehensive training and mentoring. Join Us If you’re passionate about web analytics and data, and eager to contribute to a fast-growing agency, apply now to become part of our ambitious team!