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