Data Analyst

Mercator Digital; Camden Town; On-site; GBP 40,000 - 60,000; Full time

Job summary

A dynamic digital analytics firm in Camden Town is seeking a Performance Analyst to enhance data-driven decision-making. Responsibilities include translating business needs into analytics, creating visual dashboards, and ensuring robust data collection. The ideal candidate should have substantial experience in Google Cloud Platform and Google Analytics, with strong communication skills. This role offers an opportunity to work in a collaborative environment with diverse stakeholders.

Qualifications

• Experience as a Digital Analyst, especially with Google 360 Enterprise Analytics.
• Strong knowledge of Google Cloud and Azure databases.
• Proven web analytics reporting skills.

Responsibilities

• Translate business requirements into analytics requirements.
• Create visualizations of data and share insights.
• Ensure data collection and standardization.

Skills

Communication skills

Data visualization

Google Analytics

Google Tag Manager

SQL

Agile methodologies

Machine Learning

Tools

Google Cloud Platform

Azure SQL Database

Power BI

Jira

Confluence

GitHub

Job description

Overview

What we're looking for: We're seeking a dynamic, forward-thinking Performance Analyst with excellent communication skills. You will be open-minded, happy to work on your own or as part of a team and want to learn new technologies and promote best practice.

Responsibilities

• Understand product owners' needs to translate business requirements into analytics requirements and ensure that priorities are met.
• Create visualisation of data, conduct deep-dive analysis and share insights & recommendations.
• Ensure data collection and standardisation is met and explain methodologies to stakeholders.
• Communicate efficiently and work together within a multi-disciplinary team, fostering the open and collaborative culture.
• Enable data driven decision making to personalise the journeys of individuals to ensure they have the best and most appropriate experience.
• Produce product performance dashboards, user segmentation analysis, media agency tagging implementation.
• Produce program dashboards and weekly analysis/information updates.

Knowledge/experience

• Google Cloud Platform. Experience setting up and iterating:
• Google Cloud Platform Projects & IAM permissions
• Google Storage buckets and folders
• Google Dataprep flows, recipes and outputs as ETL pipeline to provide datasets for analysis and feed into dashboards.
• Experience working as a Digital Analyst using Google 360 Enterprise Analytics.
• Google Tag Manager containers and tags, triggers and variable to feed user behaviour and marketing activity tracking data into Google Analytics Properties.
• Google Analytics properties and views to provide user behaviour goals and funnels to enable product iteration
• Google Data Studio dashboards (with SQL, Google Sheets and Google Analytics sources) to share information with a broad range of stakeholders
• A proven track record of web analytics reporting, building dashboards & ad-hoc analysis.
• Experience in Social Media analytics (reporting, building dashboards & analysis)
• Experience in identifying and personalization of user journeys derived from quantitative analytics.
• Experience in Agile development environment (Scrum/Kanban).
• Azure SQL Database and Azure Cosmos Database experience
• Use of collaboration tools such as Jira and Confluence, Github and Trello.
• Excellent interpersonal, written and verbal communication skills and can present complex information persuasively and inclusively to a wide range of audience
• Understanding of the Azure Platform-as-a-Service (PaaS) cloud offering
• Reading, writing, and querying data in JSON format

Desired skills

• Implementing appropriate Machine Learning models, including selection and optimisation for automated outputs (and understanding model accuracy, limitations, biases, and ethics)
• SQL Management Studio for working with SQL code, Visual Studio, as appropriate to data related enterprise tooling tasks, Power BI for advanced data visualisation, Excel, including power query, pivot tables, and pivot charts
• Proven ability working to Government Digital Service Standards and documenting the necessary evidence to pass a GDS assessment.
• Previous Public Sector Experience
• Agile/Scrum certified
• Google Tag Manager

Applicants must have the right to work in the UK and the ability to pass BPSS vetting.