Build, maintain, and continuously improve dashboards, data sources, reporting standards, and visualization best practices across the firm.
Build executive KPI dashboards.
Give leadership clear visibility into marketing performance, intake productivity, operational KPIs, and firm-wide metrics.
Analyze marketing & lead generation.
Measure performance across Meta Ads, Google Ads, and other channels, and connect spend to outcomes.
Track the full client journey.
Report on lead flow and conversion from generation through intake, retention, and case outcomes, including conversion, qualification, contact, and retained rates, plus agent and team productivity.
Reconcile data & safeguard accuracy.
Validate and reconcile data across Salesforce, HubSpot, RingCentral, advertising platforms, Filevine, and other systems; proactively surface and resolve discrepancies.
Design data models & automate reporting.
Build models that support consistent analytics, and automate recurring reports to cut manual effort.
Deliver insights to leadership.
Produce weekly, monthly, quarterly, and ad hoc reports; present findings and recommendations clearly; identify trends, bottlenecks, and opportunities.
Support strategy.
Partner with leadership to define key metrics, and assist with forecasting, capacity planning, and goal-setting.
Requirements
5+ years in business intelligence, analytics, reporting, data engineering, revenue operations, or marketing analytics.
Advanced, hands-on experience building complex dashboards and data sources in Looker Studio, including executive-level reporting.
Proficiency with SQL and BigQuery for extraction, transformation, querying, and validation.
Experience with Salesforce reporting, dashboards, and data structures.
A track record of reconciling data across multiple systems and resolving data-quality issues.
Advanced Excel and Google Sheets; strong grasp of KPIs and data visualization best practices.
Strong analytical and problem-solving skills, sharp attention to detail, and the ability to explain complex findings simply.
Tech Stack
BigQuery
SQL
Benefits
Paid Time Off (PTO)
Opportunity to work closely with Operations and Leadership in a growing, technology-driven law firm.
Long-term growth and stability in a high-impact role.