Data Insights Analyst Jobs in Guildford, Surrey
Business Intelligence Developer
Position type: Full time, permanent, 37.5 hours per week
Responsible to: IT Business Analysis Manager
Direct reports: None
Location: Truro, Cornwall (hybrid – mixture of office and home working) or remote working (UK only) may be considered (with regular travel to Truro at least 4x per year).
About the Role
As a Business Intelligence (BI) Developer, you will collaborate with our Business Analyst (BA) Manager to design, develop, implement, document, and maintain robust data modelling and reporting solutions. Your role will involve hands-on work, including prototyping solutions, testing ideas, and collaborating with organisational colleagues. Working closely with our Data Manager and Data Technician, you will also contribute to our data warehousing solution and the development of data pipelines and be responsible for data preparation, modelling, and utilising DAX. You will also work closely with our fundraising Insight team, creating analytic solutions to support our fundraising efforts.
Who are we looking for?
We are seeking an individual who is passionate about data and analytics and possesses meticulous attention to detail. You should be driven to produce high-quality solutions. Excellent written and verbal communication skills and the ability to prioritise tasks and efficiently manage multiple responsibilities are essential. Furthermore, you should have experience with the following technologies and a solid understanding of querying, query optimisation, dimensional modelling design, and data visualisation techniques:
- BigQuery
- SQL
- Power BI
- DAX
- Google Analytics
What you will be doing in the role:
- Working with people across the organisation to understand their analytical requirements.
- Developing, testing, and implementing analytical solutions and data visualisations that empower teams to gain valuable insights from their data.
- Taking ownership of new and existing data models.
- Managing the lifecycle of data models and reporting solutions.
- Working with the BA Manager to define best practices and facilitate knowledge sharing for Power BI development, governance, and deployment across the organisation.
- Ensuring that development aligns with the overall BI strategy and adheres to best practices.
- Responding to incidents and change requests related to existing solutions via our AutoTask helpdesk solution.
- Updating and managing tickets appropriately and timely as the Service Desk Manager sets out, ensuring good communication and customer satisfaction.
- Composing technical and team documentation as required.
- Collaborating and demonstrating analytical solutions to the broader team before roll-out.
- Offering input and advice on processes and practices to improve the team's efficiency and effectiveness.
- Assisting with implementing new solutions, as necessary, with the Business Systems Transformation project.
- To undertake any other duties as requested by the IT management team per the scope and responsibilities of the role.
The client requests no contact from agencies or media sales.
Job summary:
Recently named Charity of the Year by Just Giving Awards 2022, we’re committed to moving further, faster to accelerate change for everyone affected by a brain tumour. Brain tumours kill more children and adults under 40 in the UK than any other cancer. We know that a cure can’t wait.
We understand the power data has to accelerate research and maximise impact and we are determined to be truly evidence based in everything we do.
We are building a loyal and engaged community whose support will help us to fight brain tumours on all fronts; through research, support and campaigning, to save lives and improve quality of life — and this is where you come in. We need you, a talented marketing insight specialist to help us develop and deliver our strategy.
Who we’re looking for:
A rare breed of marketer/fundraiser and data analyst, with the unique ability to analyse and interpret data, you’ll be able to tell the insight stories needed to drive and evolve campaigns and develop new products.
You’ll have a natural curiosity to explore and interrogate all the data points available to us (both on and offline), being able to clearly communicate to non-technical colleagues at all levels.
You’ll have experience of working either as part of a marketing team or directly with marketers or fundraisers, and be able to pro-actively provide insights that deliver real change.
And you’ll work your socks off, because you know that #ACureCantWait
Key accountabilities:
Use insight and analysis to inform and guide the Fundraising and CX team:
· Work with the Head of CX to manage all campaign analysis and insight projects and ensure that interpretations of the findings and insights are delivered to the appropriate stakeholders in order to inform and drive future performance and strategies
· Manage the analysis of fundraising campaigns and products, working closely with the relevant fundraising teams to identify key learning and make recommendations for future activity
· Build dashboards and ways of visualising data that fundraisers can use on a daily basis to track, report on and optimise their campaigns
· Work with others across the CX team to report against testing schedules and strategies
· Run segmentations as required for fundraising teams
· Ensure that completed insight is effectively disseminated to internal customers and that they understand and use it
· Work with the Head of CX to guide, plan and implement market research as required
· Work with the management team to ensure reporting, performance and insight is made available across the organisation for all key channels and activities eg website, CX journeys, email etc
· Stay current with legal and regulatory frameworks, including; Data Protection legislation and the Code of Fundraising Practice, to ensure that all campaigns comply with current email best practice in the industry.
You’ll be a great fit if:
We encourage you to apply to the role even if you do not meet all of the criteria.
Experience:
· Relevant experience of running (design and implementation) both qualitative and quantitative insight projects
· Able to communicate technical issues in a clear positive way at appropriate level
· Working with personas and data segmentations for campaigns
· Manipulating and interpreting large sets of data according to client requirements
· Using insight to aid product development as well as campaign strategy/implementation
· Project management
· Charity experience would be an advantage
· Experience in working with SalesForce and/or SalesForce Marketing Cloud
· Understanding of the structure of databases and their implementation
Knowledge, Skills & Abilities:
· Sound understanding of direct marketing practices
· Microsoft Excel (Advanced)
· BI visualisation software—eg Microsoft Power BI
· Digital automation and CX software – eg SalesForce Marketing Cloud Interactive Studio, PeopleStage, Pardot etc
· Familiarity with analytical and database tools
· Hands on experience with content management systems
· Advanced use of an ESP – such as Marketing Cloud, DotDigital or similar
· Market research tools – eg Alchemer or SurveyMonkey
· Analytical thinker with the ability to interpret complex information
· Excellent communication skills with a high attention to detail
· Strong project management, prioritising and organisational skills with the ability to work under tight deadlines
*Please note that the responsibilities listed are not exhaustive and this job description may be subject to change as the role evolves over time.
What we’d like to give you:
You’ll be joining a collaborative, bold and innovative team of individuals who put our community first and are connected by a passion to make a real difference.
Location: While contracted to our office in Fleet, Hampshire, our team supports a blend of office and home working provided you have adequate broadband and IT capability, with an average of 2-3 days in the office each week.
Working hours: This role is 37.5 hours per week, with some out of hours working.
Benchmarked salary: C. £32,960 (dependent on level)
Our amazing benefits:
· 25 days annual leave (pro-rated for those who are part-time). Increases yearly with length of service
· Celebrate your work anniversary in true Charity style
· Occupational Sick Pay
· Hybrid working
· Flexible working
· Charity pension
· 1 day life leave per year to celebrate a special moment of your choice
· Wellbeing support including professional counselling
· A personalised on-boarding programme
· Cycle to Work Scheme
· Perkbox – our team discount portal
· Health care vouchers
*Some of these benefits are non-contractual and are subject to change
Diversity & Inclusion:
The Brain Tumour Charity is committed to promoting diversity and inclusion in all aspects of our organisation. We particularly welcome applications from individuals belonging to minority ethnic groups, LGBTQ+ communities, people with disabilities, and other underrepresented communities.
We strive to create a workplace that celebrates diversity and provides equal opportunities for all candidates and we encourage all individuals to apply even if they don’t meet all the criteria.
You can find out more about what we’re doing to become a diverse organisation here.
Eligibility to work:
Whilst we'd love to have you on board, we want to be upfront as we’d hate to waste your time applying for a role where we can’t take you on. At the moment, we're unable to offer visa sponsorship for any of our positions. We're currently seeking candidates who are already authorised to work in the UK without the need for sponsorship, who can remain on a permanent basis.
How to apply to our team:
Please apply by clicking the red ‘join our team’ button on our website, attaching your CV and a covering letter explaining why you want the role, what you would bring to the team and how your skillset and experience will enable us to make a real impact for those affected by brain tumours.
We are keen to ensure that our recruitment process is inclusive so if you’d find it beneficial to submit your application in a different format, please email us.
Advert close date: 3 April 2024
First interview date and location: 8 or 9 April 2024 over Zoom
Second interview date and location: TBC at our office in Fleet
The post holder will also:
· Contribute to achieving the objectives of The Brain Tumour Charity
· Live and breathe our values by being bold, collaborative and innovative, with a community-first approach to everything you do
· Undertake any additional and ad hoc tasks as required
· Participate in team meetings and other meetings as required
· Monitor and evaluate activities and provide written reports
· Represent The Charity at external events in a professional manner
· Work within an equal opportunities framework
· Adhere to all The Charity’s policies, procedures and working
· Ensure all records are held in compliance with GDPR, The Fundraising Regulator Code of Practice and The Brain Tumour Charity policies
We process your data in accordance with the Data Protection Act 2018 and the General Data Protection Regulation. For full details, please read our privacy policy for job applicants.
The client requests no contact from agencies or media sales.
Actively Interviewing
This organisation is scheduling interviews as the applications come in. Don’t miss your opportunity, apply now!
Overall purpose:
Principal Accountabilities:
As Marketing Executive in the Marketing & Communications team, you will support our marketing activity to help grow our brand, our supporter base and increase engagement with individuals and businesses within the automotive industry. You’ll work closely and collaboratively with colleagues to deliver the best possible results for digital communications delivered via content on our website, social channels and email to support the delivery of Ben’s overall Health & Wellbeing content strategy.
- Develop our social media channels to grow audiences and increase engagement with the people we support, and who support Ben
- Produce high-quality content that key audiences will find interesting and useful and meets strategic objectives
- Support to develop a programme of regular content for social channels, email and website and maintaining and updating calendars as appropriate
- Work with the Digital Marketing and Engagement Manager to plan and deliver the Health & Wellbeing calendar of awareness content and engagement
- Plan and deliver all digital communications in line with the overall campaign/content planners and internal processes are managed effectively
- Plan, create and develop content which is tailored to audience personas
- Work with colleagues to develop content that is relevant for our audiences and is channel and brand appropriate
- Manage end to end email process – from creating emails, automations, using correct data & segments to sending & then evaluating campaigns
- Use a test and learn approach in order to learn from user behaviour and to ensure Ben leverages digital communications channels to reach and engage target audiences
- Support online advertising (social, retargeting and PPC)
Experience required:
(E = Essential / D = Desired):
- 2+ years content writing experience
- Writing, creating and producing content in multiple formats for various audiences and touch points
- Managing end to end email production from data management and segmentation to email creation to sending and evaluation
- Creating effective content and supporting others to do this
- Understanding and application of brand guidelines
- Excellent spelling and grammar, with the ability to change the tone of voice dependent on the audience
- Practical content gathering, writing, and editing
- Managing online and social media advertising campaigns
- Understanding and creation of on-page SEO and knowledge of the wider SEM implications
- Use of CMS, web platforms such as Umbraco
- Use of collaborative tools such as Google Drive, Trello, Teams etc
- Social media channels, analytics and scheduling software e.g. Sprout Social
- Using a test and learn approach to increase engagement
- Working in a collaborative and consultative way with in-house teams, taking account of others priorities and helping others to achieve their goals
- Strong organisational & project management skills
- Experience of working for a charity or not-for- profit organisation (D)
Technical Knowledge:
(E = Essential / D = Desired):
- Degree level qualification (D)
- Digital marketing qualification
- High level of computer literacy and the ability to pick up new systems and software quickly
- Knowledge of Adobe Acrobat Creative software (D)
- Knowledge of marketing principles and techniques
- Understanding of how data describes audiences and how this impacts the development and evaluation of content
- Great understanding of user journeys
- Understanding of charity working regulation and standards (D)
- Understanding of the automotive industry of its needs and requirements (D)
The client requests no contact from agencies or media sales.
Actively Interviewing
This organisation is scheduling interviews as the applications come in. Don’t miss your opportunity, apply now!
Overall purpose:
As Fundraising and Campaigns Marketing Manager in the Marketing & Communications team, you will drive Ben’s fundraising and commercial services with individuals and businesses within the automotive industry. You’ll work closely and collaboratively with colleagues to deliver the best possible results for communications delivered both digitally and physically (this can include content on our website, social channels, email and printed materials) to support the delivery of Ben’s overall strategy.
Principal Accountabilities:
- Managing the day-to-day marketing of fundraising/income campaigns using a test-and-learn approach across a range of new and existing channels and products
- Managing campaigns and projects from planning to delivery and evaluation, ensuring they are delivered on time and on budget
- Assisting with the ongoing monitoring and optimisation of fundraising campaigns and products
- Researching competitor campaigns, market trends, new tools and platforms
Planning and organising
- Create and execute Fundraising and Marketing plans to promote Ben’s services, events and campaigns against budgets and with clear ROIs, in line with longer-term org strategy
- Work across the range of fundraising and commercial products and services, to ensure pricing, positioning and promotional activities are aligned for maximum impact
- Support to look after brand management of Ben’s fundraising and commercial brands (DoIt4Ben, ILC, Ben Ball, Ben Training etc.)
- Plan, create and develop high-quality content which is tailored to audience personas, which they will find engaging and meets strategic objectives
- Utilise various channels, including social media, website, email marketing and traditional media, to reach the target audience effectively
- Support to develop a programme of regular content. Maintaining and updating Ben wide calendars as appropriate
- Work with colleagues to develop new products and update existing products that are relevant for our audiences that are channel and brand appropriate
- Manage the design, production and distribution of marketing collateral (digital and print), making sure it is consistent with our messaging, tone of voice and is audience appropriate
- Manage end to end email process – from creating emails, automations, using correct data & segments to sending & then evaluating campaigns
- Support online advertising (social, retargeting and PPC)
- Use a test and learn approach in order to learn from user behaviour and to ensure Ben leverages digital communications channels to reach and engage target audiences
Experience required:
(E = Essential/D = Desired):
- Significant marketing and fundraising experience and responsibility within a non-profit environment (minimum 2 years) (E)
- Experience of creating and delivering an annual programme of marketing (E) and fundraising activity (D)
- Experience of working in the automotive industry either in a campaign or hands on capacity (D)
- Experience of delivering strong ROI on fundraising campaigns (E)
- Confident communicator at all levels of the organisation, with the ability to work collaboratively across different areas of the organisation as required (E)
- Very strong organisational and project management skills, with the ability to prioritise tasks and activities across multiple, simultaneous projects (E)
- Understanding and interpreting data (D)
- Experience of traditional and online marketing with an excellent understanding of the digital landscape (E)
- Writing, creating and producing content in multiple formats for various audiences and touch points (E)
- Managing end to end email production from data management and segmentation to email creation to sending and evaluation (E)
- Understanding and application of brand guidelines (E)
- Understanding and creation of on-page SEO and knowledge of the wider SEM implications (D)
- Social media channels, analytics and scheduling software e.g. Sprout Social (D)
Technical Knowledge:
(E = Essential / D = Desired):
- Degree level qualification and/or digital marketing qualification (D)
- Understanding of the principles of customer journey planning and stewardship (E)
- Knowledge of regulatory environment for fundraising including data protection, Gift Aid and fundraising codes of practice and regulation (E)
- High level of computer literacy (MS Office)
- Experience of using CRM (Salesforce) and CMS (Umbraco) systems (D)
- Project management/collaborative working tools (E)
- Knowledge of Adobe Acrobat Creative software (D)
- Knowledge of marketing principles and techniques (E)
- Understanding of how data describes audiences and how this impacts the development and evaluation of content (E)
- Strong attention to detail (E)
- Using a test and learn approach to increase engagement (D)
The client requests no contact from agencies or media sales.