> Markdown version of [/jobs/ext/3742954-data-analyst](https://www.wearedevelopers.com/jobs/ext/3742954-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst - **Company:** Price Bailey - **Location:** Cambridge, UK (Remote available) - **Salary:** £35,000.0 - £45,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Analysis, Big Data, Business Software, Information Systems, Data Governance, Data Integration, Data Warehousing, Relational Databases, Excel Formulas, Microsoft Software, Microsoft SQL Server, Pivot Tables, Practice Management Software, Query Optimization, Power BI, SQL Databases, Powerquery, Information Technology, Data Analytics, Operational Systems - **Published:** October 15, 2026 - **Apply:** https://www.totaljobs.com/job/data-analyst/price-bailey-mayfair-llp-job108173406 ## About the Role Whilst having the following experience is advantageous, we value passion and potential. If you meet the minimum criteria listed below and are eager to develop yourself, we would love to hear from you: * A degree in Data Analytics, Computer Science, Information Systems, Mathematics, Finance or a similar discipline (minimum criteria). * Prior experienceworking in a Data Analyst or Business Intelligence role within a professional services firm (minimum criteria). * Strong SQL Server experience, including advanced SQL querying, query optimisation and data modelling. * Experience developing reports using Power BI, including Power Query, DAX, dashboard development and row-level security. * Strong Microsoft Excel skills, including advanced formulas, Pivot Tables, Power Query and data analysis techniques. * Experience working with relational databases and large datasets. * Strong analytical and problem-solving skills, with excellent attention to detail. ## Description As part of our growing data and digital transformation team, you will help develop, maintain and enhance reporting and analytical solutions that support decision-making across the firm. Working primarily with data from our Practice Management System and associated business applications, you will transform complex data into meaningful insight using SQL, Power BI and other Microsoft technologies. The firm's reporting environment is built primarily around Microsoft SQL Server and Power BI, with data sourced from Practice Management, Finance, HR, CRM and other operational systems. This role will play a key part in the ongoing development of our reporting, data warehouse and wider business intelligence capabilities. This is a Cambridge-based role and you'll be expected to attend the office regularly each week to work closely with colleagues and be fully involved in team activities. Please note that visa sponsorship is not available for this position. Applicants must have the ongoing right to work in the UK without requiring sponsorship now or in the future., * Developing and maintaining Power BI dashboards, reports and KPI scorecards that provide meaningful insights to stakeholders across the firm. * Analysing business performance data, identifying trends and opportunities across areas such as fee income, utilisation, WIP, debtors and operational performance. * Writing, optimising and maintaining SQL queries, datasets and reporting models to support business intelligence and decision-making. * Supporting the ongoing development of the firm's data warehouse, integrating data from multiple systems and helping to improve data quality. * Creating and maintaining Power BI data models, DAX calculations and Power Query transformations. * Working closely with Partners, Department Heads and operational teams to translate business requirements into effective reporting and analytical solutions. * Promoting a data-driven culture by providing user support, maintaining reporting documentation and contributing to data governance and continuous improvement initiatives.