Data Analyst

About us

Avencia Consulting are recruiting on behalf of a well known Insurer in the City, who are looking to hire a Data Analyst to join on a permanent basis.

The role

This role offers an exciting opportunity to fast-track your career in an aggressively ambitious business. The role's broad scope provides high exposure to the business, visibility over Group processes and systems, and exposure to and collaboration with highly skilled professionals.

The primary purpose of the role is to develop and implement innovative solutions that address business issues, streamline workflows, and automate processes to maximise efficiency by translating business requirements into technical solutions.

Key accountabilities

• Gather & analyse business requirements by collaborating with business stakeholders and IT Management, studying systems flow, data usage and work processes.
• Develop, implement, and maintain apps, workflows, automation processes, and data integrations using the Power Platform tools.
• Design and build interactive and insightful reports and dashboards using Power BI to provide data-driven insights.
• Analyse data to provide both reports and insight using a range of technologies including SQL, Python and PowerPlatform.
• Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, etc.
• Manage data collection processes with the MGA's or third parties - ensuring processes are documented and data is delivered to an appropriate level of quality.
• Any other duties assigned by your line manager relevant to the role/time.

Our Stack

Pine Walk works completely in the cloud to ensure we are flexible and ready for growth. Our Datawarehouse is built on Azure SQL combining data from third party databases and our own apps. The Power Platform is our reporting tool of choice alongside Excel but given the types of insurance involved, other areas of data analysis and system design, e.g. Python, GIS, will need to be integrated into our solutions in the future.

Pine Walk is committed to exploring new technologies to automate processes and deliver effective working processes.

Skills & experience

• Degree educated (minimum 2:1) in a numerate subject.
• Prior experience in a coding language (preferably SQL or Python).
• Ability to handle a varied workload and competing priorities.
• Strong analytical, research and reporting skills.
• Intermediate proficiency in the Microsoft Office Suite, particularly Excel, Word, and PowerPoint.
• Working Knowledge of insurance, particularly London market is preferred
• Proven ability to follow instructions and work diligently to create solutions based on provided specifications.