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