> Markdown version of [/jobs/ext/2243572-lead-data-analyst](https://www.wearedevelopers.com/jobs/ext/2243572-lead-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Data Analyst - **Company:** Collinson Group - **Location:** Greater London, UK - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Microsoft Excel, A/B Testing, Big Data, Customer Data Management, Data Retrieval, Data Structures, Excel Formulas, Python (Programming Language), Automation of Marketing, Pivot Tables, Power BI, Standard Sql, Salesforce.Com, Tableau (Software), Klaviyo Email and SMS Marketing, Hubspot - **Published:** August 26, 2026 - **Apply:** https://www.collegerecruiter.com/job/2815148544-lead-data-analyst ## About the Role * 4+ years as a data analyst working with complex, multi-channel customer data * Strong SQL for querying and extracting data * Advanced Excel - pivot tables, formulae, large datasets * A BI tool: Power BI or Tableau * CRM, loyalty or lifecycle marketing analytics experience * The ability to explain complex findings in plain business language, * Python or R * Customer segmentation and predictive modelling * Marketing automation or CDP platforms (Salesforce, Braze, HubSpot, Klaviyo) * A feel for retention and customer lifetime value metrics, * Think commercially and care about outcomes, not analysis for its own sake * Are curious and go looking for the opportunities no one asked about * Can juggle several priorities without dropping the detail * Like working directly with stakeholders, internal and client-side ## Description Own the analysis behind loyalty programmes for some of the world's biggest travel, transport and financial brands. This is a standalone analyst role, so you'll run the numbers end to end. You will turn customer and CRM data into decisions leadership can act on, and you will see the commercial impact of your work directly. You'll sit in Collinson's loyalty division, where we treat loyalty as a strategic asset rather than a cost centre. What you'll do Insight and reporting * Build and maintain the reports the business runs on, and make them ones people rely on * Analyse customer behaviour, retention, purchase frequency and lifetime value * Turn analysis into clear recommendations non-technical stakeholders can use Loyalty and customer analytics * Build customer segmentations that drive personalisation and targeting * Measure campaign performance across email, SMS, push and onsite * Prove the incremental impact of CRM and loyalty activity * Support A/B testing and experimentation Modelling and forecasting * Build propensity, churn, cross-sell/upsell and customer lifetime value models * Forecast revenue, customer value and campaign performance * Spot leading indicators early and translate them into commercial actions * Model likely ROI on new programmes and initiatives Data * Specify, extract, clean and validate datasets from multiple systems * Develop derived variables for targeting in platforms like Salesforce * Improve data structures and reporting processes, and flag issues before they bite What you'll bring * 4+ years as a data analyst working with complex, multi-channel customer data * Strong SQL for querying and extracting data * Advanced Excel - pivot tables, formulae, large datasets * A BI tool: Power BI or Tableau * CRM, loyalty or lifecycle marketing analytics experience * The ability to explain complex findings in plain business language Nice to have * Python or R * Customer segmentation and predictive modelling * Marketing automation or CDP platforms (Salesforce, Braze, HubSpot, Klaviyo) * A feel for retention and customer lifetime value metrics You'll do well here if you * Think commercially and care about outcomes, not analysis for its own sake * Are curious and go looking for the opportunities no one asked about * Can juggle several priorities without dropping the detail * Like working directly with stakeholders, internal and client-side Why Collinson * Real ownership. As the sole analyst, the analysis is yours. Your work reaches leadership and shapes decisions. * Visible work. You'll analyse programmes running with major transport, travel and financial brands. * Breadth. Reporting, modelling, experimentation and data - not one narrow lane. Collinson is an equal opportunity employer and welcomes differences in all their forms, including colour, race, ethnicity, gender identity, sexual orientation, neurodivergence, family status, age, disability, and people from all backgrounds, cultures and experiences. Please feel free to note the pronouns you use. If you need any extra support during the interview process, email us at . ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Integrate your Cognitive Assistant with 3rd-party DBs and software](https://www.wearedevelopers.com/videos/249-integrate-your-cognitive-assistant-with-3rd-party-dbs-and-software) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london)