Job Advert
About Us
We are trusted and respected legal and tax planning experts and our approach to providing a personal, discreet, and tailored service is key to our success since the Firm was established in 1997. The Firm acts on behalf of individuals, entrepreneurs, landowners and works with charities, philanthropists, and trustees to guide and manage complex legal and financial affairs on their behalf. Our values make our clients feel looked after.
With a close-knit team of around 230 colleagues including 26 Partners across offices in Edinburgh, Glasgow and London, Turcan Connell's comprehensive service covers everything required for efficient tax, estate and succession planning as well as advice on the many aspects of land and property management and transactional activity. We also handle the complexities of divorce and family law, employment law and dispute resolution advice and provide a range of business law services to our clients.
Opportunity
We have an exciting new opportunity for a Data Analyst to join our IT team. The position is on a full-time permanent basis, core hours are Monday to Friday, 9am to 5pm, 33.75 hours per week.
The role will principally be based in our Edinburgh office, although we support a hybrid working approach once sufficient experience of performing the role has been obtained.
Role and Responsibilities
You will be responsible for unlocking the value of the Firm's financial, operational and client data by turning it into clear actionable insights. These insights will be used to inform strategic decision making, enhance profitability and efficiency as well as enhancing the overall client experience.
As part of the role, you will be expected to manage the extraction of validated data from our practice management systems whilst maintaining data accuracy, consistency, and integrity across all platforms. You will assist in the design and delivery of dashboards, reports and KPIs using tools such as SSMS, SSRS, Power BI and Aderant Development Tools. Generating regular reports for leadership and conducting detailed data analysis to inform the Firm's strategic decision-making.
It is required that you will be able to analyse financial, operational, and client data to identify trends, anomalies, and potential opportunities. Support pricing, forecasting, and budgeting processes with evidence-based models. You must be able to interpret technical data findings and communicate them in clear, comprehensible language for stakeholders. It is important that this role ensures all data handling complies with GDPR, SRA regulations and internal policies.
The role will also support data governance initiatives, including data quality and audits and metadata management.
Person Specification
Proven experience as a Data Analyst or Business Intelligence Analyst ideally within a professional services environment is desirable. In order to be successful, candidates will be proficient in Power BI, Excel (pivot tables, Power Query, etc.), and SQL and have strong analytical skills with a problem-solving mindset.
The ability to explain complex data concepts clearly to non-technical audiences and be able to collaborate with colleagues across various departments in the Firm is important.
You will be a strong team player with sound practical experience and enthusiasm to develop your technical skills and career further in a supportive environment. A high level of discretion and confidentiality is a requirement of this role, as you will be exposed to sensitive client data and financial information.
Turcan Connell will provide you with the opportunity to build on your career and realise your ambitions in an environment with an unrivalled reputation, and a commitment to our colleagues as individuals. We invest in the development of our talent and provide outstanding training opportunities within a congenial working environment. We have a very strong team across the Firm, and many of our colleagues have chosen to invest their whole career at the Firm. Through living our Firm's values, we want to make you feel looked after.