Data Analyst - Infrastructure in Liverpool

Hours: Monday to Friday, 09:00 - 17:00 (35 hours per week). Happy to talk flexible working.

Location: Liverpool or Manchester.

Benefits: At Hill Dickinson we understand that incentives go far beyond a good salary, so we have created a comprehensive benefits package tailored around our people. Here are some examples of what we offer:

• Annual leave starting at 25 days
• Birthday privilege day and Christmas shutdown
• Holiday buy, sell and carryover scheme
• Optional private medical insurance via BUPA
• Annual fitness allowance
• ISA saving scheme and independent financial advice
• Electric or hybrid vehicle lease scheme
• EAP with access to counselling
• Enhanced family leave policies
• Access to confidential, expert support via Fertifa in relation to reproductive health and wellbeing
• Access to 10 days fully subsidised emergency or back-up care per year via Bright Horizons
• Life assurance
• Group income protection
• Annual travel season ticket loan
• Hybrid working and dress for your day policy
• Bespoke training and development opportunities

Role overview: 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.
• Supporting strategic planning and informed business decisions.
• Improving efficiency and identifying growth opportunities.
• Implementing new and improving existing services.
• Understanding business requirements.
• Resolving business problems.
• Acting as a point of escalation to desktop analysts.

What are we looking for:

• 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.
• Providing high-level technical guidance in initiating infrastructure-based service improvements.
• Acting as a technical authority in the analysis of enhancement requests and recommending changes as required.
• Being responsible for liaison with internal / external teams to ensure delivery of technical solutions.
• Being aware of the impact of technical solutions in relation to cost and firm strategy.
• Providing specialist advice and guidance with skills transfer to members of the Support Desk and others as appropriate.
• Taking 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.
• Utilising and championing agreed delivery methodologies and tools, including change and release management.
• Engaging with the Finance Systems Team to perform monthly financial processes for the business.
• Keeping software up to date with the latest cumulative and security patches.
• Implementing role-based security by managing user logins and permissions and additionally maintaining 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 SQL Server, including Enterprise features, specifically availability groups.
• 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:
• SQL in public cloud services, such as Azure.

Equality, Diversity and Inclusion: Hill Dickinson is committed to providing fairness and equal opportunity for all regardless of age, gender, gender identity, ethnic origin, disability, sexual orientation, marital or transgender status, nationality, religion or belief. We understand that our power as a firm comes from empowering our people and that it is only by encouraging and enabling individuals to be themselves at work that we can truly benefit from their rich and varied strengths. Hill Dickinson is an equal opportunities employer. All applications received by the firm will be considered based on their merit alone and we welcome applications from all suitably qualified individuals regardless of background and from all routes to qualification, with both the SRA and CILEx.

Disability Support: We are a Disability Confident employer, which means if there is anything that we can do to make your visit easier, so you are able to perform at your best, please let us know. You can contact the HR team at hrteam@hilldickinson.com should you require any adjustments to the application or interview process. All successful candidates will be subject to our standard pre-employment screening, including a basic criminal record check via Disclosure and Barring Service. Any offer of employment made is conditional upon completion of all checks. Due to the high response levels we receive for some vacancies, we may expire any of them prior to the advertised closing date and advise you to submit your application as soon as possible.