Data Analyst – Turcan Connell (Edinburgh, Scotland)

School Result; City of Edinburgh; Hybrid; GBP 38,000 - 50,000; Full time

Job summary

A respected legal and tax planning firm in Edinburgh seeks a Data Analyst to drive insights from data and support strategic decisions. This full-time role offers a competitive salary between £38,000 to £50,000 and includes opportunities for professional development in a hybrid work environment.

Qualifications

• Proven experience as a Data Analyst or Business Intelligence Analyst.
• Experience in a professional services environment preferred.
• Strong analytical and problem-solving skills.

Responsibilities

• Analyze financial, operational, and client data to identify trends.
• Design and deliver dashboards and reports.
• Ensure compliance with GDPR, SRA regulations.

Skills

Data analysis

Problem-solving

Power BI

SQL

Excel

Tools

Power BI

SSMS

SSRS

Excel

Job description

Data Analyst – Turcan Connell (Edinburgh, Scotland)

Turcan Connell is hiring aData Analyst to join its IT team in Edinburgh. This full-time, permanent role offers a competitive salary range of £38,000 to £50,000 (Glassdoor estimate) and provides the opportunity to work in a hybrid environment after onboarding. If you’re a data professional with strong analytical skills and a passion for turning complex information into actionable insights, this role offers a rewarding career path in one of Scotland’s most respected legal and tax planning firms.

About Turcan Connell

Founded in 1997, Turcan Connell is a trusted name in legal and tax planning, known for its personal, discreet, and tailored services. The firm works with individuals, entrepreneurs, landowners, charities, philanthropists, and trustees to manage complex legal and financial affairs. With offices in Edinburgh, Glasgow, and London, Turcan Connell employs over 230 professionals, including 26 partners.

The firm’s comprehensive services include tax, estate, and succession planning, land and property management, family law, employment law, dispute resolution, and business law. Turcan Connell is committed to making clients feel looked after—and that same care extends to its employees.

Position Overview

As a Data Analyst, you’ll play a key role in unlocking the value of Turcan Connell’s financial, operational, and client data. Your insights will inform strategic decisions, improve efficiency, and enhance the client experience. You’ll work with tools like Power BI, SSMS, SSRS, and Aderant Development Tools to design dashboards, generate reports, and support data governance initiatives.

This role is ideal for professionals with experience in data analysis or business intelligence, particularly within a professional services environment.

• Position Title: Data Analyst
• Company: Turcan Connell
• Location: Edinburgh, Scotland
• Employment Type: Full-Time, Permanent
• Work Schedule: Monday to Friday, 9am to 5pm (33.75 hours/week)
• Salary Range: £38,000 – £50,000 (Glassdoor estimate)
• Work Environment: Hybrid (office-based initially, remote flexibility after onboarding)

Key Responsibilities

• Analyze financial, operational, and client data to identify trends, anomalies, and opportunities
• Extract validated data from practice management systems while ensuring accuracy and integrity
• Design and deliver dashboards, reports, and KPIs using SSMS, SSRS, Power BI, and Aderant tools
• Generate regular reports for leadership and support strategic decision-making
• Support pricing, forecasting, and budgeting with evidence-based models
• Communicate technical findings in clear, accessible language for non-technical stakeholders
• Ensure compliance with GDPR, SRA regulations, and internal data policies
• Contribute to data governance initiatives, including quality audits and metadata management

Required Skills and Experience

• Proven experience as a Data Analyst or Business Intelligence Analyst
• Experience in a professional services environment (preferred)
• Proficiency in Power BI, Excel (pivot tables, Power Query), and SQL
• Strong analytical and problem-solving skills
• Ability to explain complex data concepts to non-technical audiences
• Collaborative mindset and ability to work across departments
• High level of discretion and confidentiality when handling sensitive data
• Enthusiasm for developing technical skills and growing within a supportive team

Why Join Turcan Connell?

Turcan Connell offers a unique opportunity to build a long-term career in a firm with an unrivalled reputation. Many team members have chosen to invest their entire careers here, thanks to the firm’s commitment to professional development, outstanding training, and a congenial working environment.

You’ll be part of a strong, close-knit team that values collaboration, integrity, and excellence. Whether you’re looking to deepen your expertise in data analytics or transition into a strategic role, Turcan Connell provides the structure and support to help you thrive.

Join Our Official Channels for more Jobs & Scholarship

No comment's at the moment!, Be the first to post a comment.