Senior Legal Business Intelligence Analyst

Socket.dev; Seattle (WA); On-site; USD 156,000 - 218,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

Parental leave & family benefits

Global wellness program

Education reimbursement

Talent development

Profit-sharing opportunity

Job summary

MoFo seeks a Senior Legal BI Analyst to design and maintain dashboards and analytics for complex legal matters in Seattle. You will work with attorneys, clients, and eDiscovery teams to translate needs into scalable data workflows and actionable insights.

You will lead data modeling, ETL/ELT processes, and governance, while exploring AI-assisted analytics and responsible automation to improve reporting and decision making.

Qualifications

• Bachelor's degree in quantitative field.
• Four+ years of BI, analytics, data engineering, or legal analytics.
• Experience deploying enterprise BI for legal/financial data tasks.
• Ability to translate open-ended requirements into analytical solutions.

Responsibilities

• Design, develop, and maintain dashboards, reports, and scorecards for legal, financial, operational, and matter data.
• Analyze large datasets and perform ad hoc analysis for clients, attorneys, and leadership.
• Develop KPIs, metrics, visual templates, and reporting conventions.
• Develop self-service analytics that consolidate data, dashboards, and documentation.
• Replace manual reporting with automated solutions and quantify impact.

Skills

SQL

Window functions

Query optimization

Python

R

Data governance

Data quality

Education

Bachelor's degree

Advanced degree

Tools

MicroStrategy

Power BI

Tableau

QuickSight

Job description

Overview

At MoFo, we couldn’t write our own success story without yours.Ready to write your story?

Join MoFo as a SENIOR LEGAL BUSINESS INTELLIGENCE ANALYSTin our Seattle office!

https://www.mofo.com/offices

ABOUT THE ROLE

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.

Business Intelligence and Data Analytics

1. Design, develop, and maintain dashboards, reports, and scorecards for legal, financial, operational, and matter data.
2. Analyze large and complex datasets and perform ad hoc analysis in response to client, attorney, and leadership requests.
3. Develop and standardize key performance indicators, metrics, visual templates, and reporting conventions.
4. Develop self-service analytics capabilities that consolidate data, dashboards, and documentation for stakeholder use.
5. Replace manual, spreadsheet-based reporting with automated solutions and quantify the resulting impact.

Data Management and Technical Solutions

1. Develop and optimize data models, queries, integrations, and ETL/ELT processes using SQL and comparable tools.
2. Work with technology teams and data owners to integrate disparate systems into reliable analytical datasets.
3. Establish data definitions, business rules, lineage, and quality controls, and resolve data-quality issues proactively.
4. Follow structured development and change-management practices, including development, test, and production promotion.
5. Develop solutions in accordance with firm technology, security, confidentiality, and data governance requirements.

Legal and Client Analytics

1. Partner with attorneys and legal professionals to translate matter and client objectives into analytical requirements.
2. Develop analytics for matter activity, litigation and discovery metrics, financial performance, and resource utilization.
3. Analyze outside counsel and vendor spend to surface cost trends, budget variances, and optimization opportunities.
4. Develop customized reporting for strategic clients and extend successful solutions to additional matters and firm functions.
5. Prepare executive-ready summaries and KPI scorecards for firm and client senior leadership.

Artificial Intelligence and Innovation

1. Evaluate and apply emerging analytics, automation, and generative AI capabilities to appropriate use cases.
2. Develop AI-assisted workflows for classification, pattern identification, anomaly detection, and reporting.
3. Identify opportunities for responsible use of AI while maintaining appropriate human oversight and validation.

Consulting and Process Improvement

1. Serve as a technical and analytical consultant to attorneys, clients, eDiscovery professionals, and firm leadership.
2. Translate open-ended business questions into defined analytical requirements, project plans, and technical solutions.
3. Develop documentation, standards, and training materials for analytical tools and solutions.

ABOUT YOU

Education and Experience

1. Bachelor's degree required, preferably in business analytics, data science, computer science, economics, statistics, or a related quantitative discipline.
2. Four or more years of progressive experience in business intelligence, data analytics, data engineering, or legal operations analytics.
3. Experience designing and deploying enterprise business intelligence solutions for legal, financial, or other data-intensive functions.
4. Experience translating open-ended requirements from non-technical stakeholders into defined analytical solutions.

Technical Skills

1. Advanced proficiency with SQL, including window functions, common table expressions, and query optimization.
2. Strong experience with enterprise business intelligence platforms such as MicroStrategy, Power BI, Tableau, or QuickSight.
3. Experience building ETL/ELT pipelines and relational and dimensional data models, including star schema design.
4. Working proficiency with Python, R, or a comparable language for automation and statistical analysis.
5. Knowledge of data quality, governance, lineage, business rules, and analytical documentation practices.

Preferred

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

ABOUT MOFO

At MoFo, we collaborate as one firm, across borders, practice areas, and business functions and value fresh ideas and innovation over conformity and competition.

• About Us:https://www.mofo.com/about
• Inclusion + Engagement:https://www.mofo.com/community/we-at-mofo
• Commitment to Pro Bono:https://www.mofo.com/community/pro-bono
• The MoFo Foundation:https://www.mofo.com/culture/mofo-foundation

ABOUT OUR BENEFITS

MoFo offers a comprehensive benefits package starting on your first day.

• Avariety of options for medical, dental, vision, life and disability coverage to meet the needs of you and your family.
• 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 to make an impact on your community and a birthday holiday just for fun.
• Education reimbursement annually.
• Dedicated Talent Development team.
• Competitive annual profit-sharing contribution.

Where required by law, salary ranges are stated below. Additional compensation may include a discretionary bonus, overtime as applicable, health/welfare benefits, retirement contributions, paid holidays, and PTO. The range displayed is specifically for positions performed in those cities/states and may vary based on factors including but not limited to the following: local market data and ranges; an applicant's skills and prior relevant experience; and certain degrees, licensing, and certifications. We will consider qualified applicants with criminal histories in a manner consistent with all applicable federal, state, and local laws, including Fair Chance Laws and Ordinances.

Seattle salary range: $156k to $218k

For questions regarding this position, please e-mail [e-mail]