Data Analytics Engineer
Description For Data Analytics Engineer
Pharmacy2U, the UK's largest online pharmacy, is seeking a Data Analytics Engineer to join their innovative team. With 25 years of experience and serving over 1.4 million patients, this Great Place to Work certified company offers an exciting opportunity to shape the future of digital healthcare.
The role focuses on designing, maintaining, and enhancing a bespoke Enterprise Data Warehouse (EDW) hosted on MS Azure SQL Server. You'll work with cutting-edge technologies including SSRS and Tableau, integrating data from multiple systems and external sources. The position offers a perfect blend of technical challenges and business impact, as you'll be instrumental in advancing data utilization and improving reporting capabilities.
Working in a hybrid model from Leeds, you'll join a highly motivated team dedicated to maintaining data accuracy and driving business insights. The role offers competitive compensation (£40,000-£50,000) and an extensive benefits package including healthcare, pension, and various lifestyle perks.
This is an ideal opportunity for a mid-level engineer with strong SQL/T-SQL experience and Python skills, who wants to make a meaningful impact in healthcare technology. The company's commitment to employee development, work-life balance, and positive culture makes it an attractive destination for talented data professionals looking to advance their careers in a purpose-driven organization.
Responsibilities For Data Analytics Engineer
- Ensure and validate the accuracy of the Enterprise Data Warehouse (EDW)
- Explore and understand fields within production systems to integrate new data
- Maintain seamless execution of ETL and other routines
- Eliminate reliance on legacy systems by modernizing data solutions
- Partner with Head of BI to develop and maintain reporting suite
- Collaborate with MI/BI analysts to identify reliable data sources
- Design and build a new version of the Data Warehouse
- Drive efforts to deliver insights into P2U's performance
Requirements For Data Analytics Engineer
- 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
- Experience with Python, Data Lakehouse Architecture, MS office
- Experience working within company and ethical rules in fast-paced environment
- Ability to take responsibility for data sources and processes
- Must have right to live in the UK
- DBS check required
Benefits For Data Analytics Engineer
- Occupational sick pay
- Enhanced maternity and paternity pay
- Contributory pension
- Discounted insurance (Aviva)
- Employee discount site
- Discounted gyms
- 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
- 25 days annual leave increasing with service
- Annual leave buy and sell scheme
- 25% Discount on health & beauty purchases
- 25% Discount on Private Online Doctor Services
Jobs Related To Pharmacy2U Data Analytics Engineer
