What you'll be doing
The POWER to SOLVE at Avon!
Become a subject matter expert within Avon for the amazing technology stack on offer, lead the way in championing how we should be using this technology and share best practice across the business, through leading a community of analysts.
You will naturally drive efficiencies by example, through use of skills, technology and knowledge.
Responsible for delivering the foundation of data for the UK through gathering and understanding the business requirements, documenting and delivering them within the current platform, using tools like Snowflake and Alteryx.
Advanced SQL coding must be your passion or your strength and you must be comfortable with delivering in an agile way.
Working with the Analytical Innovation Manager to champion data across the UK business and globally. Develop a deep understanding of Avon’s key performance indicators and their business rules to be able to deliver sound data sources for the analytics team and wider audience.
Understand data governance and GDPR and therefore work with data safely and securely, enabling best practice within the team.
Working closely with the Data Innovation team to identify and deliver robust data solutions maximising the available technology in house.
Act as a mentor for data engineers supporting their development and your own.
The development of tools, ad-hoc data queries to support the team in obtaining the information that they need in a timely manner.
As well as the development of proof of concepts (POC) to support the local Avon teams. With future possibilities of taking local POC’s and delivering them to the global team for delivery for the wider global business.
We'd love you to have :
The successful candidate with be someone who is a degree level graduate with at least 3 years’ experience or have at least 5 years commercial experience within the field of data engineering using SQL.
It is also essential that you have Alteryx Core Certification. Desirable that you have Alteryx Advanced Certification, as well as experience with Agile working practises and exposure to Tableau and ThoughtSpot.
They must be able to take the lead in data governance and support with the defined definitions across the business teams and global data teams ensuring that all are aware and have easy access to definitions to look up.
They will need to be confident to lead projects from its conception to delivery whilst ensuring data integrity, delivering to many different lines of management horizontally as well as vertically.
It is essential the candidate has experience in SQL Server Management Studio or Snowflake (or similar), Alteryx and working with SharePoint & Teams.
Experience with SQL must be with creating new data products from multiple sources using advanced SQL knowledge, such as sequences, partitions, CDE, Windows, etc.
They will be a natural born problem solver with a desire to help others succeed using your curiosity to solve at the root of the problem and not the branches.
They will believe in the philosophy of the team of learn one, do one and teach one which will lead to championing data within Avon.
What we offer :
Avon is proud to be an equal opportunities employer. Our priority is finding the best people for the job, regardless of sex, race, disability, sexual orientation, beliefs, religion, whether you're about to have a baby or are planning to have one.
We're all about our people, and that's why we think we're one of the best companies to work for in the world!