Data Analyst (0448)

Price Bailey; Cambridge; On-site; GBP 35,000 - 55,000; Full time

Benefits offered by this job

25 days annual leave

Private medical

Contributory pension scheme

4x life assurance

Employee share scheme

Family friendly policies

2 days volunteering

Cycle to work

EAP with shopping discounts

Job summary

Price Bailey seeks a Data Analyst to own and evolve BI reporting, helping the firm turn data into actionable insights. You will develop Power BI dashboards, write SQL queries and contribute to data warehouse initiatives, partnering with stakeholders across the business.

Based in Cambridge, you will attend the office regularly to collaborate with colleagues and drive data-driven decision making. A degree in data analytics or related field is preferred, with BI experience in professional services.

Qualifications

• Degree in data analytics, computer science, information systems or related field.
• Experience as a Data Analyst or BI role in a professional services firm is desirable.
• Strong SQL querying, optimization and data modelling skills.
• Experience building reports with Power BI including Power Query, DAX and dashboards.
• Advanced Microsoft Excel skills with formulas, Pivot Tables, Power Query and data analysis techniques.
• Experience with relational databases and large datasets.
• Analytical mindset with attention to detail.

Responsibilities

• Develop and maintain Power BI dashboards, reports and KPI scorecards for stakeholders.
• Analyse business performance data to identify trends and opportunities (fee income, utilisation, WIP, debtors, operations).
• Write and optimise SQL queries, datasets and reporting models to support BI and decision making.
• Support development of the firm's data warehouse and integration of data from multiple systems.
• Create and maintain Power BI data models, DAX calculations and Power Query transformations.
• Collaborate with Partners and departments to translate requirements into reporting solutions.
• Promote data-driven culture by providing user support and maintaining reporting documentation.

Skills

Power BI

SQL

Data analysis

Excel

Education

Data Analytics degree

Experience in professional services

Tools

SQL Server

Power BI

DAX

Job description

Make your career count

At Price Bailey, we provide exciting opportunities for training, personal growth and career engagement. We believe in fostering happiness and fulfilment in your work, whilst supporting and inspiring you to grow. We understand that your life extends beyond the workplace, which is why our Smart Working culture promotes flexibility, allowing you to choose when and where you work, whilst still providing excellent client care.

What do the team do?

Our IT team plays an important role in helping the firm operate more efficiently, make better-informed decisions and continue to improve the way we deliver services to our clients.

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.

What will I be doing?

As a Data Analyst you will have ownership of the following tasks:

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

What experience do I need?

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.

What's on offer?

In addition to your salary, we also offer the following benefits:

• 25 days annual leave (with the option to buy/sell up to 5 days holiday)
• Private medical
• Contributory pension scheme
• 4x life assurance
• All employee share scheme
• Family friendly policies e.g. paid time off for dependants
• 2 days paid for volunteering
• Cycle to work scheme
• Employee Assistance Programme (EAP) including shopping discount

Price Bailey aspires to recruit, develop and retain the most talented people, regardless of their social background, age, disability, sex, sexual orientation, pregnancy and maternity, race or ethnicity, religion or belief, gender identity, or marriage and civil partnership. We are an equal opportunities employer and place inclusion at the heart of what we do. Our workplace is one where diversity is embraced and where everyone is empowered to be their authentic selves.

Should you require any reasonable adjustments, please let us know in the appropriate section of your application. For candidates with a disability who meet the minimum criteria of the role, we also offer a guaranteed interview, which you can opt into as part of your application.

A polite note to recruitment agencies

Price Bailey will only accept CV's from recruitment agencies who have been briefed on specific roles by our Resourcing team and where contractual agreement exists already. We do not accept speculative CV's and agency fees will not be owed in these instances. Should you wish to be considered for our approved supplier list please contact [e-mail]