Examples of what you will be doing:
This role will suit an experienced business analyst that has demonstrated skills in data analytics and extensive experience in determining insight requirements to develop data-driven marketing and reporting within a product and services environment. You will work as part of the marketing team to support on identifying customer insights as well as leading on initiatives such as targeting and segmentation, data delivery, design, integration and reporting.
The role can be based in either Manchester, London or Milton Keynes, with the flexibility of home working.
Key duties and responsibilities
Support the development and delivery of existing and new reporting, BI & Analytics projects including NPS, the response to marketing briefs, securing and analysing required data, preparing the story and visualization, and presenting to internal and external stakeholders
Data lead in collaboration with Marketing on customer insights and engagement activities/plans with a customer-led approach through local customer targeting and segmentation, identify and activate adequate channels in order to engage, create loyalty and value for our customers. Develop new acquisition, retention and growth strategies aligned to customer life cycle stage and wider marketing initiatives
Provide sophisticated decision support in the form of reports and dashboards to Marketing leadership through the creation and enhancement of easy to access and interpret decision tools and dashboards
Data integration: ability to extract data from the back end databases of key business systems and perform data preparation techniques in order to integrate datasets from multiple sources
Data modelling: design, build and maintain data models/cubes with measures and dimensions
Experience in advanced analytics, ability to evaluate and embrace latest technologies (e.g. predictive data solutions).
Knowledge of industry trends and developments including GDPR, Legitimate Interest and Consent based marketing
Data and Technical Product Experience
Competent with data processing & modelling, utilising best practices
Extensive knowledge in dealing with data in an SQL environment
A fundamental understanding of ETL to perform effective database querying involving multiple data tables
Understanding of Data Warehouse Architecture, Power BI, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), both multi-dimensional and tabular.
Experienced in the use of Advanced Analytics and Google Analytics
Advanced knowledge of digital and direct media channels and broader marketing advertising requirements
Highly skilled in manipulating data in Excel for analytical purposes (vlookups and pivot tables) including knowledge and experience of advanced formulas, data transformation handling large datasets, tables and formatting, conditional formatting etc.
A bit about you
Proven working experience as a data analyst or business data analyst – 4+ years of experience in analytics of which 2 years should be in marketing related analytics work and performance reporting and good grounding on other data management and analytical related work
Effective at communicating complex ideas and analysis with developers and non-technical stakeholders
Experience of working cross-functionally with teams including marketing, sales and online.
Ability to work in a fast pace matrix organisation and deliver quick wins as well as future vision and roadmaps.