Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and develop business intelligence solutions for a leading pet insurance company.
- Company: Join Pinnacle Pet UK, where pets and their parents are at the heart of our mission.
- Benefits: Enjoy a hybrid work environment, competitive salary, and opportunities for personal growth.
- Why this job: Make a real impact on pet parents' lives while working with innovative BI technologies.
- Qualifications: Strong SQL Server skills and experience in data analysis required.
- Other info: Be part of a diverse team that values authenticity and collaboration.
The predicted salary is between 36000 - 60000 £ per year.
Our Mission
Happy, healthy pets, make for happy, healthy people.
We aim to strengthen the unique bond between pets and their parents through our innovative products and services, enabled by brilliant colleagues who embody our values of performance, exploration, togetherness, and sustainability.
Our Journey
In 2016 we set out to focus entirely on pet insurance with pets and families at the centre of our business strategy and in 2017 launched a new brand, EveryPaw.
To offer our customers a choice of insurance options for their pets, we also focussed on finding the right partners to support our growth ambition and our first big partnerships with Sainsbury and Argos, went live in 2019.
Many talented colleagues have joined us, and we now partner with a number of fantastic brands across the retail, charity and financial services sectors. We’ve developed new capabilities, new platforms and new services specifically for our partners to achieve the best customer experience. Over the last 6 years, the number of pet parents we support has grown five-fold to over half a million in 2023. Together we’ve built the leading Pet Partnership business in the UK and are proud to support and engage pet parents every day to ensure happy and healthy pets.
Our ambition
We’re delivering long-term success and growth through empowerment and strong collaboration focusing on our two own brands; EveryPaw and Pet Protect and building great relationships with our partners to provide market leading products, innovative new services, simplicity and a great customer experience. Our goal is to support over 1 million pet parents by the end of 2026.
Pinnacle Pet UK provides great opportunities for those who love pets, want to learn, be challenged and develop. As a team, we are focused on performance and great customer outcomes. We support each other to achieve our individual and collective goals and have a culture where everyone can be authentic, diverse and innovative and truly be the best version of themselves supporting what we do best – pets.
Job Summary
Job Summary
The core responsibilities of this role are the design, development, and maintenance of Pinnacle Pet UK’s business intelligence solutions. This involves the maintenance and new development for the existing data warehouse from source to the presentation layer using the Microsoft stack (SQL Server 2022, Visual Studio, SSIS, and Power BI Server), enriching current data models, and leveraging new BI capabilities in the cloud (Azure) in the future.
This will involve helping stakeholders develop business requirements, along with solution and data design and build. The position is very much a hybrid role – the ability to accurately gather and document requirements is as important as the ability to design and build solutions. Also key is the ability to quickly and efficiently analyse data to identify the root cause of issues.
In this role you will be working with the BI team ensuring all service standards are met and data is structured and handled in line with company data governance guidelines.
Key Responsibilities
Key Responsibilities
Key Responsibilities
Business
- At ease liaising with business areas, project managers and IT functions while supporting new business requirements, working both within project teams and directly with end-users.
- Ability to capture requirements accurately and provide documentation and continual support as requirements are refined.
- Working in collaboration with our partner companies on their data and DWH processes, and support ETL design and implementation.
- Proactively resolve and manage incidents and issues, working with other teams, ensuring that an optimal solution is reached.
- Use own experience to mentor other team members in BI technologies and methodologies.
- To act to deliver good outcomes for customers whilst delivering a higher standard of customer care andenabling consumers to make effective decisions in their interests.
Technical
- At ease liaising with business areas, project managers and IT functions while supporting new business requirements, working both within project teams and directly with end-users.
- Contribute to the design of the Data Warehouse and gain a deep understanding of the structure of source data.
- Always ensure coding complies with company standards and industry best practices in terms of the accuracy, efficiency and robustness of code solutions.
- Ensure existing ETL and reporting is continually optimised as new partnerships are formed.
- Experience using Git as a source control tool.
Process
- At ease liaising with business areas, project managers and IT functions while supporting new business requirements, working both within project teams and directly with end-users.
- High level of proficiency in identifying the root-cause of issues by using targeted data analysis problem-solving skills.
- Able to provide clear documentation for new procedures/processes developed.
Successful Candidates Will Have
Required Skills and Work Experience
Essential
- Strong experience in SQL Server analyst/developer roles.
- Very good T-SQL stored procedure knowledge.
- Very good knowledge of Microsoft SQL Server Integration Services (SSIS).
- Good understanding of data warehousing concepts including dimensional modelling.
- Experience in business analysis / requirements gathering, and turning the gathered requirements into data solutions.
- Experience in analysing data to find problem root causes, and data analysis that informs.
- Proven ability to communicate clearly, accurately, and succinctly, at all levels, both verbally and in written form.
- Attention to detail.
- Proven ability to problem solve independently.
- Ability to work under pressure.
- Self-motivated.
- Flexible.
- Good organisation skills.
Strongly Preferred
- Retail Insurance Industry experience.
Desirable
- Microsoft Azure experience.
- Experience with Microsoft Power BI (preferably Power BI Server).
Required Qualifications
- Microsoft Azure experience.
Essential
- GCSE Maths and English at grade C or above (or equivalent).
Desirable
- IT Degree or similar.
Any other additional requirements
- Willing and able to work outside normal office hours in exceptional circumstances.
#J-18808-Ljbffr
BI Developer employer: Pinnacle Pet Group
Contact Detail:
Pinnacle Pet Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land BI Developer
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your BI projects, especially those using SQL Server, SSIS, or Power BI. This gives you a chance to demonstrate your expertise and makes you stand out from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on your problem-solving skills. Be ready to discuss how you've tackled data issues in the past and how you can contribute to the team’s success at Pinnacle Pet UK.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining our mission to support happy, healthy pets.
We think you need these skills to ace BI Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the BI Developer role. Highlight your SQL Server experience and any relevant projects you've worked on. We want to see how your skills align with our mission of supporting happy, healthy pets!
Showcase Your Problem-Solving Skills: In your application, don’t just list your skills; give examples of how you've used them to solve real problems. We love candidates who can demonstrate their analytical abilities and how they’ve tackled challenges in past roles.
Be Clear and Concise: When writing your cover letter or any application materials, keep it clear and to the point. We appreciate straightforward communication, so make sure you convey your passion for the role without fluff!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen on joining our team!
How to prepare for a job interview at Pinnacle Pet Group
✨Know Your SQL Inside Out
As a BI Developer, you'll need to showcase your strong SQL skills. Brush up on T-SQL stored procedures and be ready to discuss how you've used them in past projects. Prepare examples that highlight your experience with SQL Server and SSIS, as these are crucial for the role.
✨Understand Data Warehousing Concepts
Make sure you have a solid grasp of data warehousing concepts, especially dimensional modelling. Be prepared to explain how you've applied these concepts in your previous roles. This will demonstrate your ability to contribute to the design of the Data Warehouse effectively.
✨Showcase Your Problem-Solving Skills
The ability to identify root causes of issues is key for this position. Think of specific instances where you've successfully analysed data to solve problems. Sharing these experiences will show your analytical skills and how you can add value to their team.
✨Communicate Clearly and Confidently
Effective communication is essential, especially when liaising with business areas and project managers. Practice articulating your thoughts clearly and succinctly. Consider preparing a few questions to ask during the interview to demonstrate your engagement and interest in the role.
