Data Analytics Engineer
Hybrid
Leeds, United Kingdom
£ 50,000 / year
Freelance
01-04-2025
Job Specifications
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.
About the Company
The UK's largest digital pharmacy. Proudly partnered with the NHS and helping over 1.5 million patients take control of their healthcare. Know more
Related Jobs
- Company Name
- Expert Thinking
- Job Title
- Azure Data Platform Engineer
- Job Description
- Specialist Cloud consultancy Expert Thinking are hiring!!! There is an urgent position outside IR35 for an Azure Data Platform Engineer. If your answers to the following are yes, then this could be the ideal project for you… Are you an experienced Azure Data Engineer? Are you available for a new project in the next few weeks? Interested in contracts Outside IR35? Happy to work 100% remotely, anywhere in the UK? The focus of the role will be designing, engineering and supporting Azure Data platforms. This is a hands-on role, so extensive engineering, development and support experience is a must. To be considered, you must have a minimum of three years' experience working with Azure, and be able to demonstrate: Experience designing enterprise Azure Data Platforms (Azure Databricks, Synapse, ADLS, SQL etc) Hands-on platform engineering with a good knowledge of CLI tooling Excellent IaC skills - Specifically Terraform Excellent knowledge of DevOps philosophy, methods and principles to software delivery, knowledge of GIT tools and associated methodologies (GITFlow/GITHub) Expert Thinkings' mission is to be recognised as the BEST cloud consultancy in the UK & EU, not be size, but by capability. They are a remote-first team of cloud experts who build dynamic, powerful, cost-optimised Azure cloud solutions that deliver the agility, performance and scale needed by their customers to succeed. Demand for their services are growing, and they are growing their Data offering to their customers. If you’re a personable individual with flair, passion and strong technical capabilities, are passionate about helping their customers to drive value and realise the true benefits of the cloud, then we want to hear from you. Their people are their business - the key to their success, and that of their customers. Join them and be a part of something special. Please apply with your latest CV. Sound like you? Please apply today!
- Company Name
- TEKsystems
- Job Title
- Senior Data Architect Lead
- Job Description
- Senior Data Architect Lead Job Description We are currently seeking a Senior Data Architect to lead the creation of a comprehensive data strategy across both Front and Back Office operations. This role involves documenting and understanding the current data architecture, designing a future state, and developing a roadmap to achieve it. The strategy will encompass data governance, categorisation, tooling, and data platforms. The successful individual will have Transformation/Migration case studies and able to map out a future direction. History within Financial Services would be very advantageous - if this is you, we would be very keen to hear from you. Responsibilities Document and categorise the firm's enterprise data. Design and implement a data strategy, including governance frameworks. Develop an enterprise data platform. Mentor and guide the team with data architecture expertise. Contribute to the department's cloud strategy. Essential Skills Extensive experience as a data architect. Proven experience in migrating and building enterprise data platforms on AWS. Background in data development or engineering. Proficiency in SQL. Understanding of the full trade life cycle. Self-starter with a strong drive to complete initiatives. Excellent problem-solving skills and keen intelligence. Strong communication and teamwork abilities. Additional Skills & Qualifications Degree in Computer Science or similar. Experience with data management, AWS, Power BI, SQL Why Work Here? This is an exciting time to join as we expand our cloud footprint to meet current needs and position ourselves for future growth. Enjoy a balanced work schedule with three days in the office and two days working from home. Work Environment Our work environment offers a blend of office and remote work, with three days in the office and two days working from home. We are transitioning to a cloud-first model, with existing systems and services being migrated to AWS. Location London, UK Rate/Salary 130000.00 - 145000.00 GBP Yearly Trading as TEKsystems. Allegis Group Limited, Bracknell, RG12 1RT, United Kingdom. No. 2876353. Allegis Group Limited operates as an Employment Business and Employment Agency as set out in the Conduct of Employment Agencies and Employment Businesses Regulations 2003. TEKsystems is a company within the Allegis Group network of companies (collectively referred to as "Allegis Group"). Aerotek, Aston Carter, EASi, Talentis Solutions, TEKsystems, Stamford Consultants and The Stamford Group are Allegis Group brands. If you apply, your personal data will be processed as described in the Allegis Group Online Privacy Notice available at our website. To access our Online Privacy Notice, which explains what information we may collect, use, share, and store about you, and describes your rights and choices about this, please go our website. We are part of a global network of companies and as a result, the personal data you provide will be shared within Allegis Group and transferred and processed outside the UK, Switzerland and European Economic Area subject to the protections described in the Allegis Group Online Privacy Notice. We store personal data in the UK, EEA, Switzerland and the USA. If you would like to exercise your privacy rights, please visit the "Contacting Us" section of our Online Privacy Notice on our website for details on how to contact us. To protect your privacy and security, we may take steps to verify your identity, such as a password and user ID if there is an account associated with your request, or identifying information such as your address or date of birth, before proceeding with your request. commitments under the UK Data Protection Act, EU-U.S. Privacy Shield or the Swiss-U.S. Privacy Shield.
- Company Name
- Inspired Thinking Group (ITG)
- Job Title
- Graduate Data Administrator
- Job Description
- Our Digital Engineering team at Storyteq are responsible for building world class, enterprise grade digital applications for high profile brands. We pride ourselves in working with mature Agile methodologies and make use of the latest versions of technology. Our teams are structured in such a way that gives every employee the opportunity to learn new skills, work on various projects over time and see the results of your efforts in the online consumer marketplace. Joining the Digital Engineering function would see you work as part of a cross-functional, product style team, generally consisting of a Business Analyst, Scrum Master / Project Manager, Solution Architect, Lead Developers (FE and BE), Developers, and Testers (Manual and Automated). We have an excellent opportunity for an entry level Data Administrator to join our growing team of Data Modellers. This role is responsible for managing the data that sits behind complex web applications. Our team maintain data model spreadsheets that have been set up for our enterprise grade web-based solution in over 20 countries. The data models are regularly updated in line with the production updates. These changes can affect the product availability together with the options (along with any associated rules for these) that are available for each product range within a country. Additionally, the team are responsible for maintaining pricing within the data models. Ultimately, we're looking for highly motivated, focussed, and hardworking individuals who'll thrive in a fast-moving work environment. Someone who wants to be part of a team, with a desire to do well. We are also considering school leavers from 6th form or college ready to carve out a fulfilling career in Data Modelling. Work experience whether it be part of your studies or part time is essential to be able to progress in this role. Responsibilities: Liaising with third party agencies on data requests Setting up new data models Amending existing data models with new content Communicating with senior members of the team on data modelling issues Checking and amending data discrepancies Solving issues for clients and third-party agencies Full training will be provided for successful candidates Requirements Excellent working knowledge of Excel (which is used for the data modelling) IT literate, ability to pick up new software intuitively Excellent numeracy and literacy skills Ability to work under pressure and to tight deadlines Ability to assess large sets of information, solve problems and provide feedback Good attention to detail / high degree of accuracy Logical approach and good analytical skills Excellent communication skills, both verbal and written Benefits Work's a treat! On top of a competitive salary, you can expect a whole load of perks: 25 days' holiday + bank holidays - we understand the importance of you getting some down time. Annual Wellbeing Day - enjoy an additional day on us to look after your physical and mental wellbeing. Pension Scheme - helping you save towards your retirement home in the sun! Corporate Medical Cash Plan - claim back the cost of your medical treatments. Smart Working Options - spend up to 40% of your working week from home. So many savings - through our online community platform, you can access dozens of daily deals, from money off top brands to discounts on days out. Employee Assistance Programme - our people are at the heart of everything we do, so if you're happy, we're happy. Cycle to Work Scheme - save on the cost of biking to work. Monthly Employee Awards - Employee of the Month programme with £250 bonus Raising money for charity including a paid Volunteer Day - we're all about giving back... and having lots of fun in the process! Referral scheme - know the perfect person to join the team? You could bag £1,500 for a putting a good word in. Wellbeing Programme - giving you the opportunity to join regular, interactive Wellbeing Workshops or join our 30 plus Wellbeing Champions. Enhanced Family Friendly Leave - support for you and your family to help you navigate through the craziness of family life We Value Diversity We champion and welcome diversity in our workforce and ensure all job applicants receive equal and fair treatment, regardless of age, race, gender or gender identity, religion, sexual orientation, disability, or nationality. We are not only committed to increasing the visibility and recognition of talent from under-represented groups within our organisation, but the wider industry too. At the end of the day, we make sure we take time to look after ourselves, each other, and the planet, because we're always stronger together. ITG have a number of community groups (ERGs) available to employees which offer a safe space for like-minded colleagues, with shared interests to connect, socialise and check in with each other. These include Black ITGers Together, LGBTQ+ Together, Mens Health Together, Muslims Together, Neurodiversity Together, Working Parents and Carers Together and Women In Tech Together. What next? If you found yourself interested in knowing more, drop us your application and someone from our team will be in touch.
- Company Name
- Fruition IT
- Job Title
- BI Reporting Analyst
- Job Description
- Our client is looking for a skilled BI Reporting Analyst contractor for 2 months starting at the beginning of May. The role requires someone to define KPI's to inform dashboard content, then build dashboards that will present results for senior stakeholders. You will be working to a project plan that sits within wider implementation of a strategic measurement framework. The role: Act as the central point of co-ordination ensuring requirements are gathered and enacted Work with stakeholders to gather requirements and to give demonstrations of dashboards in order to gather feedback Advise on the usefulness of indicators and make recommendations on data collection vehicles Lead on building the reporting dashboard to monitor performance at different levels Gather requirements for a corporate dashboard to bring the strategic measurement framework to life Present dashboards clearly to technical and non-technical audiences and prepare documentation to support their use and eventual handover Skills, Experience and Qualifications needed: Advanced Power BI and Excel skills, with a portfolio of dashboards and insight reporting Strong ability to gather, synthesise, analyse and report data Effective communicator with experience collaborating across internal teams and with government or funding stakeholders Flexibility, drive and initiative to meet deadlines in a highly transitional environment, keep work on track and respond to stakeholder needs A good understanding of impact and outcomes and measurement Experience working in or with the health care sector is desirable Contract Details: 2-month contract £300-340 per day - Outside IR35 Fully Remote (must be UK based) Start date of beginning of May 2025 Please get in touch with your latest CV, to apply and discuss the role. Interviews on w/c 21st April, with Contract start at the beginning of May. We are an equal opportunities employer and welcome applications from all suitably qualified persons regardless of their race, sex, disability, religion/belief, sexual orientation or age.