Senior Business Intelligence Analyst

Ovation Law Firm

Senior Business Intelligence Analyst responsible for building and maintaining reporting infrastructure for Ovation Law Firm. Analyzing data for key marketing and operational insights using Looker Studio.

Posted 6/1/2026full-timeRemote • 🇮🇳 IndiaSeniorWebsite

Tech Stack

Tools & technologies

BigQuerySQL

About the role

Key responsibilities & impact

Own the Looker Studio environment.
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

What you’ll need

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.

Benefits

Comp & perks

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.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Looker StudioSQLBigQuerySalesforceExcelGoogle Sheetsdata modelingdata reconciliationdata visualizationKPI reporting

Soft Skills

analytical skillsproblem-solving skillsattention to detailcommunication skillsleadershipstrategic thinkingcollaborationpresentation skillsforecastinggoal-setting