Pogust Goodhead

Data Analyst

Pogust Goodhead

full-time

Posted on:

Location Type: Hybrid

Location: London • 🇬🇧 United Kingdom

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

AzureCloudPythonSQL

About the role

  • **About Pogust Goodhead**
  • Pogust Goodhead is a leading law firm dedicated to achieving justice for individuals and communities affected by corporate wrongdoing. Our team works on landmark group litigation cases and is passionate about holding powerful organisations to account.
  • We offer a collaborative environment, opportunities for career growth, and flexible working arrangements to support work-life balance.
  • **Role Overview**
  • We are looking for a Data Analyst with strong SQL skills and advanced Excel expertise to support the delivery of high-quality data transformation, reporting and insights across our organisation.
  • The role involves working with large Client and Legal datasets across our modern data platform (Power BI/Fabric, Databricks, and Synapse). Example activities including scenario modelling in PowerBI to support Operational Analytics, building funnel dashboards to understand the progression of Clients through a litigation, and cleansing data sets using augmented third party data.
  • You will work closely with stakeholders across the business, including Lawyers, Operations Directors, Client Care staff and Finance. We are also a close and supportive Tech & Data Team who will look for your insights and experience on how to keep improving our processes and output.

Requirements

  • **Essential**
  • - Strong SQL development skills (T-SQL) with experience working on large or complex datasets.
  • - Advanced Excel capability, including Power Query, advanced functions, pivot tables, and data modelling.
  • - Experience with Microsoft Power BI, including DAX, data modelling, and dashboard creation.
  • - Familiarity with cloud data technologies such as Microsoft Fabric, Databricks, or Azure Synapse.
  • - Strong analytical skills and the ability to translate raw data into meaningful insight.
  • - Excellent attention to detail and commitment to producing accurate, reliable outputs.
  • - Clear communication skills, with the ability to explain data and insights to non-technical stakeholders.
  • **Desirable**
  • - Experience working within a modern data engineering or analytics environment.
  • - Understanding of data governance, data quality frameworks, or data validation methods.
  • - Knowledge of Python or other analytical scripting languages (helpful but not mandatory).
  • - Experience optimising SQL queries for performance across cloud-based platforms.
Benefits
  • - 25 days’ annual leave (plus 8 Bank Holidays)
  • - Private medical insurance
  • - Private pension scheme
  • - Life assurance
  • - Enhanced maternity and paternity leave
  • - Employee assistance programme
  • - Employee referral bonus
  • - E-bikes and gym discounts (available through salary sacrifice scheme)
  • - Season ticket loans
  • **Pre-engagement Screening**
  • If we extend an offer of employment to you, we will conduct pre-engagement screening checks where local legislation permits and where relevant to your role and to working within a regulated environment. These checks may include, but are not limited to, verification of your professional and academic qualifications, your eligibility to work in the relevant jurisdiction, any criminal records, your financial stability and obtaining work-related references.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLT-SQLExcelPower QueryDAXdata modellingdashboard creationPythondata transformationdata cleansing
Soft skills
analytical skillsattention to detailcommunication skills