MI Analyst E Commerce

£35,000 per annum

Leeds, West Yorkshire

Role - MI Analyst E Commerce

Location – Leeds, LS15 with Home working

Salary - £35,000 per annum 

About Us

Pharmacy2U is the UK's first and largest online pharmacy, we're a market leader in the pharmacy world, with 20 years’ experience, helping over 500,000 patients in England manage their NHS repeat prescriptions from request through to delivery. Our aim is to further disrupt the industry for the benefit of patients with leadership that is passionate about building the skills and expertise of our teams- “come and join the rocket ship”- CEO Mark Livingstone.

Role Purpose

Reporting suite is hosted across both Tableau & SSRS utilising the Enterprise Datawarehouse (EDW) which is feeding from several independent Pharmacy2U/Chemist Direct production databases and regularly utilising external third-party sources.

This role is best suited for a candidate looking to take ownership of the timely, accurate & relevant delivery of business reporting. Ability to follow through business transactional/operational journeys through dataflows with attention to detail crucial to identify areas of opportunity/concern.

Essence of Role – Key Accountabilities

Work alongside Head of Reporting in the development and maintenance of the Pharmacy2U (POD)/ChemistDirect (OTC) reporting suite.

- Assist with the creation of new MI reporting in both Tableau & SSRS.

- Collaborate with stake holders and colleagues to ensure reports are efficient and effective both technically and conceptually.

- Ensure accuracy and identify improvements in existing reports.

- Respond to ad-hoc data requests from colleagues and the Exec.

- Ensuring data integrity and GDPR compliance is applied to all analysis and reporting.

- Work alongside Head of BI in the continuous improvement of a rapidly expanding Enterprise Datawarehouse.

- Ensuring and validating accuracy in the existing EDW.

- Highlighting fields in the prod systems to be added to the EDW.

- Continuous improvement and expansion.

- Strive to provide the best insight we can into Pharmacy2U/ChemistDirect performance and outcomes in the smartest and most effective ways possible.

What we need from you

- Experience of Tableau or a similar visualiser

- SQL / T-SQL experience

- Experience using SSMS & SSRS.

- Considerable experience with MS Office, particularly Outlook and Excel.

- The ability to take full responsibility for a range of datasources, processes and stake holder delivery

- A keen eye for accuracy, a desire to deliver reliability and keep up with a highly motivated team

- Experience in an fast paced e-commerce environment

What are you waiting for? Apply today!

Hours – 40 hours a week full time. Mon to Fri 9:00am - 5:30pm

Applicants must be able to prove they have the Right to Work in the UK