Reporting Analyst

Reporting Analyst

The role reports to the Head of BI, and will work closely with them and other members of the team to produce high quality reporting and data extracts, using Google Big Query, Looker Studio and Looker, along with the Google Suite of software.  

The role will mostly involve remote working, but there will be a requirement to be in the Magna Park office 3-4 times a month. 

Principal Accountabilities 

• Use SQL combined with the appropriate visualisation tool to deliver reporting to the wider business e.g. KPIs, reports, dashboards, scorecards, visualisations and other analytics 

• Work alongside the Head of BI to understand the reporting requirements of the Supply Chain, Finance, Commercial, and Sales teams 

• Design high-quality output that can be deployed across multiple business departments  

• Influence internal and external stakeholders to design and adopt processes that elevate data integrity and facilitate self-help analytics and proper data governance. 

• Build systems/processes to transform raw data into commercially relevant outputs that enable the business to create actionable insights 

• Understand the underlying data and assess its quality and usability for any particular visualisation 

• Improve and enhance existing reporting and analysis 

• Assess data integrity of reporting and within other analytical products, and work with appropriate departments to diagnose and resolve problems 

• Monitor existing ETL processes to ensure continuity in reporting across various business departments

What you’ll need to have/be:

• 2+ years experience using SQL. Comfortable writing complex statements and scripts. Experience of Google Big Query is a plus. 

• 1+ years of experience building reports and dashboards. 

• Experience of creating reports and dashboards using a visualisation tool e.g. Tableau, Looker, Data Studio, Power BI etc. 

• Ability to design and develop reports and dashboards using a variety of tools  

• Strong problem solving and logical thinking skills 

• Advanced Excel/Google Sheets 

• Excellent communication skills. Ability to communicate complex information clearly and concisely. 

• Problem solving aptitude, attention to detail and strong organisational capability  

• Ability to function in a fast paced, innovative organisation

What’s in it for you?

Not Sure you Qualify? We’re driving to become a truly inclusive employer, where everyone in our Group feels safe, welcome and confident to be their authentic selves - you be you, it makes us, us, as we say. If you’re interested in this opportunity but your past experience doesn’t align perfectly, we encourage you to apply anyway. You might be just the right candidate for this or other roles with us.

You’ll be supported by some fantastic training and development and have the opportunity to learn, grow and develop across the Travis Perkins Group. 

We’ll also equip you with a benefits package that grows as you grow with the company:

• Competitive bonus

• Save-as-you-earn scheme

• Buy-as-you-earn scheme

• Contributory pension scheme

• Life assurance

• Colleague discount across a variety of Group businesses

A bit about us

As the largest, leading distributor of pipeline and heating solutions in the UK, BSS serves a wide range of sectors and trades. They provide bespoke solutions to customers including products, specifications, technical support and aftersales care. 

BSS has a rich history of over 110 years nationwide providing essentially 'everything behind the wall' when it comes to plumbing. They have recently been acquired by Travis Perkins and are therefore going through an exciting time of new investment, structure and collaboration.