Data Analytics Engineer

Pharmacy2U Ltd

Pharmacy2U Ltd, the leading online pharmacy in the UK, has a rich 25-year history in helping millions manage their NHS prescriptions. They value employee experience, aiming to be a global leader in patient-centric digital healthcare. The Data Analytics Engineer will be crucial in progressing their EDW, leveraging complex data environments, and driving insightful business decisions.

In this role you can expect to have the responsibilities:

• Ensure the accuracy and quality of the Enterprise Data Warehouse (EDW).
• Integrate new data fields from production systems into the EDW.
• Maintain ETL routines for optimal performance and reliability.
• Modernize data solutions by reducing reliance on legacy systems.
• Collaborate with the Head of BI to develop the reporting suite.
• Identify efficient and accurate data sources with MI/BI analysts.
• Contribute to the design and construction of a new Data Warehouse.
• Drive improvements in technical and conceptual aspects of the EDW.
• Deliver effective insights into business performance and outcomes.

This role comes with the following benefits:

• Occupational sick pay
• Enhanced maternity and paternity pay
• Contributory pension
• Discounted insurance (Aviva)
• Employee discount site
• Discounted gym memberships
• Employee assistance programme
• In-house mental health support
• Free onsite parking
• Health and wellbeing initiatives
• Social events throughout the year
• Cycle to work scheme
• Green car scheme
• Registration fees paid
• Long service bonus
• Refer a friend bonus
• Blue light card
• Commitment to CPD/training
• 25 days annual leave increasing with service
• Annual leave buy and sell scheme
• Discounts & Exclusive offers at The Springs, Leeds
• 25% Discount on health & beauty purchases
• 25% Discount on Pharmacy2U Private Online Doctor Services

This role requires you to have:

• Proven experience as a BI Developer or Data Analytics Engineer.
• Strong proficiency in SQL/T-SQL, SSMS, SSIS, and Server Agent.
• Familiarity with Visual Studio’s BI stack and ETL processes.
• Knowledge of Kimball Dimensional Modelling Techniques and BI modelling guidance.
• Experience with Python and Data Lakehouse Architecture.

You would benefit from having:

• Proficiency in Microsoft Office, especially Outlook and Excel.
• Ability to deliver accurate work in a fast-paced environment.
• Responsibility for data sources, processes, and stakeholder delivery.

Successful applicants must have the right to live in the UK and will need to pass a DBS check. Unsolicited agency applications are not accepted.