Data Analytics Engineer

Pharmacy2U; Leeds; Hybrid; GBP 40,000 - 50,000; Full time

Job description

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?

1. Occupational sick pay
2. Enhanced maternity and paternity pay
3. Contributory pension
4. Discounted insurance (Aviva)
5. Employee discount site
6. Discounted gyms (via our blue light card and benefits schemes)
7. Employee assistance programme
8. In-house mental health support
9. Free onsite parking
10. Health and wellbeing initiatives
11. Social events throughout the year
12. Cycle to work scheme
13. Green car scheme*(subject to minimum earnings)
14. Registration fees paid (GPhC, NMC, CIPD etc)
15. Long service bonus
16. Refer a friend bonus
17. Blue light card
18. Hybrid working
19. Commitment to CPD/training
20. 25 days annual leave increasing with service
21. Annual leave buy and sell scheme
22. Discounts & Exclusive offers at The Springs, Leeds
23. 25% Discount & health & beauty purchases
24. 25% Discount on Pharmacy2U Private Online Doctor Services

What you'll be doing?

1. Ensuring and validating the accuracy of the EDW, improving data quality and query performance
2. Exploring and understanding fields within production systems to integrate new data into the EDW
3. Maintaining seamless execution of ETL and other routines, enhancing performance and reliability.
4. Eliminating reliance on legacy systems by modernising and improving data solutions
5. Partnering with the Head of BI to develop and maintain reporting suite
6. Collaborating with MI/BI analysts to identify and establish reliable, accurate data sources that meet stakeholder requirements
7. Ensuring reports are technically and conceptually efficient, accurate, and impactful
8. Playing a key role in designing and building a new version of the Data Warehouse from the ground up
9. Identifying opportunities to enhance the EDW technically and conceptually
10. Driving efforts to deliver smart, effective insights into P2U's performance and outcomes

Who are we looking for?

1. Proven ability as a BI Developer/Data Analytics Engineer
2. Extensive experience of SQL/T-SQL and using SSMS, SSIS and Server Agent
3. Familiarity with Visual Studio's BI stack and ETL process, Kimball Dimensional Modelling Techniques and BI modelling guidance
4. Experience with Python, Data Lakehouse Architecture, MS office - particularly Outlook and Excel
5. Experience of working within company and ethical rules and regulations in a fast-paced environment and still delivering accurate work
6. Able to take full responsibility for a range of data sources, processes and stakeholder delivery with a keen eye for details
7. 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.