Leeds - Data Analytics Engineer

Working hours: 40hrs per week, Monday to Friday

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.

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

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