Legal Spend Analyst & Architect

As the Legal Spend Analyst / Architect, you will codify key spend analytics definitions and business logic to enable consistent, auditable insights. You'll translate complex data definitions into modern data and analytics models, driving actionable observations for senior legal and executive audiences. You will help migrate from Excel-centric workflows to dbt-based structures, ensuring data accuracy and clear storytelling. This role offers scale and impact by shaping how legal spend is analyzed and acted upon across the organization.

• Own the core business definitions and calculation methods for legal spend analysis (e.g., Average Blended Rate, Disputed Fees, Total Spend) in code logic.
• Audit legacy Excel files and PowerPoint decks; refactor data definitions into modern data/analytics paradigms (e.g., dbt models).
• Validate analyses of client data using traditional calculations (SQL) and AI tools.
• Support reporting and storytelling for senior legal and C-suite audiences.

• Domain expertise in Legal Operations, Billing Management, or Spend Analysis.
• Familiarity with SQL and Python to understand engineering work.

• Clear communication of technical concepts to stakeholders
• Curiosity about AI data consumption and avoidance of hallucinations
• Ability to work with large CSV/Parquet datasets
• SQL
• Python
• dbt (data modeling)