A specialist education group that develops talent within the experience and hospitality industry is seeking an experienced Business Analyst (Power BI) to join their Marketing and Enrolment Team. This is a critical role for the successful transformation of the team's tech stack into a data lake environment, and for the switch from Tableau to Power BI for Visual Analytics.

The ideal candidate will have at least 5 years in an equivalent role, as well as a comprehensive knowledge of Power BI Reporting, DAX Programming, and Power BI Data Modelling.

You must be able to work under pressure, and have the ability to prioritise adhoc requests. The successful candidate will also be able to verify source data against Power BI dashboards for accuracy.

The key stakeholders for this role are the CRM Specialist, CRM Superusers (Admin, Sales and Paid Digital), and a Data Specialist. This role will form the bridge between the Data Specialist and Analytics Manager.

This is a hybrid role which requires 2 days per week at a London based office.

Main responsibilities

• Data reconciliation: understand, investigate and correct variances between source data (Salesforce / Data Warehouse) and output data (in excel or Power BI dashboards).
• Use DAX to extend the analytical capabilities of the data model behind the Power BI Dashboards.
• Create new and maintain existing excel extracts based on the Data Mart.
• Visual Analytics: Develop, enhance and optimise Power BI reports and datasets.
• Audit data on a regular basis to ensure data integrity and quality. Liaise with CRM Manager to investigate issues as they arise.
• Prepare excel reports based on Analytics Manager’s requests.
• Acquire data from primary or secondary data sources (marketing channels) and maintain databases/data systems.

Requirements

• A minimum of 5 years work experience in an equivalent Business Analyst role in an international environment.
• Expert knowledge of DAX and reporting tool Power BI.
• Knowledge of Salesforce is preferable.
• Power BI Data Modelling
• Power BI DAX Programming Language
• Power BI Advanced Data Visualisation skills
• An understanding of performance optimisation in Power BI
• ETL tool skills preferable.
• Ability to analyse, reconcile, model and interpret data.
• Understand requirements and efficiently make recommendations.
• A methodical and logical approach.
• Ability to plan work and meet deadlines.
• Accuracy and attention to detail.
• Interpersonal and Teamworking skills.
• An enthusiastic and ambitious attitude to data.
• Written and verbal communication skills / Fluent in English.

We are looking for a passionate and experienced Insight Analyst to join a Data and Strategy Team within a leading digital marketing agency with ambitious plans.  Their clients include global brands such as Disney and McDonald’s.

This is a critical role as you will be part of a team that focuses on providing high quality campaign reporting and analysis for clients. You will collaborate with Client Services and Strategy Teams to create and test campaigns, report on KPIs, and develop frameworks of how this is communicated to stakeholders.

You will have the opportunity to work in a hybrid environment with 3 days in the office in central Bristol and 2 days remote.

You will be joining a company that is committed to creating a diverse and inclusive environment and is proud to be an equal opportunity employer.

If you are passionate about data and analytics and are looking for an opportunity to make a difference, we would love to hear from you.

Main Responsibilities

Campaign Reporting

• Being the voice of analytics in the production and evaluation of CRM campaigns.
• Recommending appropriate control group methodologies.
• Producing efficient, easy to read code to export data into reporting tools.
• Scheduling reports using the appropriate software.
• Maintaining the highest standard of data quality through subject expertise and spot checks.
• Working with developers to automate ongoing reports.

Campaign Analysis

• A/B variant testing.
• Creation of insight packs for campaigns.
• Involved in the delivery of campaign analysis, from brief to presentation.
• Presenting results to stakeholders of all seniority, with leadership support.
• Constructing analytical briefs from face-to-face meetings and written questions.
• Overlaying a commercial lens to the results, what do the results mean for the business?
• Creating engaging content that distils the relevant insights in a concise manner.

Ad-Hoc

• Targeting for campaign selections.
• Actively seeking opportunities for the business to add value through analytics.
• Keeping afloat of the latest analytics and machine learning techniques.
• Playing a key role in implementing new technologies and analytical methods.

Requirements

• Commercially aware - demonstrate an understanding of how insight can impact the bottom line.
• Self-starter - can deliver a project from start to finish with appropriate support.
• Deadline driven – factors in what’s needed vs. the time available.
• Strong communicator - both written and verbal.
• Attention to detail – confident in the insight they’re presenting.
• Curiosity – always asking why.
• Flexible – able to respond at short notice if the client’s need changes.
• Enthusiasm - an interest in the latest analytical and machine learning techniques.

Skills

• Experience of data visualisation and all things reporting.
• Knowledge of control group/fallow cell methodologies.
• Experience of working with retail datasets.
• Direct marketing analytics experience.
• 2+ years’ SQL coding experience (MySQL or equivalent).
• 2+ years’ experience of reporting using one of Data Studio, Tableau, Power BI.
• R/python experience preferable but not essential.
• Previous agency background a plus.
• Segmentation experience a bonus

Benefits

• Hybrid environment – 3 days in our central Bristol office / 2 days remote.
• 25 days’ annual leave plus a day off on your birthday, increasing by 1 day per annum at each year anniversary up to 30 days, plus bank holidays.
• Summer and Christmas hours – finish 2.5 hours early one Friday per month in June, July, August and December.
• Contributory company pension 4% employee 3% employer of total pay through salary sacrifice, escalating 1% each year following your 2nd anniversary, up to 8% employer contribution.
• Bupa dental care.
• Vitality health insurance.
• Lots of social events, including summer and Christmas parties.
• Cycle to work scheme.
• Employee Assistance Programme offered by Assured Health.
• IPA Membership.
• Bristol Creative Industries Membership.

All qualified applicants will receive consideration for employment without regard to race, colour, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability or age.