Data Analyst

OperationsAbout UsEstablished in 2000, Express Solicitors is an award-winning law firm that deals with personal injury and clinical negligence claims. Based in Manchester, we serve clients nationwide and are currently ranked 70 out of more than 10,000 law firms. We have a 5-star rating on Trustpilot from over 7,000 reviews, which coming from our clients means a lot to us. We are proud of the work we do helping injured people, and this is the core of our business.

The RoleWe are currently seeking an experienced Data Analyst who has experience in successfully leading on projects, along with considerable experience and knowledge of developing and presenting information using Microsoft Power BI to various audiences at all levels. The ideal candidate will have strong technical expertise in Power BI and be highly proficient in SQL. The role will involve the creation and maintenance of business intelligence dashboards utilising data from various data sources for the use of various levels of stakeholder. ResponsibilitiesDesign, develop, and maintain dashboards, reports, and data models in Power BI.

Build and optimise SQL queries to support analytics and reporting requirements. Collaborate with internal stakeholders to understand data needs and deliver actionable insights. Integrate data from multiple sources into the firm’s SQL data warehouse. Ensure data integrity, governance, and security are maintained in all solutions. Support the firm’s strategic initiatives by providing high-quality analytics and visualisations. Person SpecificationEssential Skills & ExperienceProven experience working as a Data Analyst, BI Developer, or similar role. Strong proficiency in SQL for querying, transforming, and managing data. Demonstrable experience with Power BI, including data modelling, DAX, and report/dashboard development.

Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions. Experience working with data from multiple, disparate sources. Excellent communication skills, with the ability to present complex information in a clear, concise way to non-technical stakeholders. Desirable Skills & ExperienceExperience integrating data from external systems via APIs. Knowledge of Python, R, or similar languages for data manipulation and automation. Familiarity with data warehousing concepts, including star/snowflake schema design. Experience working in a professional services or legal sector environment. Understanding of data governance, compliance, and security best practices.

Exposure to other Microsoft data tools such as Azure Data Factory or SQL Server Integration Services (SSIS). Salary & HoursSalary of £32,000 to £35,000, dependent on experience Our standard working hours are 8: 30am to 5: 30pm Monday-Thursday and 8: 30am to 5pm Friday. BenefitsHybrid Working3/2 hybrid working pattern after probation. 23 Days HolidayRising to 26 days, plus bank/public holidays. Extra Holidays3 holiday buy backs and an extra day for your birthday after service length requirement. Looking After Your HealthPrivate medical insurance available after 2 years’ service, annual flu jab and Employee Assistance Programme.

Looking After Your Well-being24/7 onsite Gym, Netball/Football team, 10km Manchester team and more. Work Life / BalanceActive social committee with generous departmental and firm-wide social budget. Recruitment ProcessInterviews will be conducted by MS Teams and will include scenario-based questioning. Our employees are our most important asset, we rate skill and ability above all else and our recruitment policy encourages applications from all.