Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join our team as a Reporting Analyst, creating impactful reports and dashboards using SQL and visualisation tools.
- Company: BSS is the UK's leading distributor of pipeline and heating solutions, with over 110 years of experience.
- Benefits: Enjoy remote work flexibility, competitive bonuses, a pension scheme, life assurance, and exclusive colleague discounts.
- Why this job: Be part of an innovative company undergoing exciting changes, where your insights drive real business impact.
- Qualifications: 2+ years of SQL experience, report building skills, and proficiency in visualisation tools like Tableau or Looker.
- Other info: We value inclusivity and encourage all candidates to apply, even if their experience doesn't perfectly match.
The predicted salary is between 28800 - 43200 £ per year.
Social network you want to login/join with:
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
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.
#J-18808-Ljbffr
Reporting Analyst employer: BSS
Contact Detail:
BSS Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Reporting Analyst
✨Tip Number 1
Familiarise yourself with Google Big Query and Looker Studio, as these are key tools for the Reporting Analyst role. Consider taking online courses or tutorials to enhance your skills in these platforms, which will demonstrate your commitment and readiness for the position.
✨Tip Number 2
Network with current or former employees of StudySmarter or similar companies. Engaging with them on professional platforms like LinkedIn can provide you with insights into the company culture and expectations, which can be invaluable during interviews.
✨Tip Number 3
Prepare to discuss specific examples of how you've used SQL and visualisation tools to solve problems or improve reporting processes in your previous roles. This will showcase your practical experience and problem-solving skills, which are crucial for this position.
✨Tip Number 4
Stay updated on industry trends related to data analytics and reporting. Being knowledgeable about the latest developments can help you engage in meaningful conversations during interviews and show that you're proactive about your professional growth.
We think you need these skills to ace Reporting Analyst
Some tips for your application 🫡
Understand the Role: Read the job description thoroughly to grasp the key responsibilities and required skills for the Reporting Analyst position. This will help you tailor your application to highlight relevant experiences.
Highlight Relevant Experience: Make sure to emphasise your experience with SQL, Google Big Query, and any visualisation tools you've used. Provide specific examples of reports or dashboards you've created that align with the role's requirements.
Showcase Problem-Solving Skills: In your application, include instances where you've successfully solved complex problems or improved reporting processes. This will demonstrate your analytical capabilities and attention to detail.
Craft a Strong Cover Letter: Write a compelling cover letter that connects your skills and experiences to the job. Mention your enthusiasm for working in a fast-paced environment and your ability to communicate complex information clearly.
How to prepare for a job interview at BSS
✨Brush Up on SQL Skills
Since the role requires 2+ years of experience using SQL, make sure to review complex statements and scripts. Be prepared to discuss specific examples of how you've used SQL in past projects, especially in relation to reporting and data extraction.
✨Familiarise Yourself with Reporting Tools
The job mentions tools like Google Big Query, Looker Studio, and other visualisation tools. If you have experience with these, be ready to showcase your work. If not, consider doing a quick tutorial or two to understand their functionalities and how they can be applied in reporting.
✨Understand the Business Context
The role involves working closely with various departments such as Supply Chain, Finance, and Sales. Research these areas and think about how data reporting can impact their operations. This will help you demonstrate your understanding of the business needs during the interview.
✨Prepare for Problem-Solving Questions
Given the emphasis on problem-solving skills, be ready to discuss challenges you've faced in previous roles and how you resolved them. Use the STAR method (Situation, Task, Action, Result) to structure your answers clearly and effectively.
