Who we areInternational 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.About the roleThe Management Information CoE sits with the International Data Office and are responsible for all Boots regular reporting, from daily updates to supporting financial month-end. We are currently in a period of change as we move these reports to use Azure and Power BI.The MI team sits in quite a unique position as we work with data from across the entire business, so attention to detail and the ability to manage multiple tasks are key.As an Analytics Engineer within this team, you will be responsible for maintaining and modelling the data that underpins these 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 Power BI.You will also work with other parts of the business to understand and unlock the full potential of Boots' data.What you'll need to have
- Experience using Power BI to model data, whilst also being willing and capable of adapting to new tools as they're introduced.
- Be proficient at writing SQL
- Knowledge of data relationship 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 other related tools such as ADF, ADO, Git and Powershell
- Experience using DataBricks and/or Python.
- Advanced knowledge of Microsoft Excel and VBA
- Knowledge of Power BI External tools like Tabular Editor, Dax Studio, etc
- Experience using SAP BW
Our benefits
- 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 holiday buying, discounted gym membership, life assurance, activity passes and more.
- Access to free, 24/7 counselling and support through TELUS Health, our Employee Assistance Programme.
We have a great range of benefits in addition to the above that offer flexibility to suit you - find out more at rewards. Please note, any salary estimates given on third-party sites are not provided or endorsed by WBA and may not be accurate.What's nextIf your application is successful, our recruitment team will be in touch to arrange an interview and to answer any initial questions you have. If you have not been successful on this occasion, you will be notified by email.Where a role is advertised as full-time, we are open to discussing part-time and job share options during the application process. If you require additional support as part of the application and interview process, we are happy to provide reasonable adjustments to help you to be at your best.