Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Transform raw data into actionable insights and support strategic planning.
- Company: Join Hill Dickinson, a forward-thinking firm with a commitment to diversity and inclusion.
- Benefits: Enjoy 25 days annual leave, flexible working, and a comprehensive benefits package.
- Other info: Opportunities for professional development and a supportive work environment.
- Why this job: Be part of a dynamic team driving innovation in data analysis and AI integration.
- Qualifications: Experience in SQL, data analysis, and visualisation tools like Power BI required.
The predicted salary is between 35000 - 45000 £ per year.
Hours: Monday to Friday, 09:00 - 17:00 (35 hours per week)
Happy to talk flexible working
Location: Liverpool or Manchester
Benefits
- Annual leave starting at 25 days
- Annual bonus scheme
- Birthday privilege day and Christmas shutdown
- Holiday buy, sell and carryover scheme
- 2 charity volunteering or pro bono days
- Optional private medical insurance via BUPA
- Annual fitness allowance
- Flexible pension scheme
- ISA saving scheme and independent financial advice
- Electric or hybrid vehicle lease scheme
- Medicash 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
- Financial contribution towards home working equipment
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.
- 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
What We Are 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
Additional Beneficial Skills
- 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
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; if there is anything that we can do to make your visit easier, 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.
Data Analyst - Infrastructure employer: Hill Dickinson LLP
Contact Detail:
Hill Dickinson LLP Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst - Infrastructure
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with current employees at Hill Dickinson. A friendly chat can sometimes lead to job opportunities that aren't even advertised!
✨Tip Number 2
Prepare for your interview by researching the company and its data strategy. Show us you understand how your skills in SQL and data visualisation can contribute to their goals. Tailor your examples to highlight your experience with Microsoft Fabric and AI.
✨Tip Number 3
Practice your data storytelling! Be ready to explain how you've turned raw data into actionable insights in past roles. Use clear visuals if possible, as this will resonate well with the team looking for a Data Analyst.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you're genuinely interested in joining the Hill Dickinson team.
We think you need these skills to ace Data Analyst - Infrastructure
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter to highlight your experience with SQL, data analysis, and any relevant technologies mentioned in the job description. We want to see how your skills align with what we're looking for!
Showcase Your Data Skills: When detailing your previous roles, focus on specific examples where you've turned raw data into actionable insights or improved processes. We love seeing real-world applications of your skills!
Be Clear and Concise: Keep your application straightforward and to the point. Use bullet points for easy reading and ensure your reports or findings are communicated clearly. We appreciate clarity just as much as you do!
Apply Through Our Website: Don't forget to submit your application through our official website! It’s the best way for us to receive your details and ensures you’re considered for the role. We can’t wait to hear from you!
How to prepare for a job interview at Hill Dickinson LLP
✨Know Your Data Tools
Familiarise yourself with the specific tools mentioned in the job description, like SQL, Power BI, and Microsoft Fabric. Be ready to discuss your experience with these technologies and how you've used them to turn raw data into actionable insights.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've resolved business problems using data analysis. Think about times when you identified growth opportunities or improved efficiency through your analytical skills, and be ready to share these stories during the interview.
✨Understand the Business Context
Research Hill Dickinson and its services, especially in relation to finance and practice management. Understanding the company's goals and how your role as a Data Analyst fits into their strategy will help you articulate your value during the interview.
✨Prepare for Technical Questions
Expect technical questions related to data collection, cleaning, and visualisation. Brush up on your statistical techniques and be prepared to discuss how you would approach specific data challenges relevant to the role.