Data Analyst
Legends
SQLTableau
Data Analyst, Marketing
Trade Nation
full-time
Posted on:
Location Type: Hybrid
Location: London • 🇬🇧 United Kingdom
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
Amazon RedshiftETLNumpyPandasPythonSQLTableau
About the role
- Develop automated dashboards and recurring reports to track campaign performance, customer acquisition, and retention metrics.
- Build and maintain marketing KPIs (e.g., CAC, LTV, conversion rates, ROI).
- Extract, clean, and transform large datasets from multiple marketing platforms (e.g., Google Ads, email, and web analytics tools).
- Analyse channel performance and attribution data to provide insights to wider Marketing Team.
- Assist with A/B tests and analyse their statistical significance.
- Identify trends, patterns, and opportunities in customer and campaign data to inform strategy.
- Design and maintain ETL pipelines using Python and SQL for marketing data.
- Integrate data from APIs, S3 Storage and Redshift Data Warehouse.
- Ensure data quality, accuracy, and consistency across all marketing sources.
- Use Python for predictive modelling (e.g., churn prediction, customer segmentation, marketing mix modelling).
- Apply statistical methods and machine learning techniques to improve campaign targeting and personalization.
- Partner with marketing, sales, product, and finance teams to align data insights with business objectives.
- Communicate findings clearly through visualizations, reports, and presentations.
Requirements
- Bachelor’s degree in a STEM or Marketing-related field or equivalent work experience required.
- 5 + years’ experience in Data Analytics, with strong expertise in both SQL and Python.
- Advanced proficiency in SQL, including writing complex queries, joins, aggregations, CTEs, and window functions.
- 2 + years of hands-on experience with Python for data manipulation and analysis (pandas, numpy, matplotlib).
- Experience designing and implementing data visualisation dashboards using BI tools, such as Metabase, Tableau, PowerBI, Looker.
- Familiarity with marketing analytics platforms such as Google Analytics, Meta Ads, HubSpot, and Salesforce.
- Knowledge of web analytics platforms, such as Amplitude, Mixpanel, PostHog.
- Understanding of A/B testing, attribution models, and digital marketing performance metrics.
- Awareness of data governance principles and best practices for ensuring data quality.
- Strong ability to communicate analytical findings clearly and effectively to both technical and non-technical stakeholders.
- Proven experience managing multiple projects and priorities in a fast-paced environment.
- Demonstrated capability to collaborate with stakeholders to transform reports and data into actionable business insights.
Benefits
- Competitive salary, and discretionary annual bonus.
- Private healthcare.
- Life Insurance, Critical Illness & Income Protection cover.
- Active Lifestyle allowance.
- Annual leave above minimum entitlement.
- Up to 3 weeks allowance to work in any location.
- Fresh fruit weekly
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data analyticsSQLPythonETL pipelinesdata visualizationpredictive modelingstatistical methodsmachine learningdata manipulationA/B testing
Soft skills
communicationcollaborationproject managementanalytical thinkingproblem-solvingattention to detailadaptabilitystakeholder engagementstrategic thinkingtime management
