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 in the pet industry while working with innovative technologies.
- Qualifications: Strong SQL Server skills and experience in data analysis required.
- Other info: Be part of a diverse team that values collaboration and creativity.
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 events, 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 and Power BI. This will give you an edge and demonstrate your hands-on experience to potential employers.
✨Tip Number 3
Prepare for interviews by practising common BI-related questions and scenarios. Think about how you would approach data analysis problems and be ready to discuss your past experiences in detail.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are 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!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Share your passion for data and how it can enhance customer experiences. Don’t forget to mention why you’re excited about working with us at Pinnacle Pet UK.
Showcase Your Problem-Solving Skills: In your application, give examples of how you've tackled data issues in the past. We love candidates who can analyse data and find root causes, so let us know how you've done this before!
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 don’t miss out on any important updates from 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 experience in SQL Server. Brush up on your T-SQL stored procedures and be ready to discuss how you've used them in past projects. Prepare to answer technical questions that test your knowledge of data warehousing concepts and SSIS.
✨Showcase Your Problem-Solving Skills
Be prepared to demonstrate your ability to analyse data and identify root causes of issues. Think of specific examples where you’ve successfully resolved problems using targeted data analysis. This will highlight your analytical skills and your proactive approach to challenges.
✨Communicate Clearly and Confidently
Effective communication is key in this role. Practice explaining complex technical concepts in simple terms, as you’ll need to liaise with various stakeholders. Be ready to provide clear documentation examples from your previous work to show your attention to detail.
✨Emphasise Collaboration and Flexibility
This position involves working closely with project teams and end-users. Share experiences where you’ve collaborated effectively with others, especially in hybrid environments. Highlight your flexibility and willingness to adapt to changing requirements, which is crucial for success in this role.
