Role: Data Analytics Engineer Location: Leeds, LS15 (with hybrid working after completion of training) Salary: £40 - £50k 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. INDTECH