Commercial Data Lead

We are seeking an experienced Commercial Data Lead to join a dynamic team on a short-term contract. This role is ideal for someone with a strong commercial and analytical background, particularly in industries such as financial services, membership subscriptions, software, or similar. You will design, build, and implement customer lifecycle models that quantify the drivers of member retention, renewal, and value, enabling the business to forecast future revenue, measure ROI by channel, and guide investment in growth and member experience.

Key Responsibilities:

• Discovery & Alignment:

• Collaborate with stakeholders across Data, Finance, Growth, Partnerships, and CRM to define key metrics, cohort definitions, and reporting needs.

• Ensure robust data sources and models are in place to support cohort-level analysis.

• Define clear ownership and handover plan for the internal FP&A team.

Model Design & Build:

• Develop scalable cohort models by acquisition month, service group, acquisition source, and member status or age banding.
• Build engagement, retention, and renewal curves across the full customer lifecycle.
• Create LTV models including transaction frequency, value over time, and associated variable costs to identify true contribution margin.
• Deliver scenario and sensitivity forecasting to support growth planning.
• Document all models to ensure they are reproducible and maintainable.
• Integrate cohort-based forecasting into existing financial models for budget process.

Reporting & Enablement:

• Build dashboards and reporting views to track cohort performance, engagement, renewal, retention, and monetisation metrics.
• Identify areas of over- or under-performance vs. expectations or previous cohorts.

Handover & Training:

• Provide detailed documentation and walkthroughs for the internal FP&A team.
• Recommend ongoing model maintenance cadence and data refresh processes.

Key Deliverables:

• Cohort analysis model (SQL-based tables, Excel outputs, dashboards) including LTV, engagement, renewal, and future assumptions.
• Documentation and training materials with handover sessions to the FP&A team.

Success Criteria:

• Accurate, scalable cohort and LTV models that are easily refreshed.
• Stakeholders can self-serve insights on member retention, renewal, and transaction trends.
• Models integrated into forecasting and strategic decision-making processes.
• Clear ownership and ongoing maintenance plan established.
• Alignment with existing data infrastructure (Redshift) and governance standards.

• Strong commercial data analytics experience in financial services, membership subscription, software, or similar sectors.
• Excellent SQL skills with experience building robust models and extracting insights from large datasets.
• Experience with cohort analysis, LTV modelling, and customer lifecycle analytics.
• Strong Excel and/or dashboarding skills (e.g, Tableau, Power BI).
• Excellent communication skills to engage with commercial and finance stakeholders.
• Ability to document, train, and hand over models to internal teams.

Contract Details:

• Leicester-based, 1-2 days per week on site.
• 2-month contract.
• Competitive day rate, inside IR35.

Macildowie is a specialist recruitment consultancy with a rich history of enhancing the careers of professionals across the Midlands and the Northern Home Counties. We have an unrivalled understanding of the local market place and recruit for the majority of the region's premier employers. To search for all of our live jobs please visit us at macildowie.com.