Role:                                    Data Analytics Engineer

Location:                             Leeds, LS15 (with hybrid working after completion of training)

Salary:                                 £40 - £50k per annum plus extensive benefits

Contract type:                    Permanent

Employment type:             Full time

Working hours:                   40hrs per week, Monday to Friday

Do you want to work for the nation’s largest online pharmacy ensuring excellence for all our patients? We’re a market leader in the pharmacy world, with 25 years’ experience, helping over 1.4 million patients in England manage their NHS prescriptions from request through to delivery.  We are Great Place to Work certified as we consider colleague experience a top priority every day.  Our people are fundamental to our success and ensuring we achieve our vision to be a world leading, patient-centric digital healthcare provider.  We are committed to continuing to develop a positive, open and honest working environment for all.

This is a dynamic and challenging opportunity to join a highly focused team dedicated to designing, maintaining, and enhancing a bespoke Enterprise Data Warehouse (EDW) hosted on MS Azure SQL Server. You will collaborate closely with a team leveraging a robust reporting suite across SSRS and Tableau, integrating data from multiple independent systems and external third-party sources.

P2U’s data ecosystem is complex and constantly evolving, making the EDW a critical and increasingly relied-upon resource for the business. As a Data Analytics Engineer, you will play a pivotal role in advancing data utilisation, improving reporting capabilities, and enhancing data accessibility to drive informed decision-making and business success.

What’s in it for you?

Occupational sick pay                      

Enhanced maternity and paternity pay                        

Contributory pension 

Discounted insurance (Aviva)          

Employee discount site                                                  

Discounted gyms (via our blue light card and benefits schemes)

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*(subject to minimum earnings)                   

Registration fees paid (GPhC, NMC, CIPD etc)             

Long service bonus 

Refer a friend bonus                        

Blue light card                                                                 

Hybrid working

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 & health & beauty purchases 

25% Discount on Pharmacy2U Private Online Doctor Services

What you’ll be doing?

Ensuring and validating the accuracy of the EDW, improving data quality and query performance

Exploring and understanding fields within production systems to integrate new data into the EDW

Maintaining seamless execution of ETL and other routines, enhancing performance and reliability.

Eliminating reliance on legacy systems by modernising and improving data solutions
Partnering with the Head of BI to develop and maintain reporting suite

Collaborating with MI/BI analysts to identify and establish reliable, accurate data sources that meet stakeholder requirements

Ensuring reports are technically and conceptually efficient, accurate, and impactful
Playing a key role in designing and building a new version of the Data Warehouse from the ground up

Identifying opportunities to enhance the EDW technically and conceptually

Driving efforts to deliver smart, effective insights into P2U’s performance and outcomes

Who are we looking for?

Proven ability as a BI Developer/Data Analytics Engineer

Extensive experience of SQL/T-SQL and using SSMS, SSIS and Server Agent

Familiarity with Visual Studio’s BI stack and ETL process, Kimball Dimensional Modelling Techniques and BI modelling guidance

Experience with Python, Data Lakehouse Architecture, MS office – particularly Outlook and Excel

Experience of working within company and ethical rules and regulations in a fast-paced environment and still delivering accurate work

Able to take full responsibility for a range of data sources, processes and stakeholder delivery with a keen eye for details

Reliable and able to keep up with a highly motivated team

What happens next?

Please click apply and if we think you are a good match, we will be in touch to arrange an interview.

Applicants must prove they have the right to live in the UK.

All successful applicants will be required to undergo a DBS check.

Unsolicited agency applications will be treated as a gift.