Data Analyst: Power BI, SQL & Insights Dashboards

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

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.