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.
Key Responsibilities Data Preparation & SQL Development
- Write, optimise, and maintain complex SQL queries (T SQL) across Databricks and Synapse environments.
- Clean, transform, and model data to support reporting and analytical requirements.
- Ensure data accuracy, consistency, and reliability across all datasets and outputs.
- Work with engineering teams to identify opportunities for improved data structures or pipelines.
Reporting, Dashboards & Insight
- Build, enhance, and maintain Power BI dashboards and reports aligned to business needs.
- Perform in depth data analysis to uncover trends, anomalies, and actionable insights.
- Translate analytical outputs into clear, concise recommendations for non technical audiences.
- Support the wider business in understanding and using reports effectively.
Advanced Excel Analysis
- Produce detailed analysis models using advanced Excel techniques (Power Query, advanced formulas, pivoting, data modelling).
- Build templates and reusable tools that support teams across the organisation.
- Ensure Excel based reporting is robust, dynamic, and maintains data integrity.
Data Quality, Governance & Performance
- Monitor data accuracy and proactively address discrepancies or inconsistencies.
- Support continuous improvement of data processes, standards, documentation, and metadata.
- Contribute to the development of best practices for data validation, reporting, and analysis.
- Work collaboratively with technical teams to enhance performance across datasets and queries.
- Stakeholder Engagement.
- Act as a key point of contact for analytical queries, reporting needs, and insight requests.
- Engage with stakeholders to clarify requirements and translate them into technical solutions.
- Communicate findings clearly-both visually and verbally-to technical and non technical audiences.
Skills & Experience 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.
Success Measures
- Delivery of accurate, timely, and high quality analysis and reporting.
- Improved visibility and understanding of key data across the business.
- Increased trust in dashboards, datasets, and analytical outputs.
- Positive stakeholder feedback on clarity, insightfulness, and responsiveness.
- Measurable improvements in data quality, reporting processes, and analytical efficiency.
- 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.