Senior Data Insight Analyst - Pinnacle Pet UK
This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.
Job Details
The Senior Data Insight Analyst will apply their experience of driving growth through data to Pinnacle Pet UK, a fast-growing pet insurance company. Data and technology are at the heart of our proposition and transformation. The value you will bring is key to realising our organisation's potential.
You will deliver this value through:
- understanding and communicating how the key business metrics drive overall performance.
- monitoring and reporting the metrics and their movements, both standalone and in relation to budgeted targets
- independently delving into data to discover the cause of changes in performance uncovering actionable opportunities and threats
This is a data-focused role requiring strong business understanding alongside the necessary technology (we use SQL and Power BI) and data analysis skills to be able to both build reporting solutions and also to communicate reasons for KPI trends to senior stakeholders.
Key Responsibilities
- Understand the key metrics related to business performance, covering Pricing, Finance, Marketing and Operations.
- Help create automated monitoring of key metrics to ensure key stakeholders are made immediately aware of any adverse shifts within any business segments of interest.
- Understand the budget planning process and use this to drive the build of an outlier detection system and inform the selection of materiality thresholds for key metrics.
- Understand the interplay between different key metrics, and how shifts in one metric can produce shifts in others.
- Understand and monitor all events (internal and external) that may drive changes in key metrics. Use these to explain KPI trends to senior stakeholders.
- Develop fit-for-purpose Power BI dashboards to enable both senior stakeholders and key individuals within each business unit to understand and analyse key metrics at increasingly granular segmental levels.
- Develop Power BI dashboards that help to industrialise each reporting pack for each reporting cycle, eg: daily, weekly and monthly.
- Providing detailed analysis on performance against business plans and targets.
- To be able to communicate both verbally and in writing at all levels to understand the MI requirements of external clients and internal departments.
- To act to deliver good outcomes for retail customers whilst delivering a higher standard of customer care and enabling consumers to make effective decisions in their interests.
- Work closely with Data Warehouse Department, to understand changes and help develop reports to be efficient and accurate.
- Attend and contribute to working groups to improve KPI.
- Complete ad-hoc analysis and/or reporting.
Successful Candidates Will Have
Essential
- Strong data analysis experience,
- Advanced technical skills including Power BI, DAX, Power Query,
- Excel and other MS Office applications.
- Advance SQL querying, ideally Microsoft (SQL Server) T-SQL.
- Meticulous attention to detail.
- The ability to communicate effectively, both written and orally.
- Team player who can work proactively and on their own initiative.
- Ability to work to deadlines and multi-task.
- Ability to prioritise own workload and effectively manage projects.
Desirable
- Experience of working within a Pricing, Finance or MI department of a general insurance company
- Working knowledge of Microsoft Power BI language M.
- Microsoft Fabric / Azure
- Good understanding of Google Analytics and / Big Query
- An understanding of the concepts of database design for both transactional and analytical databases
- Knowledge of Microsoft tools (Visual Studio, SSIS, SSAS)
- Working knowledge of SQL Server Management Studio (SSMS)