City of London
Who we are We Are Futures is unique agency with a powerful proposition: to build advocacy for brands amongst young people, through social impact. Twenty years ago, we saw the potential for brands to connect deeply with young people, teachers, families, and communities. We pioneered the idea that brands could positively shape young people’s futures. In return, we championed the role that young people could play to help brands thrive, growing together in a positive relationship. Since 2004, we've positively impacted over 40 million young people and 150 businesses. Today, we're the go-to agency for building brand advocacy amongst young people. Our newly created Marketing and Communication department consists of a passionate group of experts with specialist experience across all things marketing, product, data, digital and communications. We utilise a deep understanding of target audiences to deliver fully-integrated and creative multi-channel campaigns to build advocacy for brands amongst young people, with a core focus on reaching young people directly and via teachers, parents and the wider community. Our teacher network, the National Schools Partnership (NSP) is a CRM-backed owned website and collection of digital channels, which consist of over 125k highly engaged individuals. In addition to developing campaign strategies, our team are also responsible for campaign execution, delivering activity to land our client programmes, from implementation and optimisation to reporting and evaluation. The opportunity We are seeking an experienced Data Analyst to join the team The primary role of Data Analyst is to generate business intelligence, through the analysis of data, to convey insight and to measure and optimise the effectiveness of marketing. The Data Analyst will own strategic reporting and ensure KPIs, forecasts and targets are data-driven and aligned with budgets and strategic plans. They will work closely with internal stakeholders, campaign teams, and the Head of NSP Data & Performance to drive meaningful insights and embed performance thinking across the agency and will supervise the Data Executive role. Responsibilities Data planning • Set and manage benchmarks and performance targets across channels and clients, • Translate objectives into measurable performance indicators and data frameworks, • Maintain consistent reporting methodology and ensure accurate attribution of results, • Devise data collection strategy and specifications to collect the best digital and CRM data Performance reporting and insight • Drive the interpretation of cross-channel performance to support decision-making and campaign planning, • Support campaign leads with performance analysis, identifying variances from forecasts and recommending corrective action, • Collaborate with Analysts and Marketing to ensure reporting accuracy and data consistency Communication and collaboration • Communicate effectively and professionally with internal and external clients, including partners and suppliers, translating technical data with business requirements effectively, • Explain and narrate data and visualisations to highlight key insights to agency planners and other stakeholders in a way that is understandable and actionable Know-how and upskilling • Stay informed about marketing performance trends, benchmarks and measurement best practice, • Work to standardise methods and processes in line with best-practise and development of relevant techniques, tools, and technologies. Mentor and support our Digital Analyst and Data Executives in forecasting, reporting and performance evaluation Data management • Data manipulation and pre-processing: Acquire, extract, organise, deduplicate and transform data for analysis and reporting, • Data quality: Measure and manage data quality in the database to ensure data is kept updated and gaps addressed, • Segmentation: In conjunction with the Data Executive, ensure segmentation is correctly applied to the CRM database, campaign selections are correctly identified, forms are user-tested and correctly deployed, • Quality assurance: Support peer to peer quality assurance checks to ensure accuracy and compliance,, • Efficiency and optimisation: In conjunction with data colleagues, support the development of agency-wide data management processes to drive efficiency, quality and compliance Skills, experience, qualifications Skills • Data manipulation and analysis, • SQL for querying and manipulation of structured customer and campaign data (mandatory), • MS Excel including pivot tables, VLOOKUP, Power Query (mandatory), • Python or R for advanced data manipulation, statistical analysis and modelling (mandatory), • Data visualisation, • Power BI and/or Looker Studio for creating dynamic dashboards and reports in context of marketing KPIs (mandatory), • Forecasting, modelling and predictive analytics (highly desirable), • Predictive / statistical modelling, • Time series analysis, • Forecasting marketing metrics such as response, conversion and churn rate using historical campaign data, • Data-driven business casing and budgeting, • Marketing performance (mandatory), • Good knowledge of forecasting techniques, marketing performance / channel metrics, and KPI frameworks and targets, • Campaign planning and forecasting, • Campaign evaluation with the ability to normalise, benchmark and compare multi-channel campaign data to inform future targeting, • Working with diverse data sets including customer / CRM, web and social data, • Thinking, communication, storytelling and presentation (mandatory), • Strong analytical and critical thinking skills, • A proactive mindset with a drive for continuous improvement, automation and innovation, • Use of AI assistance to accelerate and help optimise outcomes, • Excellent communication and presentation skills – visualisation and simplification of complex data, • Use of analogy and storytelling to convey insights from data analysis, • Ability to convey key points to audiences that are less numerate, • Collaboration, organisation and multi-tasking (mandatory), • Able to work in teams, cross-teams as well as individually, • Good organisational and project management skills, with the ability to manage multiple priorities and stakeholders, • Ability to manage multiple projects and comfortable with context switching, • Understand and deliver service to internal customers and external clients Experience • Strong experience in a data analysis, marketing analytics, or performance measurement role, ideally in a marketing or digital agency (mandatory), • Experience building forecasts and KPI frameworks specifically tied to marketing campaign performance (highly desirable), • Experience setting up performance dashboards for tracking and refining campaign KPIs over time (mandatory), • Proven experience interpreting marketing and communications data to inform strategy and execution (mandatory), • Experience presenting analytical insights to internal and external stakeholders (mandatory), • Familiarity with CRM systems and campaign tracking tools (mandatory), • Experience in training and supporting junior team members (highly desirable) Qualifications • Bachelor’s degree in a quantitative field such as Mathematics, Statistics, Data Science, Economics, Marketing Analytics, or related discipline, • Professional certifications in data analytics, forecasting, or marketing analytics (e.g., Google Analytics, Microsoft Power BI, Tableau, CIM, or similar) (highly desirable), • Familiarity with tools or languages used for statistical forecasting (e.g., R, Python)