About The Team:

The Lead Data Analyst role is a part of the Insight & Analytics Team.  This team sits within our Operations department & is part of the Data & Business Intelligence Tribe. The Lead Data Analyst will work with data from a wide range of IT platforms & teams from across operations & wider business teams within HelloFresh UK & Global HelloFresh teams.  This role will be expected to work with data throughout its whole life cycle from system creation through to data extraction & finally into market leading data visualisations for our operational end data consumers to use.

You will be an experienced information professional with well-developed technical skills born out of experience in analysing complex datasets & presenting information in an impactful manner. You will have experience working with Tableau (or similar data visualisation tool) & a range of other data tools (SQL, Presto, Snowflake, etc) & how to coordinate the delivery of high quality, timely & accurate information, presented in impactful ways. You will provide professional & expert support, helping to drive best practices in data standards, quality, input standards, ETL & data transformation for analytical consumption.

The Lead Data Analyst will also be expected to work with other team members to scope out requirements & designs, whilst then converting these into highly automated BI applications. The lead data analyst will be expected to have a high depth of knowledge of developing data visualisations & working with a range of scripting languages to extract data from data warehousing environments, such as Snowflake & SQL.

The Lead Data Analyst will be expected to work with a wide range of stakeholders, & also to be a key advisor to teams with technical & non-technical backgrounds, to help ensure data driven architectures are adopted across the business; whilst helping to promote a culture of data excellence, & data as an asset across HelloFresh UK.

Finally, the candidate for this role will be expected to work independently & lead on a wide range of data-based projects, in order to help assist the data product offerings across the business have a high degree of business impact.

What You Will Be Doing:

• Establish & provide data extraction processes from any IT systems used by HelloFresh to enable data for decision making analytics
• Build when required the optimal extraction, transformation, & loading of data from a wide variety of data sources using SQL, PostgreSQL, Snowflake, ODBC
• Identifying & supporting to alignment of systems & their data architecture to meet business insight requirements
• Independently problem solve data issues when reported by data consumers, & provide automated analytical solutions
• Promote data integrity by monitoring systems & working with system owners to ensure highest standards are achieved
• Developing specifications, developing & building automated analytical dashboards using market leading analytical software tools
• Developing analytical reporting products using Snowflake data warehouse
• Support Insight & Reporting Manager in developing & ensuring adoption of consistent data terminologies in both data structures & reporting outputs across the business 
• Identify, design, & implement internal process improvements: automating manual processes, optimising data delivery, re-designing infrastructure for greater scalability, etc.
• Build analytics tools that utilise the data pipeline to provide actionable insights into key operational processes & provide insight which can be reacted to in a high paced operational environment. operational efficiency & other key business performance metrics.
• Deliver high quality data insight applications in visualisation applications using Tableau
• Documenting data process tasks & providing advice on where automation is possible
• Provide consultancy & advice on creating & measuring SLAs / KPI for contracts across HelloFresh UK
• Build & develop effective SLA / KPI monitoring dashboards which are proactive in nature.
• Identify & lead on ways with other stakeholders to help develop processes which improve data reliability, efficiency & quality
• Work with global technology teams when developing / understanding data models required for analytical reporting solutions

Who You Are:

• Degree in Computer Science, Engineering, Statistics, Mathematics or related field / professional experience in a similar fast paced commercial environment.
• Qualification / Certification or proven experience in visualisation tools, preferably Tableau
• Experience with SQL databases
• Experience with data pipeline & workflow management tools
• Strong analytic skills related to working with structured & unstructured datasets.
• Experience of delivering highly automated solutions for reporting / insight applications, & driving quality in data inputs / capture methodologies.
• Build processes supporting data transformation, data structures, metadata, dependency & workload management.
• Experience of developing analytical solutions using a range of tools & data modelling / transformation techniques
• A successful history of manipulating, processing & extracting value from large disconnected datasets.
• Experience supporting & working with cross-functional teams in a dynamic environment.
• Experience working in an Agile environment & using tools such as Github / Jira - preferable 
• Experience of working with business stakeholders on data problems, translating expertise into data solutions.
• You have strong experience of defining & building reporting/insight products in complex business & data environments

What you will get in return:

70% off HelloFresh or Green Chef boxes
Company pension scheme
Gym membership
Bupa private medical insurance (including dental & family cover options)
Electric vehicle scheme
Bippit account - financial support
Free professional development & coaching memberships
Mental health first aiders & an employee assistance programme
Dog friendly office! (London site only)
If in the office, enjoy a free breakfast every day
Eye care scheme
Cycle to work scheme
Group Life Assurance

Location: The HelloFresh Farm, 60 Worship Street, EC2A 2EZ, London 

Work Schedule: Hybrid working - 50/50 remote working & flexible start/finish times (role
dependent)

Next steps: Your application will be reviewed & if successful, a member of the Talent Acquisition Team will be in touch within 2 weeks.

You are required to cooperate with HelloFresh in all health & safety matters. You are responsible for ensuring you take reasonable care of your own health, & safety as well as others who may be affected by the work activities you undertake. You must report incidents immediately & actively raise health & safety-related concerns to your Line Manager.

If you are currently a HelloFresh employee, please make sure you have discussed your application with your Line Manager.