Data Analyst (LPM), Asia

Herbert Smith Freehills Llp; Singapore; On-site; SGD 60,000 - 100,000; Full time

Job summary

Herbert Smith Freehills LLP is seeking an LPM Data Analyst to provide data-led insight and technology-enabled support on large, multi-jurisdictional matters in our Asia team.

You will prepare clear financial and operational reports using Excel and Power BI, cleanse and check data, and maintain dashboards to ensure outputs are accurate and client-ready. The role emphasizes AI, automation and training for stakeholders.

Qualifications

• Degree qualified in Law, Management, Finance, Business, Data/Analytics or related subject, or equivalent experience.
• 1–3 years’ relevant experience in a professional services environment.
• Strong analytical ability with financial acumen and ability to simplify data for clear communication.
• Advanced Microsoft 365 skills and IT literacy with quick adaptability to new software.
• Advanced Excel capability with formulas, lookups, pivots, charts, and client-friendly formatting.
• Basic Power BI capability or clear aptitude to develop it quickly, including dashboard creation and basic DAX.
• Awareness of confidentiality, permissions, information security and version control.
• Experience handling financial or operational data including cleansing, reconciliation, validation, and presentation of complex data sets.
• Interest in AI/GenAI, legal tech, automation and innovation in legal service delivery.
• Excellent written and verbal communication; ability to build relationships with stakeholders.
• Ability to work independently and as part of a team with strong time management.

Responsibilities

• Prepare financial and operational reports using Excel and Power BI across matters.
• Create and maintain Power BI dashboards that are accurate and client-ready.
• Cleanse and check matter data, monitor finances, and escalate risks or anomalies.
• Support repeatable reporting processes and drive efficiency with legal tech initiatives.
• Deliver training and guidance to help stakeholders interpret metrics and use approved tools effectively.

Skills

Analytical ability

Excel advanced

Power BI basics

MS 365 proficiency

Data handling

Communication skills

Stakeholder management

Independent worker

Time management

Attention to detail

Team collaboration

Education

Related degree

Tools

Power BI

SharePoint

SQL

Python

Power Query

Power Automate

HighQ

Job description

Our Global Legal Project Management team is looking for an LPM Data Analyst to join our Asia team. Working closely with senior LPM colleagues and practice groups you will provide data-led insight and technology-enabled support on large, complex and multi-jurisdictional matters.

The successful LPM Data Analyst will prepare clear financial and operational reports using Excel and Power BI, analysing key metrics across matters. You will create and maintain Power BI dashboards ensuring outputs are accurate and client ready. You will also cleanse and check matter data including financial monitoring, escalating risks or anomalies in a timely way. The LPM Data Analyst will support repeatable reporting processes and help improve efficiency with legal technology initiatives involving automation and AI. You will also deliver training and guidance to help internal stakeholders interpret metrics and use approved tools effectively.

The role is a great opportunity to develop specialist skills in data, reporting, financial analysis and legal technology, while supporting the delivery of excellent legal services to clients and internal stakeholders.

Qualifications, Skills and Experience:

Essential:

• Degree qualified in Law, Management, Finance, Business, Data/Analytics or a related subject, or equivalent relevant experience.
• At least 1-3 years’ relevant experience in a professional services environment.
• Strong analytical ability, financial acumen, understanding of key financial performance indicators and the ability to simplify complex data into clear communications.
• Strong Microsoft 365 skills, strong IT literacy and an ability to become proficient in new software and systems quickly.
• Advanced Excel capability, including formulas, lookups, arrays, pivot tables, calculated fields, slicers, charts, deduplication, profitability calculations, percentage calculations, Gantt charts and client-friendly formatting.
• Basic Power BI capability or clear aptitude to develop it quickly, including dashboard creation, basic data modelling, basic DAX measures, custom columns, model relationships and integration of estimates into reporting models.
• Awareness of confidentiality, permissions, information security and version control principles in the context of reporting and shared data environments.
• Experience handling financial or operational data, including cleansing, reconciliation, validation, structuring, analysis and presentation of complex or imperfect data sets.
• Interest in, and practical aptitude for, AI, GenAI, legal technology, collaboration software, automation and innovation in legal service delivery.
• Communicate complex issues succinctly, both verbally and in writing.
• Ability to build effective working relationships with stakeholders at different levels of seniority, including lawyers, business finance and technology teams.
• Ability to work independently and as part of a team, with attention to detail, an organised and practical mindset, strong time management and the ability to prioritise demanding workloads.

Desirable:

• Strong Power BI capability, including dashboard creation, basic data modelling, DAX measures, custom columns, model relationships and integration of estimates into reporting models, or clear aptitude to develop these skills quickly.
• Strong SharePoint and client portal capability, including site structure, permissions, document libraries, lists, user experience and risk-aware permission management.
• Understanding of law firm economics.
• Experience using Power Query, Power Automate and/or other low-code tools to improve data transformation, reporting and workflow efficiency.
• Experience with advanced Power BI (complex DAX, parameterised queries), data extraction, SQL, Python, API-based reporting or equivalent approved coding and analytics methods.
• Practical experience with AI, GenAI or machine learning tools applied to legal, financial or operational data analysis.
• Experience using HighQ, virtual deal rooms or similar client-facing collaboration and document management platforms.
• Regional language skills where relevant to the role and location.

We are committed to attracting people from all backgrounds and creating a respectful and inclusive culture where everyone thrives. We see this as essential to our success, including our ability to innovate and achieve sustained high performance. This is a key part of our Values—Human, Bold, and Outstanding