Data Analyst

2 weeks ago


Croydon, United Kingdom Pine Walk Capital Limited Full time
Job Description

About Pine Walk

Pine Walk Capital is a business platform helping insurance teams to grow. Pine Walk provides a wrap-around set of support functions and delivers best in class service across executive management, consultancy, finance, compliance, and IT. Pine Walk works with highly motivated niche insurance teams that deal in complicated and innovative transactions. Pine Walk is on a high growth trajectory which is giving rise to opportunities and new roles across the team.


Job Summary

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 design, develop, and optimize SQL queries, stored procedures, and database architectures to solve business problems. This includes writing and maintaining efficient SQL code for data retrieval, manipulation, and reporting, as well as automating recurring database tasks. The role also involves performance tuning, ensuring data integrity, and managing datasets to optimise database performance and scalability. You'll collaborate closely with other developers and teams to integrate SQL solutions with applications and ensure seamless data flow.


Location

Pine Walk is part of the wider Fidelis Partnership Group – with offices across London, Belgium, Ireland, and Bermuda. This role will be based in the Croydon office with 1x day per week in the London City office.


Key Responsibilities

1. Create, optimise, and maintain SQL queries and stored procedures for efficient data retrieval, manipulation, and reporting.

2. Analyse and optimise database performance through indexing, query optimisation, and other techniques to ensure high efficiency and scalability.

3. Work with third parties to deliver integrations that are robust and effective, to reduce manual processing/re-keying of data.

4. Automate recurring database processes such as data imports, exports, and scheduled jobs to improve workflow efficiency.

5. Analyse data to provide both reports and insight using a range of technologies including SQL, Python and Power Platform.

6. Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, etc.

7. 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.

8. Manage and review the tasks of the junior data analysts – developing into the line manager for junior data analysts.

9. Working with the rest of the Pine Walk data team ensure that infrastructures and environments are appropriately sized and structured.

10. 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.


Essential Skills, Knowledge, and Experience

• Degree educated (minimum 2:1) in a numerate subject.

• Prior experience in SQL ( preferably 2+ years)

• Strong written and spoken communication skills to enable communication at all levels.

• 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.

• Proven ability to follow instructions and work diligently to create solutions based on

provided specifications.


Competencies and behaviours

• Proactive and solutions orientated.

• Analytical with a strong attention to detail.

• Detail-orientated with excellent problem-solving skills.

• Personal drive and resilience in established and new/changing situations.

• Ability to support success and timely delivery in a complex, multi-disciplinary environment.

• A team player with strong interest in the performance of the wider business.

• Commercially savvy, bright, energetic, and positive with a ‘can do’ attitude and a focus on getting things done.



  • Croydon, Greater London, United Kingdom Evolve Housing + Support Full time

    About the Role:We are seeking a highly skilled Data Analyst to join our team at {company}. As a Data Analyst, you will be responsible for analyzing and interpreting complex data sets to inform business decisions.Key Responsibilities:Data Analysis: Develop and maintain data analysis processes to ensure accuracy and efficiency.Insight Generation: Identify key...


  • Croydon, Greater London, United Kingdom C2 Recruitment Ltd Full time

    Data Insights Analyst PositionC2 Recruitment Ltd is looking for a Data Insights Analyst to support our Supply Chain Administrative team.In this role, you will work with data to identify trends, discrepancies and opportunities for improvement. You will process and consolidate data received from audit staff, check for accuracy, and produce reports for...

  • Data Analyst

    3 weeks ago


    Croydon, United Kingdom Pine Walk Capital Limited Full time

    About Pine WalkPine Walk Capital is a business platform helping insurance teams to grow. Pine Walk provides a wrap-around set of support functions and delivers best in class service across executive management, consultancy, finance, compliance, and IT. Pine Walk works with highly motivated niche insurance teams that deal in complicated and innovative...

  • Data Analyst

    3 weeks ago


    Croydon, United Kingdom Pine Walk Capital Limited Full time

    About Pine WalkPine Walk Capital is a business platform helping insurance teams to grow. Pine Walk provides a wrap-around set of support functions and delivers best in class service across executive management, consultancy, finance, compliance, and IT. Pine Walk works with highly motivated niche insurance teams that deal in complicated and innovative...

  • Data Analyst

    3 weeks ago


    Croydon, United Kingdom Pine Walk Capital Limited Full time

    About Pine WalkPine Walk Capital is a business platform helping insurance teams to grow. Pine Walk provides a wrap-around set of support functions and delivers best in class service across executive management, consultancy, finance, compliance, and IT. Pine Walk works with highly motivated niche insurance teams that deal in complicated and innovative...

  • Data Analyst

    3 weeks ago


    Croydon, United Kingdom Pine Walk Capital Limited Full time

    About Pine WalkPine Walk Capital is a business platform helping insurance teams to grow. Pine Walk provides a wrap-around set of support functions and delivers best in class service across executive management, consultancy, finance, compliance, and IT. Pine Walk works with highly motivated niche insurance teams that deal in complicated and innovative...


  • Croydon, United Kingdom Stott and May Full time

    Data Analyst - Insurance Location: Croydon + London (4 days in Croydon + 1 day in London) Salary: £45,000 + bonus + benefits The primary focus of the Data Analyst role is to design, develop, and optimize SQL solutions to address business needs. Develop and optimize SQL queries and stored procedures for effective data retrieval, reporting, and...

  • Data Analyst

    3 weeks ago


    Croydon, United Kingdom Stott and May Full time

    Data Analyst - Insurance Location: Croydon + London (4 days in Croydon + 1 day in London) Salary: £45,000 + bonus + benefits Job Summary The role offers extensive exposure to business processes, systems, and collaboration with highly skilled professionals. The primary focus of the Data Analyst role is to design, develop, and optimize SQL solutions to...

  • Data Analyst

    3 weeks ago


    Croydon, United Kingdom Stott and May Full time

    Data Analyst - InsuranceLocation: Croydon + London (4 days in Croydon + 1 day in London)Salary: £45,000 + bonus + benefitsJob SummaryThe role offers extensive exposure to business processes, systems, and collaboration with highly skilled professionals. The primary focus of the Data Analyst role is to design, develop, and optimize SQL solutions to address...

  • Data Analyst

    3 weeks ago


    Croydon, United Kingdom Stott and May Full time

    Data Analyst - InsuranceLocation: Croydon + London (4 days in Croydon + 1 day in London)Salary: £45,000 + bonus + benefitsJob SummaryThe role offers extensive exposure to business processes, systems, and collaboration with highly skilled professionals. The primary focus of the Data Analyst role is to design, develop, and optimize SQL solutions to address...

  • Data Analyst

    3 weeks ago


    Croydon, United Kingdom Stott and May Full time

    Data Analyst - Insurance Location: Croydon + London (4 days in Croydon + 1 day in London) Salary: £45,000 + bonus + benefits Job Summary The role offers extensive exposure to business processes, systems, and collaboration with highly skilled professionals. The primary focus of the Data Analyst role is to design, develop, and optimize SQL solutions...

  • Data Analyst

    3 weeks ago


    Croydon, United Kingdom Stott and May Full time

    Data Analyst - InsuranceLocation: Croydon + London (4 days in Croydon + 1 day in London)Salary: £45,000 + bonus + benefitsJob SummaryThe role offers extensive exposure to business processes, systems, and collaboration with highly skilled professionals. The primary focus of the Data Analyst role is to design, develop, and optimize SQL solutions to address...

  • Data Insight Analyst

    3 weeks ago


    Croydon, Greater London, United Kingdom Zurich 56 Company Ltd Full time

    Job Overview: We are seeking a talented Data Insight Analyst to join our team at Zurich 56 Company Ltd.This role will involve the analysis of multiple data sources using different techniques to provide data-led insights to our underwriting, sales and management teams.The ideal candidate will have a strong analytical mindset, excellent problem-solving skills,...

  • Data Insight Analyst

    3 weeks ago


    Croydon, Greater London, United Kingdom Zurich Insurance Full time

    At Zurich Insurance, we're seeking a skilled Regional Portfolio Analyst to join our team. In this role, you'll be responsible for utilizing data to drive improvements to our regional portfolio's by providing data-led insights to our underwriting, sales, and management teams.You'll be part of a team that's key to supporting our Retail business by delivering...

  • Business Analyst

    4 weeks ago


    Croydon, Greater London, United Kingdom BSS Full time

    We are seeking a Business Analyst to join our team. Key responsibilities include analyzing business data to identify trends and areas for improvement, developing and implementing data-driven solutions, and collaborating with cross-functional teams to drive business growth.Develop and maintain business intelligence reports and dashboards.Analyze large...

  • Data Analyst

    3 weeks ago


    Croydon, UK, London, United Kingdom Pine Walk Capital Limited Full time

    About Pine WalkPine Walk Capital is a business platform helping insurance teams to grow. Pine Walk provides a wrap-around set of support functions and delivers best in class service across executive management, consultancy, finance, compliance, and IT. Pine Walk works with highly motivated niche insurance teams that deal in complicated and innovative...


  • Croydon, Cambridgeshire, United Kingdom Stott and May Full time £45,000

    Data Analyst Job Description:At Stott and May, we are seeking a skilled Data Analyst to join our team. As a Data Analyst, you will play a crucial role in designing, developing, and optimizing SQL solutions to address business needs.Key Responsibilities:• Develop and optimize SQL queries and stored procedures for effective data retrieval, reporting, and...


  • Croydon, Greater London, United Kingdom Your Croydon Full time

    Job SummaryThe Information Management team at Your Croydon is seeking a skilled Data Warehouse Business Analyst to join their team on a 12-month secondment or fixed-term contract. As a key member of the business management team, you will be responsible for investigating operational requirements, problems, and opportunities, and identifying options for...

  • SQL Data Architect

    7 days ago


    Croydon, Greater London, United Kingdom Stott and May Full time

    Data Analyst Role Overview:Stott and May is seeking a talented Data Analyst to join our business intelligence unit. As a key member of our team, you'll design, develop, and optimize SQL solutions to meet business needs.Key Responsibilities:Develop and optimize SQL queries and stored procedures for effective data retrieval, reporting, and manipulation.Analyse...

  • Performance Analyst

    5 months ago


    Croydon, United Kingdom HM Land Registry Full time

    Here at **HM Land Registry,** we have an exciting opportunity available for a **Performance Analyst**to join our Transformation and Technology directorate. You will join us on **full-time or part-time, permanent**basis and in return,**you will receive a competitive salary of **£34,854 per annum (Croydon £38,409).** **The Performance Analyst role can be...