Resources / Employers
How to Hire a Legal Data Analyst
A complete employer guide — how this role differs from a Spend Analyst and an Operations Analyst, what to pay, a copyable job description template, where to find SQL and BI-fluent candidates, and an interview rubric that separates data modelers from dashboard operators.
Why hiring a Legal Data Analyst is different
The Legal Data Analyst is distinct from two roles that sound adjacent but are genuinely different jobs. Clarifying these boundaries before writing the JD is the most valuable thing a hiring team can do.
The Legal Spend Analyst owns the financial analytics layer: outside counsel invoices, LEDES billing review, UTBMS coding, accruals, rate analysis, and spend forecasting. The data sources are e-billing platforms and finance ERP systems. The primary audience is the GC and CFO. The work is specific: billing compliance, spend reconciliation, accrual accuracy. For the full spend-analyst employer guide, see How to Hire a Legal Spend Analyst.
The Legal Operations Analyst at the entry-to-mid level does a mix of quantitative work and operational coordination — intake metrics, process documentation, dashboard support, and ad hoc analysis. For the full analyst employer guide across the operations-analyst and ops-support tier, see How to Hire a Legal Operations Analyst.
The Legal Data Analyst owns the broader operational analytics surface. The scope is matter velocity, workload distribution by attorney and practice group, outside counsel performance scorecards beyond just spend, demand forecasting from business signals, and BI dashboard ownership across the full legal ops function. The primary screen is SQL fluency and BI tool ownership — not legal background. This is a data role that happens to live in a legal department, not a legal role that happens to use data.
What makes the hire difficult is that the data infrastructure in most legal departments is behind what the role requires. Matter management data is often understructured. The e-billing data lives in a separate system. There is no unified data warehouse. The Legal Data Analyst either inherits a structured environment or builds one — and getting clear about which before the search starts changes the seniority and the comp band you need.
When to make your Legal Data Analyst hire
The Data Analyst hire is warranted when the legal department has data but cannot use it to make decisions. The specific signals:
- Legal leadership is making decisions based on feel rather than numbers. If the GC says “we seem to have more M&A work lately” rather than “M&A matters are up 34 percent this quarter,” the data exists in the matter management system but nobody is structured enough to extract it.
- You have a matter management system with data nobody is using. Most matter management platforms produce more structured data than legal departments consume. The Data Analyst is the function that consumes it.
- The GC or CFO is asking for a dashboard. A specific request for a legal operations dashboard, a matter velocity report, or a workload distribution view is the clearest signal that the Data Analyst role is overdue.
- The Legal Spend Analyst exists but is overwhelmed. If your Spend Analyst is doing e-billing, accruals, and also trying to build matter velocity dashboards and workload distribution reports, the spend and operations analytics are competing for one person’s time. The right answer is a second hire, not a longer workday.
- Demand forecasting is a priority. Legal departments that want to forecast next quarter’s legal workload from business signals — deal pipeline, sales bookings, headcount growth — need a Data Analyst who can model the relationship between business inputs and legal demand outputs.
- Outside counsel performance reviews are overdue. Scorecards that measure cycle time, matter outcomes, and billing compliance against expectations require data extraction, structuring, and visualization that is properly Data Analyst work, not manager work.
If the department does not yet have a matter management system that produces structured data, the Data Analyst hire is premature. Hire the systems infrastructure first. A Data Analyst hired into an environment of spreadsheets and email will spend their time on ETL and never reach the analysis.
What a Legal Data Analyst actually does
The role owns the operational analytics surface of the legal department. The specific portfolio depends on team maturity and what data infrastructure is already in place.
- Matter velocity analysis. Track time from intake to close by matter type, practice area, and complexity. Identify where matters stall and which workstreams are chronically behind target cycle times.
- Workload distribution. Map active matter load by attorney and practice group. Identify over-capacity situations before they become attrition risks. Provide the GC with a defensible view of who is working on what.
- Outside counsel performance scorecards. Beyond spend — cycle time per firm, matter outcomes, billing compliance rate, staffing ratio relative to expectations. Build the scorecard the GC uses in firm reviews.
- Demand forecasting. Model the relationship between business inputs (deal pipeline, headcount growth, sales bookings) and legal demand outputs (contracts volume, M&A work, employment matters). Produce a quarterly forecast the legal ops manager can use to plan hiring and outside counsel capacity.
- BI dashboard ownership. Design, build, and maintain the legal ops dashboards in the BI tool (Tableau, Power BI, Looker, or equivalent). Own the underlying data model, not just the visual layer.
- Data governance and quality. Maintain the data dictionary for legal data assets. Flag data quality issues upstream when matter management or e-billing data is inconsistent. Partner with IT and the systems admin to fix the inputs, not just the output reports.
- Ad hoc analysis. Answer specific questions from the GC, CFO, or legal ops manager: which practice area grew fastest this year, what is our average time to first draft on NDA requests, how does our outside counsel cycle time compare to industry benchmarks.
For the full role profile at the analyst and ops-support tier, the Legal Operations Analyst & Ops Support Career Guide 2026 covers how analysts enter the field and what skills differentiate data-forward candidates. The Analyst & Ops Support Interview Questions 2026 guide has scenario questions specifically for the data and analytics side of legal ops hiring.
Job description template
This template is written for a mid-level Data Analyst with SQL and BI tool ownership as hard requirements. For an entry-level hire where data modeling will be built over time, soften the data warehouse requirement. For a senior hire with forecasting and data strategy scope, add the advanced analytics and business partnership bullets.
Job Description Template — Legal Data Analyst
Role Overview
[Company Name] is hiring a Legal Data Analyst to own the operational analytics layer of our in-house legal team. You will build and maintain dashboards for matter velocity, workload distribution, and outside counsel performance, run demand forecasting from business inputs, own the data quality of our legal data assets, and produce the analysis the GC and legal ops leadership use to make resourcing, vendor, and planning decisions. This role reports to the [Legal Operations Manager / Director of Legal Operations].
What You Will Own
- Matter velocity dashboards — time from intake to close by type, practice area, and complexity
- Workload distribution reports — active matter load by attorney and practice group
- Outside counsel performance scorecards — cycle time, billing compliance, staffing ratio, outcome tracking
- Demand forecasting — model the relationship between business signals and legal workload
- BI dashboard ownership in [Tableau / Power BI / Looker] — data model through visual layer
- Data governance — maintain the data dictionary, flag data quality issues, partner with IT on upstream fixes
- Ad hoc analysis for the GC, CFO, and legal ops leadership
Required
- 2–6 years of data analysis, business intelligence, or operations analytics experience
- SQL fluency — you write your own queries, validate your own data, and debug your own pipelines without help
- Hands-on proficiency in [Tableau / Power BI / Looker] — dashboard design through data model ownership
- Strong data quality instincts — you notice when the numbers are wrong before anyone else does
- Clear written and verbal communication — you can explain what a chart means to a GC who does not think in data
Preferred
- Experience with legal data systems (matter management, e-billing, CLM) or adjacent structured environments (healthcare ops, financial services)
- Python or R for statistical analysis and automation
- dbt or equivalent data transformation framework experience
- Data warehouse experience (Snowflake, BigQuery, Redshift, or equivalent)
- Forecasting or demand modeling experience
Compensation
Base salary $[X]–$[Y] depending on experience, plus [8–12]% annual bonus target [and equity]. Full benefits including [list]. We publish our comp bands and will not ask for prior salary history.
The single most important JD decision: make SQL a hard requirement, not a preferred. A Data Analyst who cannot write SQL will hit a wall at the first data quality problem and require engineering support for work the role is supposed to handle autonomously. “Preferred” signals you will accept someone who cannot, and you will get exactly that.
Where to source candidates
The Legal Data Analyst pool is broader than most legal ops roles because SQL and BI fluency transfer from adjacent industries. The risk is not volume — it is filtering for the analytical depth that justifies the hire.
Channels that produce Data Analyst hires
- HireLegalOps. Reaches candidates targeting legal ops analytics specifically, including data professionals who want to move into a legal context.
- LinkedIn with role-specific Boolean searches. Search for “data analyst” or “business intelligence analyst” filtered to legal industry, healthcare, financial services, or professional services — industries where the data rigor and analytical depth transfer directly.
- dbt community. The data build tool community (getdbt.com) is the best single source for data analysts with data modeling depth. Candidates who use dbt professionally have demonstrated data transformation and modeling discipline that matters for BI ownership.
- Tableau and Power BI user communities. Both platforms have active community forums where candidates with genuine tool depth are visible. A data analyst who has published a Tableau Public visualization or contributed to Power BI community forums has demonstrated real fluency, not just resume fluency.
- Operations analytics communities. Healthcare operations analytics, financial services business intelligence, and consulting firm data analyst alumni networks all produce candidates with the structured data thinking legal ops needs. Legal context is learnable; data rigor is not.
- General data analyst job boards. Produce volume but require a specific JD with hard SQL and BI requirements to filter usefully. The “SQL preferred” JD will draw hundreds of weak-SQL candidates from these boards.
Candidates from healthcare operations analytics and financial services operations analytics are the most productive adjacent sources. The data environments are similarly structured (multiple source systems, compliance-sensitive data, stakeholders who do not think in data) and the skills transfer directly. Legal context adds 60 to 90 days of domain learning, not a year.
Compensation benchmarks
Legal Data Analyst compensation reflects the technical depth of the role and the premium for SQL fluency and BI tool ownership. The table below reflects US national medians; HCOL metros add 10 to 15 percent.
| Experience Level | Base Salary Range | Bonus Target | Notes |
|---|---|---|---|
| Entry-to-mid analyst (1–3 years) | $80,000 – $95,000 | 6–8% | SQL competent; BI tool user; adjacent industry analytics background; data models not yet owned end-to-end |
| Mid-level analyst (3–5 years) | $95,000 – $130,000 | 8–12% | SQL proficient; BI dashboard ownership; data modeling experience; can validate and fix data quality issues autonomously |
| Senior analyst (5–8 years) | $130,000 – $165,000 | 10–15% | Advanced SQL; dbt or data modeling framework experience; data warehouse ownership; forecasting depth; business partner to GC and CFO |
Python or R fluency adds a premium at mid-level and above, particularly for roles with demand forecasting scope. Equity at growth-stage companies is common from mid-level up. Full role-by-role compensation data with source citations is in the Legal Operations Salary Report 2026.
Anchoring below the $95,000 to $130,000 band for a role expected to own dashboards, data models, and quality validation typically produces a candidate who can run existing reports but cannot build reliable new ones. The data modeling layer — the foundation the dashboards sit on — requires mid-level depth and mid-level pay to get right.
Interview rubric for employers
The right interview checks whether the candidate can own the data layer — modeling, quality, and governance — not just build charts on top of data someone else prepared. Look for four dimensions:
- Data modeling discipline. Can they describe the underlying data model that makes a dashboard trustworthy — not just what the dashboard shows?
- Data quality instincts. Can they articulate how they validate that a data source is trustworthy before building anything on top of it?
- SQL fluency under pressure. Can they write SQL that handles joins, aggregations, window functions, and null handling without looking it up?
- Stakeholder translation. Can they explain what a dashboard means to a GC who does not think in data, without oversimplifying to the point of dishonesty?
Employer-side interview questions
Walk me through a dashboard you built from scratch — from data model through final delivery to a non-technical stakeholder.
Strong answer: starts with the data sources and how they were joined, describes the transformations applied, explains the design choices in the visual layer, and ends with how the stakeholder actually used it. Weak answer: describes what the dashboard shows without touching the underlying model.
How do you validate that a data source is trustworthy before building a report on top of it?
Strong answer: names specific checks (null rates on key fields, row counts vs expected volumes, join key integrity, date range coverage, comparison to a known-good source). Weak answer: says they check that the data “looks right” or ask the data owner.
Write a SQL query that gives me matter count by practice area and attorney for the trailing 12 months, excluding matters that were closed in the first 7 days. Whiteboard or paper is fine.
Strong answer: writes a clean query with the correct date filter, a GROUP BY clause, and correct handling of the exclusion condition. No hints needed. Weak answer: sketches a query but is unsure about the date arithmetic or the exclusion logic.
Our matter management data has 35 percent null values in the practice area field. How do you handle it for a workload distribution dashboard?
Strong answer: does not impute or ignore — surfaces the null rate in the dashboard, works upstream to understand why the field is missing, and tags it as a data quality issue for the systems admin or matter management owner to fix. Weak answer: excludes nulls from the report without surfacing the gap.
The business unit asks for a “quick report” that would take you 3 days to do properly. What do you do?
Strong answer: scopes what “quick” means to them, offers a rough estimate with known caveats in 30 minutes if they need something immediately, and delivers the reliable version on the proper timeline with an explanation of the difference. Weak answer: builds the quick version without surfacing that it is unreliable.
How would you approach building a demand forecast for next quarter’s legal workload?
Strong answer: identifies business leading indicators (deal pipeline, headcount plan, sales bookings), maps historical correlation to legal demand, chooses a modeling approach that fits the data volume, and names the uncertainty band they would attach to the forecast. Weak answer: says they would use last quarter as the baseline and add a growth percentage.
What would your first 30 days look like if we gave you this role tomorrow?
Strong answer: audits the existing data sources, maps the data model currently in use, identifies the highest-confidence data (and the lowest), and proposes a prioritized dashboard roadmap based on what leadership needs most and what the data can actually support. Weak answer: waits to be told which dashboards to build.
Red flags in candidates
Patterns to watch for in Data Analyst interviews:
- Cannot explain how a JOIN works in their own words. A Data Analyst who cannot explain join logic fluently — without looking at a cheat sheet — cannot debug a data model when it produces wrong results at 9pm before a board presentation.
- Has never fixed a broken data pipeline. Candidates who have only worked in clean, pre-modeled data environments cannot handle the messy source data reality of most legal departments.
- Describes dashboards as “the pretty part.” This signals the candidate has always worked downstream of someone else’s data model. The data model is the job; the dashboard is the output.
- Cannot name the BI tool they would reach for first and explain why. A data analyst without a strong tool opinion has not built anything significant in any tool.
- Excludes nulls without explaining why. Excluding problematic data without surfacing it to stakeholders is how dashboards become confidently wrong.
Common hiring mistakes
Three mistakes account for most Legal Data Analyst hiring failures:
- Hiring without giving them a real data warehouse or trusted source-of-truth. This is the highest-cost mistake. Analysts hired into environments where every extract requires a manual pull from matter management and a separate pull from e-billing spend their time on ETL, not analysis. Strong analysts leave these environments within 12 months. Before the search starts, be honest about the data infrastructure. If it is not ready, either fund a data warehouse project alongside the hire or accept that the first year is infrastructure work.
- Making SQL optional. Every Data Analyst JD where SQL is “preferred” eventually produces a hire who cannot validate their own data, cannot fix a broken query, and cannot build a new data model without engineering help. That is not a Data Analyst — it is a BI tool operator who depends on someone else for the foundation. Make SQL required and enforce it with a whiteboard question.
- Confusing this role with a Legal Spend Analyst. If the primary need is e-billing, accruals, and outside counsel rate analysis, hire a Spend Analyst. If the need is matter velocity, workload distribution, outside counsel performance scorecards, and demand forecasting, hire a Data Analyst. Asking the same person to own deep e-billing compliance and broad operational analytics is asking for two distinct jobs from one budget line.
For the full pattern library across all legal ops hiring roles, the Common Hiring Mistakes guide covers each stage from sourcing through onboarding with specific intervention points.
Offer structure and onboarding
Typical comp structure
A Legal Data Analyst offer at the mid-level includes base salary, a meaningful annual bonus target, and equity at growth-stage companies from the mid-level band up. The single most important retention factor at this level is not comp — it is whether the data infrastructure can support the work. Analysts hired into clean, structured environments with real dashboards to build stay. Analysts hired into spreadsheet-and-email environments doing manual ETL leave when a better environment recruits them, which happens fast.
Professional development that retains Data Analysts: BI tool certification (Tableau Desktop Certified Professional, Microsoft Power BI Data Analyst certification), dbt training if not already familiar, and visibility into forecasting and statistical modeling methodologies. Strong data analysts grow into Senior Analysts, Analytics Leads, and eventually Legal Operations Managers or Directors. Show the path.
First-90-days plan
- Days 1–30: Data inventory and quality audit. Map every data source the legal department produces or consumes. Assess quality (null rates, join key integrity, date coverage). Produce a one-page inventory that names what can be trusted and what cannot. This is the foundation everything else is built on.
- Days 31–60: First dashboard. Ship the single most-requested dashboard based on the highest-quality data from the inventory. Build the data model explicitly, document it, and walk the GC or legal ops manager through how the underlying data produces the numbers on screen.
- Days 61–90: Data model foundation and roadmap. Propose the data model that will underlie the next six months of dashboard work. Name the data quality issues that need to be resolved upstream before certain analytics are possible, and identify the owners responsible for fixing them.
Measuring success at month 6
- At least two dashboards are in weekly use by the GC or legal ops manager without the analyst having to explain the numbers each time
- The data dictionary exists and covers all primary legal data sources
- Data quality issues have been escalated and at least one has been fixed upstream
- The analyst can answer an ad hoc question from the GC within 24 hours without requiring a new data source
- Legal leadership is making at least one resourcing or vendor decision per quarter that references an analyst-produced output
Common employer questions answered
How long does it typically take to hire a Legal Data Analyst?
Plan for 4 to 8 weeks from posting to accepted offer. The pool is broader than KM or senior legal ops roles because SQL and BI fluency transfer from adjacent industries. The search moves faster when the JD names the specific BI tools the role will own and makes SQL a hard requirement, not a preference.
How is this role different from a Legal Spend Analyst?
The Spend Analyst owns the financial analytics layer: e-billing, LEDES review, UTBMS coding, accruals, spend forecasting, and outside counsel rate analysis. The Data Analyst owns the broader operational analytics surface: matter velocity, workload distribution, outside counsel performance scorecards beyond spend, demand forecasting, and BI dashboard ownership across the full legal ops function. Spend analysis is one slice of what a Data Analyst covers — if that slice is all you need, hire a Spend Analyst.
How is this role different from a Legal Operations Analyst?
The Operations Analyst at the entry-to-mid level does a mix of quantitative work and operational coordination: intake metrics, process documentation, dashboard support, and ad hoc analysis. The Data Analyst is explicitly data-first: BI dashboard ownership, data modeling, data quality governance, demand forecasting. The primary screen for an Operations Analyst is process discipline and analytical clarity. The primary screen for a Data Analyst is SQL fluency and BI tool ownership.
What should we pay a Legal Data Analyst?
National base salaries range from $80,000 to $165,000. Entry-to-mid (1–3 years, SQL competent, BI user) lands $80,000 to $95,000. Mid-level (3–5 years, SQL proficient, dashboard ownership, data modeling experience) sees $95,000 to $130,000. Senior (5–8 years, advanced SQL, data warehouse experience, forecasting depth) reaches $130,000 to $165,000. HCOL metros add 10 to 15 percent. Python or R fluency adds a premium at mid-level and above.
Is SQL required or just preferred?
Required. A Data Analyst who cannot write SQL cannot validate their own data, cannot debug a broken pipeline, and cannot build a new data model without engineering help. “SQL preferred” in a Data Analyst JD signals you will accept a BI tool operator who depends on someone else for the foundation. That is a different hire at a different price point. If SQL is genuinely optional for this role, you need a reporting analyst, not a data analyst.
Does this hire need a legal background?
No. The analytical stack — SQL, data modeling, BI tool fluency, data quality discipline — is what matters. Legal context is learnable in 60 to 90 days. Filtering on legal background at this level cuts the pool without raising the quality of hires. Candidates from healthcare operations analytics and financial services business intelligence often bring more rigorous data discipline than candidates from legal-adjacent roles with weaker SQL.
What are the most common hiring mistakes?
Hiring without a real data warehouse is the most expensive mistake — analysts in manual-ETL environments do not reach the analysis layer and leave. Making SQL optional is the most common mistake — it produces a BI tool operator, not a Data Analyst. Confusing this role with a Spend Analyst is the third — if e-billing is the need, hire a Spend Analyst; if broad operational analytics is the need, hire a Data Analyst.
Where should we source candidates?
HireLegalOps for candidates targeting legal ops analytics. LinkedIn with Boolean searches on “data analyst” or “business intelligence analyst” filtered to legal industry or adjacent industries (healthcare, financial services, professional services). dbt community for candidates with data modeling depth. Tableau and Power BI communities for BI-tool-fluent candidates. Operations analytics alumni networks from adjacent industries where data rigor transfers directly.
What interview question separates strong Data Analyst candidates fastest?
Give them a whiteboard and ask them to write a SQL query from a real-world prompt — matter count by practice area and attorney for the trailing 12 months, excluding short-lived matters. Strong candidates write the query confidently, explain their choices, and ask clarifying questions about edge cases. Candidates who hesitate on the date arithmetic or the exclusion logic do not have the SQL depth the role requires.
Ready to find your Legal Data Analyst? Post your opening on HireLegalOps to reach legal operations and data analytics candidates. For related hiring guides: How to Hire a Legal Spend Analyst, How to Hire a Legal Operations Analyst, and How to Hire a Legal Operations Manager.
Post a legal ops job