Data Analyst (LPM), Asia

Herbert Smith Freehills Kramer

Hong Kong

On-site

HKD 400,000 - 650,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Herbert Smith Freehills Kramer LLP is seeking an LPM Data Analyst to join its Asia team. The role focuses on data-led insight, finance and operational reporting using Excel and Power BI across multi-jurisdictional matters.

You will cleanse and check matter data, develop dashboards, and support automation and AI initiatives, delivering client-ready outputs and training internal stakeholders.

Qualifications

  • 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, IT literacy and ability to learn new software quickly.
  • Advanced Excel capability including formulas, lookups, arrays, pivot tables, calculated fields, slicers, charts, deduplication and profitability calculations.
  • Basic Power BI capability or aptitude to develop it quickly, including dashboard creation, data modelling and DAX measures.
  • Experience with Power Query, Power Automate and other low-code tools to improve data transformation and reporting.
  • Experience with advanced Power BI, data extraction, SQL, Python or API-based reporting.
  • Experience using HighQ or similar client-facing collaboration platforms.
  • Regional language skills relevant to the role.

Skills

Power BI
Excel
SQL
Python
DAX
Power Query
SharePoint
AI / GenAI
Data analysis
Financial analysis
Stakeholder management
Communication skills
HighQ
Power Automate

Education

Degree in Law/Management/Finance/Business/Data

Tools

Power BI
Excel
SQL
Python
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:

  • 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.
  • 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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

LPM Data Analyst: AI-Driven Legal Tech & Power BI
LPM Data Analyst: AI-Driven Legal Tech & Power BI

Herbert Smith Freehills Kramer LLP • Hong Kong

On-site
HKD 400,000 - 650,000
Managing Lawyer, Risk and Compliance
Managing Lawyer, Risk and Compliance

Freshfields • Hong Kong

On-site
HKD 1,800,000 - 2,100,000
Head of Operations, Asia
Head of Operations, Asia

Linklaters Italy • Hong Kong

On-site
HKD 1,200,000 - 2,000,000
Paralegal
Paralegal

Freshfields • Hong Kong

On-site
HKD 300,000 - 480,000
Legal Counsel, APAC
Legal Counsel, APAC

Legal Counsel, APACHong Kong,HK-HK,Hong KongLegalCompany PriorityPosted a day ago • Hong Kong

Hybrid
HKD 1,500,000 - 1,900,000
Head of Marketing, Asia
Head of Marketing, Asia

Linklaters • Hong Kong

On-site
HKD 1,900,000 - 2,700,000
Head of Marketing, Asia
Head of Marketing, Asia

Linklaters Asia • Hong Kong

On-site
HKD 800,000 - 1,200,000
Client Development Partner
Client Development Partner

LexisNexis Legal & Professional • Hong Kong

On-site
HKD 600,000 - 1,000,000
Country-specific benefits
Client Development Partner
Client Development Partner

Relx Plc • Hong Kong

On-site
HKD 900,000 - 1,500,000
Client Development Partner
Client Development Partner

RELX (Greater China) Limited Company • Hong Kong

On-site
HKD 1,000,000 - 1,400,000