Turcan Connell, a respected legal and tax planning firm, is looking for a skilled Data Analyst to join their team. As a Data Analyst, you’ll play a crucial role in unlocking the value of the firm’s financial, operational, and client data, informing strategic decision-making, and enhancing profitability and efficiency.

Job Description

The Data Analyst will be responsible for analyzing financial, operational, and client data to identify trends, anomalies, and potential opportunities. This role will support pricing, forecasting, and budgeting processes with evidence-based models and ensure all data handling complies with GDPR, SRA regulations, and internal policies.

Day-to-Day Responsibilities

1. Manage data extraction from practice management systems
2. Design and deliver dashboards, reports, and KPIs
3. Conduct detailed data analysis to inform strategic decision-making
4. Support pricing, forecasting, and budgeting processes
5. Ensure data handling complies with GDPR, SRA regulations, and internal policies
6. Support data governance initiatives

Benefits and Perks

1. Hybrid working approach
2. Opportunity to develop technical skills and career in a supportive environment
3. Outstanding training opportunities
4. Congenial working environment

Pay Package

• Competitive

Location

• UK

Job Type

• Full-time permanent

Working Hours

Monday to Friday, 9am to 5pm, 33.75 hours per week

Company Name

Turcan Connell

FAQs

Q: What experience is required for this role?

A: Proven experience as a Data Analyst or Business Intelligence Analyst is desirable.

Q: What tools will I be working with?

A: Tools such as SSMS, SSRS, Power BI, and Aderant Development Tools.

Q: Is the role based in one location?

A: The role will principally be based in the Edinburgh office, but a hybrid working approach is possible after gaining sufficient experience.

Q: How do I apply?

A: Applications are invited until the closing date of 26th September 2025.

Tips and Advice

1. Tailor your CV and cover letter to highlight relevant experience and skills
2. Prepare examples of your data analysis experience
3. Research the company and understand its values and services
4. Practice your problem-solving skills
5. Show enthusiasm for developing your technical skills and career

Selection Criteria

1. Proven experience as a Data Analyst or Business Intelligence Analyst
2. Proficiency in Power BI, Excel, and SQL
3. Strong analytical skills with a problem-solving mindset
4. Ability to explain complex data concepts clearly
5. High level of discretion and confidentiality

Application Guidelines

To apply, submit your CV and cover letter highlighting your relevant experience and skills. Ensure you meet the selection criteria and demonstrate your enthusiasm for the role.

Get Started

What Makes Turcan Connell a Great Place to Work?

Turcan Connell is a trusted and respected legal and tax planning firm that has been providing exceptional services to individuals, entrepreneurs, landowners, charities, philanthropists, and trustees since 1997. With a close-knit team of around 230 colleagues, including 26 Partners across offices in Edinburgh, Glasgow, and London, the firm offers a comprehensive service covering everything required for efficient tax, estate and succession planning, as well as advice on land and property management and transactional activity. The firm’s values make clients feel looked after, and its commitment to colleagues as individuals is evident in its investment in talent development and outstanding training opportunities.