Data Analyst

Data Analyst - Manchester or Liverpool Based (2 days a week on site) - Permanent Role

Team: IT - Infrastructure

Location: Liverpool or Manchester

Role overview

Introduction to the role

As a Data Analyst, you are an integral part of both the IT Services team and the wider IT Department, running and maintaining the ITIL v3 aligned services we provide across our UK and International offices.

A large proportion of the firm's services are already underpinned by SQL and data services, and the role holds a particularly strong focus around our finance and practice management services, working very closely with the Finance Systems Team.

As the firm scales services utilising AI and automation, the structure, security, availability and accuracy of data across the organisation is becoming more critical than ever. Over the next 12-18 months, a huge focus will be on our revised data strategy which will see new technologies and services based on the Microsoft Fabric stack implemented across the organisation. This strategy will deliver secure, scalable structured and unstructured data sources which can be effectively mined by AI, with modern business intelligence services delivering internal and client facing insights.

Key responsibilities

You will work with other members of the IT Services team, as well as the wider department to assist with:

Turning raw data into actionable insights.

Support strategic planning and informed business decisions.

Improve efficiency and identify growth opportunities.

Service ownership

Implementing new and improving existing services

Understanding business requirements

Resolving business problems

Act as a point of escalation to desktop analysts

Support strategic planning and informed business decisions.

What are we looking for

Important criteria

Data collection and cleaning: Gathering data from various sources and ensuring its accuracy and consistency

Data analysis: Applying statistical techniques to extract meaningful information from the data

Data visualisation: Creating visual representations of data, such as charts and graphs, to facilitate understanding

Report generation: Developing clear and concise reports to communicate findings to stakeholders

Provide high-level technical guidance in initiating infrastructure-based service improvements

Act as a technical authority in the analysis of enhancement requests and recommend changes as required

Be responsible for liaison with internal / external teams to ensure delivery of technical solutions

Be aware of the impact of technical solutions in relation to cost and firm strategy

Provide specialist advice and guidance with skills transfer to members of the Support Desk and others as appropriate

Take a pro-active role in identifying any issues and possible solutions that may arise within an assignment and communicating these to the manager and customer as relevant

Utilise and champion agreed delivery methodologies and tools, including change and release management

Engage with the Finance Systems Team to perform monthly financial processes for the business

Keep software up to date with the latest cumulative and security patches

Implementing role-based security by managing user logins and permissions and additionally maintain robust backup strategies

Planning, installing, and configuring new instances of SQL based on technical design from stakeholders

Demonstrable previous experience within the SQL DBA / Power BI area, specifically:

Microsoft Fabric, including data factory

Data Lake

Dataverse

Python

Google Looker Studio

AI

Microsoft SQL Server, including Enterprise features, specifically availability groups

SQL Scripting / Queries

Power BI (Data Visualisation), designing and building interactive/dynamic dashboards.

Windows Server and Windows Clustering

Working knowledge of networking/networking stack

It would be beneficial to have some of the following

IIS

ITIL v3 Foundation

Microsoft Certified: Azure Foundation

Microsoft Certified: Power BI Data Analyst Associate

Microsoft Certified: Azure Enterprise Data Analyst Associate

SQL in public cloud services, such as Azure