Analytics Engineer

International Technology & Advanced Analytics (IT2A) is a multi-national function of Walgreens Boots Alliance (WBA) based in the UK, Europe, Asia, South America and the USA. We use emerging technology and robust data to transform our pharmacy and retail offerings, improve experiences for customers and patients and enhance our operational effectiveness. Partnering with some of the finest tech providers and utilising a cutting-edge tech stack, we support two of the UK's most trusted and established brands - Boots and No7. We're a team of specialists spanning security, hosting, architecture, software engineering, networks, project delivery and more. A proud equal opportunity employer, we passionately embrace team member diversity and provide a positive and inclusive working environment for all.

Data and Business Intelligence is within Boots IT and is responsible for the enterprise Data Platform and Business Intelligence Reports. We are currently moving these reports to use Azure, Databricks and Power BI., As an Analytics Engineer you will report to the Analytics Engineering Manager. You will be responsible for maintaining and modelling the data that underpins our reports, proving it's accuracy, and working with our report developers to make sure that it's fit for purpose, while also maintaining aspects of our legacy data systems until we have completely moved to Databricks and Power BI. Our reports have thousands of daily users and so maintaining efficient performance is key.

You will also work with other parts of the business to understand and unlock the full potential of Boots' data.

Do you have experience in VBA?, * 'Hands on' experience of data engineering within an analytics or BI / MI environment.

• Experience using Power BI to model data.
• Experience using Databricks.
• Be proficient at writing SQL
• Knowledge of data modelling concepts such as star schema
• Excellent communication, interpersonal and influencing skills with the ability to deal effectively and confidently with individuals at all levels of the business and across functional boundaries.
• Strong attention to detail
• The ability to adapt to changing priorities as requirements evolve.

It would be great if you also have:

• Experience of Python.
• Experience of other related tools such as ADF, ADO, Git and Powershell.
• Advanced knowledge of Microsoft Excel and VBA.
• Knowledge of Power BI External tools like Tabular Editor, Dax Studio, etc.
• Experience using SAP BW.
• Experience of Agile methodologies.

• Boots Retirement Savings Plan
• Discretionary annual bonus
• Generous employee discounts
• Enhanced maternity/paternity/adoption leave pay and gift card for anyone expecting or adopting a child
• Flexible benefits scheme including option to buy additional holiday, discounted gym membership, life assurance, activity passes and much more.
• Access to free, 24/7 counselling and support through TELUS Health, our Employee Assistance Programme.

There's lots more in our benefits and discounts, MyBoosts - there to give you that little lift in your everyday. Find out more at boots.jobs/rewards. Exclusions may apply; eligible roles only. Please note that any salary estimates provided on third-party sites are not endorsed by Boots and may not be accurate.

At Boots, we're proud to be an equal opportunity employer, creating a place where everyone feels welcome, supported and free to be themselves. We believe that when our people feel valued and included, they thrive, so we're committed to creating a brilliant Boots for our people so they can make a difference for our customers and colleagues every time.