Marketing Data Analyst Marketing Operations

Job Description

Marketing Data Analyst ManchesterExamples 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 responsibilitiesSupport 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 stakeholdersData 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 initiativesProvide 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 dashboardsData 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 sourcesData modelling: design, build and maintain data models/cubes with measures and dimensionsExperience 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 marketingData and Technical Product ExperienceCompetent with data processing & modelling, utilising best practiceExtensive knowledge in dealing with data in an SQL environmentA fundamental understanding of ETL to perform effective database querying involving multiple data tablesUnderstanding 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 AnalyticsAdvanced knowledge of digital and direct media channels and broader marketing advertising requirementHighly 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 youProven 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 workEffective at communicating complex ideas and analysis with developers and non-technical stakeholdersExperience of working cross-functionally with teams including marketing, sales and onlineAbility to work in a fast pace matrix organisation and deliver quick wins as well as future vision and roadmaps.