|Job Category||Data and CRM|
Fabulous marketing agency looking for an analyst with experience using SQL
My client is an award-winning marketing agency who tap into the relationships consumers have with brands, focus on behaviours and use neuroscience to develop more creative and transformational campaigns.
This is an interesting data analyst role working across analysis of field marketing and social media marketing.
If you have experience working in data analysis, strong SQL and Excel, and have some experience working in the marketing / market research arena then this could be the role for you
- You will analyse, report and deliver recommendations using your data analysis skills – using Excel or SQL Server Management Studio
- Provider weekly and monthly reports using quantitative and qualitive data
- Create bespoke analytical dashboards (in Microsoft Visual Basic or Power BI)
- Create and analyse filled geographic maps
- Visualise data led insight and communicate this to stakeholders
- Evaluate social media, social listening and provide post campaign analyses
Skills and Experience
- Strong Excel and SQL experience – preferably SQL Server (T-SQL)
- Dashboarding and visualisation experience
- Some experience working within marketing (whether that be field marketing, CRM, direct marketing, digital or social media)
- The ability to import, export, cleanse, de-dupe and transform data in SQL databases.
- The person in this role is responsible for reporting business-critical numbers so you need to have excellent attention to detail
- Social media, digital effectiveness reporting and social listening experience would be helpful but if you have an interest in this area then training can be provided
This is role also provides the opportunity to nurture your data skills and to work with a team of planners and strategists so there is an opportunity to hone your strategic skills if that appeals to you.
The salary for this role is between £28Kto £31K and will be work from home initially moving to flexible working (part -based home and part-based office) when things return to some kind of normality…