Data Analyst

We are William Reed.

We are the leading expert in the global Food & Drink industry.

We have offices in Gatwick and London, UK; Montpellier, France; Singapore and Chicago, US. In line with the Company’s current Agile Working Policy, the successful candidate would be eligible to work part of the week from our London office and to work remotely for the rest of the week.

Lumina Intelligence is one of the leading consultancies in the food and drinks industry. We provide expert consultancy through data and insight, powered by analytical thinking, outstanding expertise, and insights technology. We work with a broad range of clients emerging brands and operators and some of the most renowned businesses. We are part of a global media group, William Reed, who have been leaders in the food and drink sector for over 150 years

Location: London / Hybrid - office based 2 days a week (Tuesday & Thursday).

The Data Team is responsible for collecting all the primary and secondary data required for Lumina’s products and making it accessible internally and to clients. As part of the Data Management Team, reporting to the head of data, the Data Analyst will restructure raw data from our data collection into a format that fits our databases.

What you'll be doing as a Data Analyst:

Key Responsibilities

• Restructure and maintain data into a database-friendly multi-table format for all our product trackers and bespoke research.
• Implement systems to help the optimisation of data efficiency and data quality.
• Acquire data from primary or secondary data sources to enrich our internal data.
• Assist in the identification, design, development, and maintenance of new and existing data tools and applications.
• Troubleshooting our databases and BI tools to ensure minimal client disruption.
• Set up and maintenance of automated data processes.
• Track KPIs of our systems and processes

What you'll need:

• Proficient numeracy skills
• Excellent coding skills (preferably Python) and a passion for learning new languages and technologies.
• A demonstrable understanding of relational databases (Microsoft SQL Server).
• Advanced knowledge in Excel data handling and modelling.
• Analytical and problem-solving skills to spot trends, errors and highlight / rectify.
• Understanding of the process of acquiring, cleansing, and transforming data.
• Good organisational skills.
• The ability to meet deadlines and communicate progress.
• Flexibility to adapt to evolving priorities.
• A self-starting and motivated attitude with the ability to work in an autonomous fast paced environment.
• Experience working with survey data and data visualisation and reporting tools.
• Prior commercial experience, working with consumer data in a data analytics role.
• Web analytics and behavioural tracking (i.e., Google Analytics)

Company benefits include

• A competitive salary
• 25 days annual leave in addition to bank holidays- increasing by one additional day after 6 years, up to a maximum of 30 days.
• An additional day of leave for you to take on a cultural celebration day or on your birthday if you like. A day for you! At William Reed, we call this our “MeDay”.
• A volunteer day to take for supporting a chosen charity and giving back to the community.
• Opportunity for hybrid working
• Contributory Pension
• Life Assurance Scheme
• Group Income Protection
• Enhanced family-friendly leave pay entitlements
• Wellbeing benefits, including: A health care cash plan, Employee assistance programme and a 12-month wellness calendar for company-wide health, wellbeing, diversity & inclusion awareness dates.
• Cycle to Work Scheme
• Electric Car Scheme

We provide a supportive work environment and are committed to maintaining a healthy work/life balance for all of our employees. Working for William Reed means that you will be joining a stable organisation that is committed to developing its employees and brands.

We warmly welcome and encourage applications from talented individuals of all backgrounds and characteristics. If you need any support in accessing this opportunity, please do not hesitate to discuss this with us.