Home
Jobs
Saved
Resumes
Junior Data Analyst at Collinson | JobVerse
JobVerse
Home
Jobs
Recruiters
Companies
Pricing
Blog
Jobs
/
Junior Data Analyst
Collinson
Website
LinkedIn
Junior Data Analyst
United Kingdom
Full Time
7 hours ago
No Sponsorship
Apply Now
Key skills
Python
SQL
Tableau
R
Analytics
BI
Power BI
Salesforce
CRM
Leadership
Budgeting
A/B Testing
About this role
Role Overview
Build and maintain regular business and marketing performance reports
Analyse customer behaviour, retention, purchase frequency and lifetime value
Identify trends, risks and opportunities across customer and commercial performance
Produce clear insight summaries with practical recommendations
Develop segmentations and the identification of target groups for use in personalisation opportunities
Analyse campaign performance across email, SMS, push and onsite channels
Measure incremental impact of CRM and loyalty activity
Support A/B testing and experimentation analysis
Analyse incremental impact of loyalty activities
Experience building propensity, churn, cross/ upsell, customer engagement or customer lifetime value models
Develop predictive models and forecasting approaches to support commercial and customer decision-making
Support forecasting for revenue, customer value and campaign performance
Identify leading indicators and trends to inform proactive business actions
Work with stakeholders to translate predictive insights into practical commercial recommendations
Work with stakeholders to develop commercial models to identify likely ROI of new programmes and initiatives
Specify data extract requirements to support analysis and reporting requirements and campaign delivery
Extract, clean and validate datasets from multiple systems
Ensure reporting accuracy and consistency
Work with agency and client stakeholders to define reporting requirements and KPIs
Develop derived variables for targeting and personalisation through marketing automation platforms (e.g. Salesforce)
Help improve data structures and reporting processes
Identify data issues that will affect analytics and reporting
Support forecasting, budgeting and performance tracking
Identify opportunities to improve revenue, retention and customer engagement
Provide ad hoc analysis for leadership and commercial teams
Requirements
Minimum 2 years’ experience in a Data Analyst in an omni-channel marketing environment with complex datasets
Strong Excel skills including pivot tables, formulae and large dataset handling
SQL experience for querying and extracting data
Experience with BI tools such as Power BI, Tableau
Strong analytical and problem-solving skills
Ability to communicate complex findings in simple business language
Experience working with customer, marketing or transactional data
Experience in CRM, loyalty or lifecycle marketing analysis
Knowledge of customer segmentation and predictive modelling
Python or R experience
Experience with marketing automation or customer data platforms such as Salesforce, Braze, HubSpot or Klaviyo
Understanding of retention and customer lifetime value metrics
Tech Stack
Python
SQL
Tableau
Benefits
Opportunity to work on strategic client programmes with globally recognised brands
Collaborative work environment
Equal opportunity employer valuing diversity and inclusion
Apply Now
Home
Jobs
Saved
Resumes