Senior Business Intelligence Analyst

Smith Anderson; Raleigh (NC); On-site; USD 80,000 - 110,000; Full time

Job summary

A mid-sized law firm seeks a Senior Business Intelligence Analyst to lead financial reporting initiatives and transform data into actionable insights. The ideal candidate will have strong SQL and Power BI skills, with a focus on enhancing reporting processes and conducting profitability analyses.

Benefits

Medical insurance

Vision insurance

401(k)

Disability insurance

Qualifications

• 5+ years of experience in financial analysis and business intelligence.
• Advanced proficiency in Microsoft Power BI and SQL.
• Understanding of law firm accounting principles.

Responsibilities

• Develop and maintain advanced financial reports and dashboards using Power BI.
• Conduct detailed practice area analyses and identify performance insights.
• Support financial systems upgrades and implementations.

Skills

SQL

DAX

Power BI

Financial Analysis

Data Analysis

Communication

Education

Bachelor’s degree in finance, data analytics, accounting, or related discipline

Tools

3E Cloud

Data Insights

Job description

Join to apply for the Senior Business Intelligence Analyst role at Smith Anderson

Join to apply for the Senior Business Intelligence Analyst role at Smith Anderson

Direct message the job poster from Smith Anderson

JOB TITLE: Senior Business Intelligence Analyst

STATUS: Exempt

Type: Full Time

Smith Anderson is a well-established and dynamic mid-size law firm, providing top-tier legal services to clients across a range of industries. We value a collaborative, innovative, and inclusive culture where our people are empowered to think big, grow professionally, and make meaningful contributions every day.

We’re looking for a Senior Business Intelligence Analyst who’s equal parts data detective and financial analyst. This is a hands-on, high-impact role where you'll lead our business intelligence and financial reporting initiatives, while diving deep into the analytics yourself. You will lead our business intelligence and reporting initiatives while directly performing much of the analytical work yourself. You will be responsible for transforming our financial data into actionable insights, enhancing reporting processes, conducting profitability analyses, and managing our financial systems.

This position is ideal for a technically skilled professional who enjoys the practical aspects of financial data analysis and system optimization, while also having the interpersonal skills to effectively supervise and collaborate with others. You will leverage your expertise in SQL, DAX, and Power BI, combined with your understanding of law firm economics, to support strategic decision-making across our diverse practice areas.

Our mid-sized firm environment offers the unique advantage of exposure to a full range of business and litigation services, providing rich opportunities for cross-practice analysis and insights. The successful candidate will appreciate the stability and depth of experience our firm offers, along with the satisfaction of building and maintaining critical financial intelligence systems that directly impact firm performance.

Primary Responsibilities:

• Personally develop and maintain advanced financial reports, dashboards, and visualizations using Microsoft Power BI, focusing on timekeeper statistics, matter profitability, and practice area performance metrics.
• Work alongside the Controller during month-end close processes for 3E Cloud, ensuring data integrity and producing monthly financial reporting packages.
• Conduct detailed practice area analyses across our diverse portfolio of business and litigation services, identifying trends and performance insights.
• Create clear, concise visual presentations of financial data tailored to various stakeholders, from practice group leaders to executive management.
• Co-administer financial reporting platforms including 3E Cloud and Data Insights, performing quality assurance reviews and managing user access.
• Develop and optimize SQL queries and DAX expressions to create custom reports aligned with the specific needs of our various practice areas.
• Create documentation for financial reporting procedures to improve workflow efficiencies and establish consistent best practices.
• Support financial systems upgrades and implementations, ensuring minimal disruption to reporting capabilities.
• Analyze WIP and AR trends across multiple dimensions, with particular focus on various fee arrangement types (contingency, fixed fee, hourly, hybrid) and practice areas.
• Support production of reporting for the Compensation Committee, working with highly sensitive attorney performance data.
• Develop financial models to evaluate business decisions across our diverse practice groups.
• Lead special analytical projects addressing evolving business priorities.

Qualifications:

• 5+ years of experience in financial analysis and business intelligence, with at least 2 years in a mid-sized law firm or professional services environment.
• Demonstrated experience working with diverse practice areas and multiple fee arrangement types (hourly, contingency, fixed fee, hybrid arrangements).
• Advanced proficiency in Microsoft Power BI, including data modeling, dashboard design, and DAX formula creation.
• Strong SQL skills with ability to write and optimize complex queries.
• Experience with Elite 3E Cloud and Data Insights platforms preferred.
• Understanding of law firm accounting principles, legal industry KPIs, and profitability metrics across different practice types.
• Ability to balance technical excellence with practical, actionable business insights.
• Strong communication skills with proven ability to explain complex financial concepts to non-financial audiences.
• Previous experience directing or coordinating work of others would be helpful.
• Meticulous attention to detail with a commitment to data accuracy.
• Ability to work independently while managing multiple priorities.

Education:

• Bachelor’s degree in finance, data analytics, accounting, or related discipline or equivalent related work experience.
• Professional certifications in Power BI, SQL, or Data Analysis preferred.

Smith Anderson is an equal opportunity employer committed to creating and maintaining a diverse work force. It is the policy of this Firm to recruit, hire, train, develop, promote, and compensate employees without regard to race, color, religion, gender, sexual orientation, gender identity or expression, age, national origin, genetic information, disability or covered veteran status.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Analyst, Accounting/Auditing, and Finance

• Industries

  Law Practice

Referrals increase your chances of interviewing at Smith Anderson by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

401(k)

Disability insurance

Get notified when a new job is posted.

Sign in to set job alerts for “Business Intelligence Analyst” roles.

Business Analyst/Project Lead - Analytics & Reporting

Application Analyst - Level 2 - Clinical & Business

Business Analyst, Biomechanical Software

Bank Deposit Data Focused Business Analyst

Business Analyst/Project Lead - Application & Agentic

Risk Analyst III (Reporting and SharePoint)

Senior Global Salesforce Marketing & Data Cloud Business Analyst

Lead Business Analyst, Customer Experience

Senior Business Development Analyst - Department of Defense

Business Analyst - Mortgage risk mitigation - Remote, 12 month contract

US Immigration Business Analyst - Associate

US Immigration Business Analyst - Associate

Business Analyst II (nCino/Loan Origination Systems)

Business Analyst - Identity & Access Management

Expert Salesforce Business Analyst - Remote

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.