Senior Legal Business Intelligence Analyst

Morrison & Foerster, LLP • Seattle, WA

4d • Onsite

About The Position

Develop, implement, and support business intelligence, data analytics, and reporting solutions for legal matters and strategic client initiatives. Work closely with attorneys, clients, eDiscovery professionals, and other stakeholders to translate complex legal and business requirements into actionable insights and scalable analytical workflows. Serve as a subject matter resource for data analysis, visualization, and data-driven decision-making.

Requirements

• Bachelor's degree required, preferably in business analytics, data science, computer science, economics, statistics, or a related quantitative discipline.
• Four or more years of progressive experience in business intelligence, data analytics, data engineering, or legal operations analytics.
• Experience designing and deploying enterprise business intelligence solutions for legal, financial, or other data-intensive functions.
• Experience translating open-ended requirements from non-technical stakeholders into defined analytical solutions.
• Advanced proficiency with SQL, including window functions, common table expressions, and query optimization.
• Strong experience with enterprise business intelligence platforms such as MicroStrategy, Power BI, Tableau, or QuickSight.
• Experience building ETL/ELT pipelines and relational and dimensional data models, including star schema design.
• Working proficiency with Python, R, or a comparable language for automation and statistical analysis.
• Knowledge of data quality, governance, lineage, business rules, and analytical documentation practices.

Nice To Haves

• Advanced degree in business analytics, data science, or a related quantitative discipline.
• Experience with legal operations data, including outside counsel spend and matter analytics, in professional services or a similarly regulated environment.
• Experience building self-service analytics platforms for large groups of non-technical stakeholders.
• Experience developing AI agents, LLM-enabled automation, or prompt-engineered workflows in production.
• Experience with cloud data platforms and transformation tooling such as Redshift, Snowflake, Databricks, or dbt.

Responsibilities

• Design, develop, and maintain dashboards, reports, and scorecards for legal, financial, operational, and matter data.
• Analyze large and complex datasets and perform ad hoc analysis in response to client, attorney, and leadership requests.
• Develop and standardize key performance indicators, metrics, visual templates, and reporting conventions.
• Develop self-service analytics capabilities that consolidate data, dashboards, and documentation for stakeholder use.
• Replace manual, spreadsheet-based reporting with automated solutions and quantify the resulting impact.
• Develop and optimize data models, queries, integrations, and ETL/ELT processes using SQL and comparable tools.
• Work with technology teams and data owners to integrate disparate systems into reliable analytical datasets.
• Establish data definitions, business rules, lineage, and quality controls, and resolve data-quality issues proactively.
• Follow structured development and change-management practices, including development, test, and production promotion.
• Develop solutions in accordance with firm technology, security, confidentiality, and data governance requirements.
• Partner with attorneys and legal professionals to translate matter and client objectives into analytical requirements.
• Develop analytics for matter activity, litigation and discovery metrics, financial performance, and resource utilization.
• Analyze outside counsel and vendor spend to surface cost trends, budget variances, and optimization opportunities.
• Develop customized reporting for strategic clients and extend successful solutions to additional matters and firm functions.
• Prepare executive-ready summaries and KPI scorecards for firm and client senior leadership.
• Evaluate and apply emerging analytics, automation, and generative AI capabilities to appropriate use cases.
• Develop AI-assisted workflows for classification, pattern identification, anomaly detection, and reporting.
• Identify opportunities for responsible use of AI while maintaining appropriate human oversight and validation.
• Serve as a technical and analytical consultant to attorneys, clients, eDiscovery professionals, and firm leadership.
• Translate open-ended business questions into defined analytical requirements, project plans, and technical solutions.
• Develop documentation, standards, and training materials for analytical tools and solutions.

Benefits

• Variety of options for medical, dental, vision, life and disability coverage
• Industry-leading parental leave and family benefits including adoption and fertility treatment options and backup child and elder care
• Global wellness program, including free access to Talkspace and Calm apps
• Annual community service day
• Birthday holiday
• Education reimbursement annually
• Dedicated Talent Development team
• Competitive annual profit-sharing contribution

What This Job Offers

• Job Type: Full-time
• Career Level: Senior